50 lines
3.0 KiB
SQL
50 lines
3.0 KiB
SQL
-- ----------------------------
|
|
-- 1. 料框码规则表（存储料框码起始编码与车间的对应关系）
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `material_frame_rule`;
|
|
CREATE TABLE `material_frame_rule` (
|
|
`id` INT NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|
`start_code` VARCHAR(20) NOT NULL COMMENT '料框码规则匹配编码(第4-7位)',
|
|
`workshop_code` VARCHAR(10) NOT NULL COMMENT '车间编码',
|
|
`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0:正常, 1:已删除(误删可恢复)',
|
|
`create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
`update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `uk_start_code` (`start_code`) -- 起始编码唯一约束
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='料框码规则表';
|
|
|
|
-- ----------------------------
|
|
-- 2. 车间接口配置表（存储车间与接口的映射关系）
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `workshop_interface_config`;
|
|
CREATE TABLE `workshop_interface_config` (
|
|
`id` INT NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|
`workshop_code` VARCHAR(10) NOT NULL COMMENT '车间编码',
|
|
`interface_flag` VARCHAR(50) NOT NULL COMMENT '接口标识',
|
|
`interface_name` VARCHAR(100) NOT NULL COMMENT '接口名称',
|
|
`interface_url` VARCHAR(255) NOT NULL COMMENT '接口URL',
|
|
`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0:正常, 1:已删除(误删可恢复)',
|
|
`create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
|
`update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `uk_workshop_interface` (`workshop_code`, `interface_flag`) -- 车间+接口标识唯一约束
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='车间接口配置表';
|
|
|
|
-- ----------------------------
|
|
-- 3. 初始化示例数据（根据业务需求调整）
|
|
-- ----------------------------
|
|
INSERT INTO `material_frame_rule` (`start_code`, `workshop_code`) VALUES
|
|
('60I1', '601'),
|
|
('60I2', '602'),
|
|
('60I3', '603'),
|
|
('60I4', '604');
|
|
|
|
INSERT INTO `workshop_interface_config` (`workshop_code`, `interface_flag`, `interface_name`, `interface_url`) VALUES
|
|
('601', 'QueryTrayUrl', '料框查询', 'http://10.22.160.9/prod-api/produce/trayQuery/trayComposeInfo'),
|
|
('601', 'unBindTrayUrl', '料框解绑', 'http://10.22.160.9/prod-api/api/fms/mp/unbindWholeTray'),
|
|
('602', 'QueryTrayUrl', '料框查询', 'http://10.22.160.84/prod-api/produce/trayQuery/trayComposeInfo'),
|
|
('602', 'unBindTrayUrl', '料框解绑', 'http://10.22.160.84/prod-api/api/fms/mp/unbindWholeTray'),
|
|
('603', 'QueryTrayUrl', '料框查询', 'http://10.22.160.7/prod-api/produce/trayQuery/trayComposeInfo'),
|
|
('603', 'unBindTrayUrl', '料框解绑', 'http://10.22.160.7/prod-api/api/fms/mp/unbindWholeTray'),
|
|
('604', 'QueryTrayUrl', '料框查询', 'http://10.22.160.160/prod-api/produce/trayQuery/trayComposeInfo'),
|
|
('604', 'unBindTrayUrl', '料框解绑', 'http://10.22.160.160/prod-api/api/fms/mp/unbindWholeTray'); |