product-inventory-management-after.git

			@@ -276,3 +276,102 @@

			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',
			`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,
			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
			) 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;

			-- ----------------------------
			-- 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;