product-inventory-management-after.git

			@@ -177,27 +177,254 @@
			DROP COLUMN `data_sync_type`,
			MODIFY COLUMN `data_source_type` tinyint NULL DEFAULT 1 COMMENT 'æ°æ®æ¥æºç±»åï¼1=ééåæ¥ 2=æå¨æ°å¢' AFTER `form_modified_time`;

			-- å é¤æ§è¡¨
			DROP TABLE IF EXISTS `base_param`;
			DROP TABLE IF EXISTS `product_process_param`;

			CREATE TABLE `base_param`
			(
			id BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT 'ä¸»é®ID',
			param_key VARCHAR(100) NOT NULL COMMENT 'åæ°å¯ä¸æ è¯',
			param_name VARCHAR(100) NOT NULL COMMENT 'åæ°åç§°',
			param_type TINYINT NOT NULL COMMENT 'åæ°ç±»å(1æ°å 2ææ¬)',
			value_mode TINYINT DEFAULT 1 COMMENT 'å¼æ¨¡å¼(1åå¼ 2åºé´)',
			unit VARCHAR(50) COMMENT 'åä½',
			default_value VARCHAR(200) COMMENT 'é»è®¤å¼(åå¼åæ°)',
			default_min DECIMAL(10, 2) COMMENT 'é»è®¤æå°å¼(åºé´åæ°)',
			default_max DECIMAL(10, 2) COMMENT 'é»è®¤æå¤§å¼(åºé´åæ°)',
			is_required TINYINT DEFAULT 0 COMMENT 'æ¯å¦å¿å¡«(0å¦ 1æ¯)',
			remark VARCHAR(255) COMMENT 'å¤æ³¨',
			create_user VARCHAR(64) COMMENT 'åå»ºäºº',
			create_time DATETIME COMMENT 'åå»ºæ¶é´',
			update_user VARCHAR(64) COMMENT 'ä¿®æ¹äºº',
			update_time DATETIME COMMENT 'ä¿®æ¹æ¶é´',
			tenant_id BIGINT NOT NULL COMMENT 'ç§æ·ID'
			) COMMENT = 'åºç¡åæ°å®ä¹è¡¨';
			`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ä¸»é®ID',
			`param_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'åæ°å¯ä¸æ è¯',
			`param_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'åæ°åç§°',
			`param_type` tinyint NOT NULL COMMENT 'åæ°ç±»å(1æ°å 2ææ¬ 3ä¸æéæ© 4æ¶é´)',
			`param_format` varchar(255) DEFAULT NULL COMMENT 'åæ°æ ¼å¼',
			`value_mode` tinyint DEFAULT '1' COMMENT 'å¼æ¨¡å¼(1åå¼ 2åºé´)',
			`unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'åä½',
			`is_required` tinyint DEFAULT '0' COMMENT 'æ¯å¦å¿å¡«',
			`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'å¤æ³¨',
			`create_user` varchar(64) DEFAULT NULL COMMENT 'åå»ºäºº',
			`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'åå»ºæ¶é´',
			`update_user` varchar(64) DEFAULT NULL COMMENT 'ä¿®æ¹äºº',
			`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'ä¿®æ¹æ¶é´',
			`tenant_id` bigint DEFAULT NULL COMMENT 'ç§æ·ID',
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE = InnoDB
			AUTO_INCREMENT = 10
			DEFAULT CHARSET = utf8mb4
			COLLATE = utf8mb4_0900_ai_ci COMMENT ='åºç¡åæ°å®ä¹è¡¨';

			CREATE TABLE `product_process_param`
			(
			`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ä¸»é®ID',
			`process_id` bigint NOT NULL COMMENT 'æå±å·¥åºID (product_process.id)',
			`param_id` bigint NOT NULL COMMENT 'å³èåºç¡åæ°ID (base_param.id)',
			`standard_value` varchar(200) DEFAULT NULL COMMENT 'å¨æ¤å·¥åºè®¾å®çæ åå¼(åå¼æ¨¡å¼)',
			`min_value` decimal(10, 2) DEFAULT NULL COMMENT 'å¨æ¤å·¥åºè®¾å®çæ åæå°å¼(åºé´æ¨¡å¼)',
			`max_value` decimal(10, 2) DEFAULT NULL COMMENT 'å¨æ¤å·¥åºè®¾å®çæ åæå¤§å¼(åºé´æ¨¡å¼)',
			`is_required` tinyint NOT NULL DEFAULT '0' COMMENT 'å¨æ¤å·¥åºä¸æ¯å¦å¿å¡«(0-å¦, 1-æ¯)',
			`sort` int NOT NULL DEFAULT '0' COMMENT 'æåºå·',
			`tenant_id` bigint DEFAULT NULL COMMENT 'ç§æ·ID',
			`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'åå»ºæ¶é´',
			`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'æ´æ°æ¶é´',
			PRIMARY KEY (`id`) USING BTREE,
			KEY `idx_process_id` (`process_id`) USING BTREE,
			KEY `idx_param_id` (`param_id`) USING BTREE
			) ENGINE = InnoDB
			AUTO_INCREMENT = 1
			DEFAULT CHARSET = utf8mb4
			COLLATE = utf8mb4_0900_ai_ci COMMENT ='å·¥åºç»å®åæ°è¡¨';

			ALTER TABLE `product_process` MODIFY COLUMN `name` varchar(255) COMMENT 'å·¥åºåç§°';
			ALTER TABLE `product_process` MODIFY COLUMN `no` varchar(255) COMMENT 'å·¥åºç¼å·';
			ALTER TABLE `product_process` ADD COLUMN `status` tinyint(1) DEFAULT '1' COMMENT 'ç¶æï¼0-åç¨ï¼1-å¯ç¨' AFTER `no`;
			ALTER TABLE `product_process` MODIFY COLUMN `type` bigint COMMENT 'ç±»åï¼0-è®¡æ¶ï¼1-è®¡ä»¶';
			ALTER TABLE `product_process` MODIFY COLUMN `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'åå»ºæ¶é´';
			ALTER TABLE `product_process` MODIFY COLUMN `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'ä¿®æ¹æ¶é´';

			ALTER TABLE `product-inventory-management-zsjc`.`customer`
			ADD COLUMN `form_instance_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'å®æè¡¨åå®ä¾ID' AFTER `customer_type`,
			ADD COLUMN `form_modified_time` datetime(0) NULL DEFAULT NULL COMMENT 'å®æä¿®æ¹æ¶é´' AFTER `form_instance_id`;

			ALTER TABLE `process_route`
			ADD COLUMN `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ç¶æï¼0-èç¨¿ï¼1-å·²æ¹å' AFTER `bom_id`;

			CREATE TABLE `process_route_item_param`
			(
			`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ä¸»é®ID',
			`route_item_id` bigint NOT NULL COMMENT 'å³èå·¥èºè·¯çº¿æç»ID (process_route_item.id)',
			`param_id` bigint NOT NULL COMMENT 'å³èåºç¡åæ°å®ä¹ID (base_param.id)',
			`process_param_id` bigint DEFAULT NULL COMMENT 'æ¥æºå·¥åºåæ°ID',

			`standard_value` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'æ¤è·¯çº¿èç¹è®¾å®çæ åå¼',
			`min_value` decimal(10, 2) DEFAULT NULL COMMENT 'æ¤è·¯çº¿èç¹è®¾å®çæ åæå°å¼',
			`max_value` decimal(10, 2) DEFAULT NULL COMMENT 'æ¤è·¯çº¿èç¹è®¾å®çæ åæå¤§å¼',
			`is_required` tinyint NOT NULL DEFAULT '0' COMMENT 'æ¯å¦å¿å¡«',

			`sort` int NOT NULL DEFAULT '0' COMMENT 'æåº',
			`tenant_id` bigint DEFAULT NULL COMMENT 'ç§æ·ID',
			`create_time` datetime DEFAULT CURRENT_TIMESTAMP,
			`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
			PRIMARY KEY (`id`) USING BTREE,
			KEY `idx_route_item_id` (`route_item_id`) USING BTREE,
			KEY `idx_param_id` (`param_id`) USING BTREE
			) ENGINE = InnoDB
			DEFAULT CHARSET = utf8mb4
			COLLATE = utf8mb4_0900_ai_ci COMMENT ='å·¥èºè·¯çº¿å·¥åºåæ°è¡¨';


			ALTER TABLE `product-inventory-management-zsjc`.`quality_inspect`
			ADD COLUMN `inspect_nature` varchar(255) NULL COMMENT 'æ£æµæ§è´¨' AFTER `test_standard_id`,
			ADD COLUMN `sample_code` varchar(255) NULL COMMENT 'è¯æ ·ç¼å·' AFTER `inspect_nature`,
			ADD COLUMN `sample_state` varchar(255) NULL COMMENT 'è¯æ ·ç¶æ' AFTER `sample_code`,
			ADD COLUMN `sample_time` date NULL COMMENT 'åæ ·æ¥æ' AFTER `sample_state`,
			ADD COLUMN `license_plate_number` varchar(255) NULL COMMENT 'è½¦çå·' AFTER `sample_time`;


			ALTER TABLE `product_bom`
			ADD COLUMN `dict_code` bigint NOT NULL COMMENT 'å³èåå¸æ°æ®ç¼ç ï¼sys_dict_data.dict_codeï¼';
			ALTER TABLE `product_bom` ADD INDEX `idx_dict_code` (`dict_code`);

			ALTER TABLE `product-inventory-management-zsjc`.`process_route`
			ADD COLUMN `dict_code` bigint NOT NULL COMMENT 'äº§åç±»ååå¸ç¼ç ' AFTER `status`;


			ALTER TABLE `product-inventory-management-zsjc`.`product_order`
			ADD COLUMN `status` int NULL COMMENT 'ç¶æï¼1.å¾å¼å§ã2.è¿è¡ä¸ã3.å·²å®æã4.å·²åæ¶ï¼' AFTER `plan_complete_time`;

			DROP TABLE IF EXISTS `process_route_item_instance`;
			CREATE TABLE `process_route_item_instance`
			(
			`id` bigint NOT NULL AUTO_INCREMENT,
			`route_id` bigint NOT NULL DEFAULT 0 COMMENT 'å·¥èºè·¯çº¿id',
			`product_model_id` bigint NULL DEFAULT 0 COMMENT 'äº§åid',
			`process_id` bigint NOT NULL DEFAULT 0 COMMENT 'å·¥åºid',
			`tenant_id` bigint NOT NULL COMMENT 'ç§æ·id',
			`create_time` datetime NULL DEFAULT NULL COMMENT 'å½å¥æ¶é´',
			`update_time` datetime NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
			`drag_sort` int NULL DEFAULT NULL COMMENT 'æå¨æåº',
			`is_quality` tinyint(1) NULL DEFAULT 1 COMMENT 'æ¯å¦è´¨æ£å·¥åº',
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE = InnoDB
			AUTO_INCREMENT = 83
			CHARACTER SET = utf8mb4
			COLLATE = utf8mb4_0900_ai_ci COMMENT = 'å·¥èºè·¯çº¿åé-éè¡¨'
			ROW_FORMAT = Dynamic;

			-- ----------------------------
			-- Table structure for process_route_item_param_instance
			-- ----------------------------
			DROP TABLE IF EXISTS `process_route_item_param_instance`;

			CREATE TABLE `process_route_item_param_instance`
			(
			`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ä¸»é®ID',
			`order_id` bigint DEFAULT NULL COMMENT 'çäº§è®¢åID',
			`route_item_id` bigint NOT NULL COMMENT 'å³èå·¥èºè·¯çº¿æç»ID (process_route_item.id)',
			`process_param_id` bigint DEFAULT NULL COMMENT 'æ¥æºå·¥åºåæ°ID',
			`param_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'åæ°å¯ä¸æ è¯',
			`param_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'åæ°åç§°',
			`param_type` tinyint NOT NULL COMMENT 'åæ°ç±»å(1æ°å 2ææ¬ 3ä¸æéæ© 4æ¶é´)',
			`param_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'åæ°æ ¼å¼',
			`value_mode` tinyint DEFAULT '1' COMMENT 'å¼æ¨¡å¼(1åå¼ 2åºé´)',
			`unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'åä½',
			`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'å¤æ³¨',
			`standard_value` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'æ åå¼',
			`min_value` decimal(10, 2) DEFAULT NULL COMMENT 'æ¤è·¯çº¿èç¹è®¾å®çæ åæå°å¼',
			`max_value` decimal(10, 2) DEFAULT NULL COMMENT 'æ¤è·¯çº¿èç¹è®¾å®çæ åæå¤§å¼',
			`is_required` tinyint NOT NULL DEFAULT '0' COMMENT 'æ¯å¦å¿å¡«',
			`sort` int NOT NULL DEFAULT '0' COMMENT 'æåº',
			`tenant_id` bigint DEFAULT NULL COMMENT 'ç§æ·ID',
			`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'åå»ºæ¶é´',
			`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'æ´æ°æ¶é´',
			PRIMARY KEY (`id`) USING BTREE,
			KEY `idx_route_item_id` (`route_item_id`) USING BTREE,
			KEY `idx_param_key` (`param_key`)
			) ENGINE = InnoDB
			AUTO_INCREMENT = 1
			DEFAULT CHARSET = utf8mb4
			COLLATE = utf8mb4_0900_ai_ci
			ROW_FORMAT = DYNAMIC COMMENT ='å·¥èºè·¯çº¿å·¥åºåæ°å®ä¾è¡¨';

			-- ----------------------------
			-- Table structure for product_structure_instance
			-- ----------------------------
			DROP TABLE IF EXISTS `product_structure_instance`;
			CREATE TABLE `product_structure_instance`
			(
			`id` bigint NOT NULL AUTO_INCREMENT,
			`parent_id` bigint NULL DEFAULT NULL COMMENT 'ç¶èç¹ID',
			`product_model_id` bigint NULL DEFAULT NULL COMMENT 'äº§åid',
			`process_id` bigint NULL DEFAULT NULL COMMENT 'å·¥åºid',
			`unit_quantity` decimal(16, 4) NOT NULL COMMENT 'åä½äº§åºéè¦æ°é',
			`demanded_quantity` decimal(16, 4) NULL DEFAULT NULL COMMENT 'éæ±æ°é',
			`unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'åä½',
			`tenant_id` bigint NULL DEFAULT NULL COMMENT 'ç§æ·id',
			`bom_id` bigint NOT NULL COMMENT 'bomçid',
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE = InnoDB
			CHARACTER SET = utf8mb4
			COLLATE = utf8mb4_0900_ai_ci COMMENT = 'BOMåé-éè¡¨'
			ROW_FORMAT = Dynamic;

			SET FOREIGN_KEY_CHECKS = 1;


			ALTER TABLE `process_route_item_instance`
			ADD COLUMN `order_id` bigint NOT NULL COMMENT 'çäº§è®¢åid' AFTER `id`,
			ADD INDEX `idx_order_id` (`order_id`);

			ALTER TABLE `process_route_item_param_instance`
			ADD COLUMN `order_id` bigint NOT NULL COMMENT 'çäº§è®¢åid' AFTER `id`,
			ADD INDEX `idx_order_id` (`order_id`);

			ALTER TABLE `product_structure_instance`
			ADD COLUMN `order_id` bigint NOT NULL COMMENT 'çäº§è®¢åid' AFTER `id`,
			ADD INDEX `idx_order_id` (`order_id`);

			ALTER TABLE `product-inventory-management-zsjc`.`product_order`
			ADD COLUMN `strength` varchar(255) NULL COMMENT 'äº§åç±»å' AFTER `plan_complete_time`;

			CREATE TABLE `product-inventory-management-zsjc`.`sales_delivery` (
			`id` int NOT NULL AUTO_INCREMENT,
			`delivery_date` date NULL COMMENT 'ä¾è´§æ¥æ',
			`delivery_code` varchar(255) NULL COMMENT 'åè´§åç¼å·',
			`project_name` varchar(255) NULL COMMENT 'é¡¹ç®åç§°',
			`delivery_place` varchar(255) NULL COMMENT 'éè´§å°ç¹',
			`link_man` varchar(255) NULL COMMENT 'èç³»äºº',
			`link_phone` varchar(255) NULL COMMENT 'èç³»çµè¯',
			`delivery_remark` varchar(255) NULL COMMENT 'åè´§å¤æ³¨',
			`material_code` varchar(255) NULL COMMENT 'ç©æä»£ç ',
			`product_name` varchar(255) NULL COMMENT 'äº§ååç§°',
			`model` varchar(255) NULL COMMENT 'äº§åè§æ ¼',
			`volume` decimal(10, 4) NULL COMMENT 'æ¹é',
			`unit_price` decimal(10, 2) NULL COMMENT 'åä»·',
			`price` decimal(10, 2) NULL COMMENT 'ä»·æ ¼',
			`product_remark` varchar(255) NULL COMMENT 'äº§åå¤æ³¨',
			`customer` varchar(255) NULL COMMENT 'å®¢æ·åç§°',
			`salesman` varchar(255) NULL COMMENT 'ä¸å¡å',
			`delivery_method` varchar(255) NULL COMMENT 'åè´§æ¹å¼',
			`form_instance_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'å®æè¡¨åå®ä¾ID',
			`form_modified_time` datetime(0) NULL DEFAULT NULL COMMENT 'å®æä¿®æ¹æ¶é´',
			`create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
			`update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
			PRIMARY KEY (`id`)
			) COMMENT = 'éå®åè´§æç»(å®æ)';


			ALTER TABLE product_process_param
			DROP COLUMN param_id;

			ALTER TABLE product_process_param
			ADD COLUMN `param_key` varchar(100) DEFAULT NULL COMMENT 'åæ°å¯ä¸æ è¯',
			ADD COLUMN `param_name` varchar(100) NOT NULL COMMENT 'åæ°åç§°',
			ADD COLUMN `param_type` tinyint NOT NULL COMMENT 'åæ°ç±»å(1æ°å 2ææ¬ 3ä¸æéæ© 4æ¶é´)',
			ADD COLUMN `param_format` varchar(255) DEFAULT NULL COMMENT 'åæ°æ ¼å¼',
			ADD COLUMN `value_mode` tinyint DEFAULT '1' COMMENT 'å¼æ¨¡å¼(1åå¼ 2åºé´)',
			ADD COLUMN `unit` varchar(50) DEFAULT NULL COMMENT 'åä½',
			ADD COLUMN `remark` varchar(255) DEFAULT NULL COMMENT 'å¤æ³¨';

			ALTER TABLE process_route_item_param
			DROP COLUMN param_id;

			ALTER TABLE process_route_item_param
			ADD COLUMN `param_key` varchar(100) DEFAULT NULL COMMENT 'åæ°å¯ä¸æ è¯',
			ADD COLUMN `param_name` varchar(100) NOT NULL COMMENT 'åæ°åç§°',
			ADD COLUMN `param_type` tinyint NOT NULL COMMENT 'åæ°ç±»å(1æ°å 2ææ¬ 3ä¸æéæ© 4æ¶é´)',
			ADD COLUMN `param_format` varchar(255) DEFAULT NULL COMMENT 'åæ°æ ¼å¼',
			ADD COLUMN `value_mode` tinyint DEFAULT '1' COMMENT 'å¼æ¨¡å¼(1åå¼ 2åºé´)',
			ADD COLUMN `unit` varchar(50) DEFAULT NULL COMMENT 'åä½',
			ADD COLUMN `remark` varchar(255) DEFAULT NULL COMMENT 'å¤æ³¨';

			ALTER TABLE `product-inventory-management-zsjc`.`product_structure`
			MODIFY COLUMN `unit_quantity` decimal(20, 15) NOT NULL COMMENT 'åä½äº§åºéè¦æ°é' AFTER `process_id`,
			MODIFY COLUMN `demanded_quantity` decimal(20, 15) NULL DEFAULT NULL COMMENT 'éæ±æ°é' AFTER `unit_quantity`,