CREATE TABLE `erp_material_info` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '物料id',
`material_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '物料编号 全局唯一 遵循规则 内部',
`material_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '物料名称',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '物料备注',
`unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '单位',
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`version` bigint DEFAULT NULL,
`supplier_id` int DEFAULT NULL COMMENT '供应商',
`supplier_material_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '厂商物料号',
`jlc_material_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '立创物料号',
`package_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '封装编号',
`material_type` tinyint DEFAULT NULL COMMENT '物料类型 1:pcb 2:结构 3:电器 5:成品',
`img_path` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '封面图片路径',
`material_status` tinyint DEFAULT NULL COMMENT '物料状态 0:无效 1:生效',
`del_status` tinyint DEFAULT NULL COMMENT '是否删除',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='生产单表'
CREATE TABLE `erp_bom` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'BOMId',
`bom_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'bom编号',
`bom_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`map_type` tinyint DEFAULT NULL COMMENT 'bom针对的类型 1:产品 2:半成品 3:物料',
`map_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '映射的id',
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`version` bigint DEFAULT NULL,
`bom_status` tinyint DEFAULT NULL COMMENT 'bom单状态 0:无效 1:有效',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='生产单表'
CREATE TABLE `erp_bom_ver_info` (
`id` bigint NOT NULL AUTO_INCREMENT,
`bom_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'bomid',
`bom_version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`version` bigint DEFAULT NULL,
`ver_status` tinyint DEFAULT NULL COMMENT '版本状态 0:无效 1:有效',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '版本备注',
`hw_ver_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '硬件版本的Id',
`hw_ver_platform` int DEFAULT NULL COMMENT '硬件版本的平台 同一个平台才能升级',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='生产单表'
CREATE TABLE `erp_bom_detail` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'bom详情Id',
`bom_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'bom编号',
`bom_ver_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'bom版本Id',
`map_type` tinyint DEFAULT NULL COMMENT 'bom针对的类型 1:产品 2:半成品 3:物料',
`map_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '映射的id',
`map_version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '映射对应的版本',
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`version` bigint DEFAULT NULL,
`parent_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父级详情Id',
`quantity` int DEFAULT NULL COMMENT '物料数量',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='生产单表'
这四张表管理,怎么组成bom管理