product-inventory-management-after.git

			@@ -272,4 +272,130 @@

			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_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 = 'éå®åè´§æç»(å®æ)';