product-inventory-management-after.git

			@@ -304,54 +304,36 @@
			-- 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)',
			`param_id` bigint NOT NULL COMMENT 'å³èåºç¡åæ°å®ä¹ID (base_param.id)',
			`process_param_id` bigint NULL DEFAULT NULL COMMENT 'æ¥æºå·¥åºåæ°ID',
			`standard_value` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'æ¤è·¯çº¿èç¹è®¾å®çæ åå¼',
			`min_value` decimal(10, 2) NULL DEFAULT NULL COMMENT 'æ¤è·¯çº¿èç¹è®¾å®çæ åæå°å¼',
			`max_value` decimal(10, 2) NULL DEFAULT NULL COMMENT 'æ¤è·¯çº¿èç¹è®¾å®çæ åæå¤§å¼',
			`is_required` tinyint NOT NULL DEFAULT 0 COMMENT 'æ¯å¦å¿å¡«',
			`sort` int NOT NULL DEFAULT 0 COMMENT 'æåº',
			`tenant_id` bigint NULL DEFAULT NULL COMMENT 'ç§æ·ID',
			`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP,
			`update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
			`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,
			INDEX `idx_route_item_id` (`route_item_id` ASC) USING BTREE,
			INDEX `idx_param_id` (`param_id` ASC) USING BTREE
			KEY `idx_route_item_id` (`route_item_id`) USING BTREE,
			KEY `idx_param_key` (`param_key`)
			) ENGINE = InnoDB
			AUTO_INCREMENT = 178
			CHARACTER SET = utf8mb4
			COLLATE = utf8mb4_0900_ai_ci COMMENT = 'å·¥èºè·¯çº¿å·¥åºåæ°-éè¡¨'
			ROW_FORMAT = Dynamic;

			-- ----------------------------
			-- Table structure for product_process_param_instance
			-- ----------------------------
			DROP TABLE IF EXISTS `product_process_param_instance`;
			CREATE TABLE `product_process_param_instance`
			(
			`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) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'å¨æ¤å·¥åºè®¾å®çæ åå¼(åå¼æ¨¡å¼)',
			`min_value` decimal(10, 2) NULL DEFAULT NULL COMMENT 'å¨æ¤å·¥åºè®¾å®çæ åæå°å¼(åºé´æ¨¡å¼)',
			`max_value` decimal(10, 2) NULL DEFAULT NULL COMMENT 'å¨æ¤å·¥åºè®¾å®çæ åæå¤§å¼(åºé´æ¨¡å¼)',
			`is_required` tinyint NOT NULL DEFAULT 0 COMMENT 'å¨æ¤å·¥åºä¸æ¯å¦å¿å¡«(0-å¦, 1-æ¯)',
			`sort` int NOT NULL DEFAULT 0 COMMENT 'æåºå·',
			`tenant_id` bigint NULL DEFAULT NULL COMMENT 'ç§æ·ID',
			`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'åå»ºæ¶é´',
			`update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'æ´æ°æ¶é´',
			PRIMARY KEY (`id`) USING BTREE,
			INDEX `idx_process_id` (`process_id` ASC) USING BTREE,
			INDEX `idx_param_id` (`param_id` ASC) USING BTREE
			) ENGINE = InnoDB
			AUTO_INCREMENT = 61
			CHARACTER SET = utf8mb4
			COLLATE = utf8mb4_0900_ai_ci COMMENT = 'å·¥åºç»å®åæ°-éè¡¨'
			ROW_FORMAT = Dynamic;
			AUTO_INCREMENT = 1
			DEFAULT CHARSET = utf8mb4
			COLLATE = utf8mb4_0900_ai_ci
			ROW_FORMAT = DYNAMIC COMMENT ='å·¥èºè·¯çº¿å·¥åºåæ°å®ä¾è¡¨';

			-- ----------------------------
			-- Table structure for product_structure_instance
			@@ -376,6 +358,22 @@

			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 'ä¾è´§æ¥æ',