product-inventory-management-after.git

			@@ -1,34 +1,203 @@
			CREATE TABLE `production_plan`
			DROP TABLE IF EXISTS `production_plan`;

			CREATE TABLE production_plan
			(
			`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'èªå¢ä¸»é®',
			`form_instance_id` VARCHAR(64) NOT NULL COMMENT 'è¡¨åå®ä¾ID',
			`serial_no` VARCHAR(64) DEFAULT NULL COMMENT 'åæ®æµæ°´å·',
			`title` VARCHAR(128) DEFAULT NULL COMMENT 'åæ®æ é¢',
			`originator_user_id` VARCHAR(64) DEFAULT NULL COMMENT 'åèµ·äººID',
			`originator_name` VARCHAR(64) DEFAULT NULL COMMENT 'åèµ·äººå§å',
			`biz_create_time` DATETIME DEFAULT NULL COMMENT 'åæ®åå»ºæ¶é´',
			`project_name` VARCHAR(128) DEFAULT NULL COMMENT 'é¡¹ç®åç§°',
			`batch_no` VARCHAR(128) DEFAULT NULL COMMENT 'æ¹æ¬¡å·',
			`contact_person` VARCHAR(128) DEFAULT NULL COMMENT 'èç³»äºº',
			`ext_text1` VARCHAR(128) DEFAULT NULL COMMENT 'é¢ç1',
			`ext_text2` VARCHAR(128) DEFAULT NULL COMMENT 'é¢ç2',
			`material_code` VARCHAR(64) DEFAULT NULL COMMENT 'ç©æç¼ç ',
			`material_category` VARCHAR(64) DEFAULT NULL COMMENT 'ç©æåç±»',
			`spec_desc` VARCHAR(128) DEFAULT NULL COMMENT 'è§æ ¼æè¿°',
			`grade_type` VARCHAR(32) DEFAULT NULL COMMENT 'ççº§',
			`length` DECIMAL(10, 2) DEFAULT NULL COMMENT 'é¿åº¦',
			`width` DECIMAL(10, 2) DEFAULT NULL COMMENT 'å®½åº¦',
			`thickness` DECIMAL(10, 2) DEFAULT NULL COMMENT 'ååº¦',
			`quantity` INT DEFAULT NULL COMMENT 'æ°é',
			`volume` DECIMAL(10, 4) DEFAULT NULL COMMENT 'æ»ä½ç§¯',
			`date_start` DATETIME DEFAULT NULL COMMENT 'å¼å§æ¶é´',
			`date_end` DATETIME DEFAULT NULL COMMENT 'ç»ææ¶é´',
			`association_receipt` TEXT COMMENT 'å³èåæ®',
			`data_sync_type` TINYINT DEFAULT 1 COMMENT 'æ°æ®æ¹å¼: 1=æå¨ 2=å®æ¶',
			`data_source_type` TINYINT DEFAULT 1 COMMENT 'æ°æ®æ¥æº: 1=éå®è®¢å 2=çäº§é¢æµ',
			`create_time` DATETIME DEFAULT CURRENT_TIMESTAMP,
			`update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
			id BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT 'ä¸»é®',
			form_instance_id VARCHAR(64) COMMENT 'è¡¨åå®ä¾ID',
			serial_no VARCHAR(50) COMMENT 'æµæ°´å·',
			apply_no VARCHAR(100) COMMENT 'ç³è¯·åç¼å·',
			customer_name VARCHAR(200) COMMENT 'å®¢æ·åç§°',
			material_code VARCHAR(100) COMMENT 'ç©æç¼ç ',
			product_name VARCHAR(200) COMMENT 'äº§ååç§°',
			product_spec VARCHAR(200) COMMENT 'äº§åè§æ ¼',
			length INT COMMENT 'é¿',
			width INT COMMENT 'å®½',
			height INT COMMENT 'é«',
			quantity INT COMMENT 'åæ°',
			total_count INT COMMENT 'æ¤æ¬¡ç»è®¡æ°é',
			volume DECIMAL(10, 4) COMMENT 'æ¹æ°',
			strength VARCHAR(50) COMMENT 'å¼ºåº¦',
			start_date DATETIME COMMENT 'å¼å§æ¥æ',
			end_date DATETIME COMMENT 'ç»ææ¥æ',
			submitter VARCHAR(100) COMMENT 'æäº¤äºº',
			submit_org VARCHAR(200) COMMENT 'æäº¤äººç»ç»',
			remark_one TEXT COMMENT 'å¤æ³¨1',
			remark_two TEXT COMMENT 'å¤æ³¨2',
			creator_name VARCHAR(100) COMMENT 'åå»ºäºº',
			modifier_name VARCHAR(100) COMMENT 'ä¿®æ¹äºº',
			form_created_time DATETIME COMMENT 'è¡¨ååå»ºæ¶é´',
			form_modified_time DATETIME COMMENT 'è¡¨åä¿®æ¹æ¶é´',
			data_sync_type TINYINT DEFAULT 1 COMMENT 'æ°æ®åæ¥ç±»åï¼1=æå¨ 2=å®æ¶ä»»å¡',
			data_source_type TINYINT DEFAULT 1 COMMENT 'æ°æ®æ¥æºç±»åï¼1=éå®è®¢å 2=éå®é¢æµ',
			create_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'æ°æ®åºåå»ºæ¶é´',
			update_time DATETIME COMMENT 'æ°æ®åºæ´æ°æ¶é´',

			INDEX idx_apply_no (apply_no),
			INDEX idx_serial_no (serial_no),
			INDEX idx_form_instance_id (form_instance_id),
			INDEX idx_material_code (material_code)
			) ENGINE = InnoDB
			DEFAULT CHARSET = utf8mb4 COMMENT ='éå®çäº§è®¡å';

			CREATE TABLE `product-inventory-management-zsjc`.`energy`
			(
			`id` int NOT NULL AUTO_INCREMENT,
			`energy_tyep` varchar(255) NULL COMMENT 'è½æºç±»å',
			`energy_name` varchar(255) NULL COMMENT 'è½æºåç§°',
			`unit` varchar(255) NULL COMMENT 'åä½',
			`unit_price` decimal(10, 2) NULL COMMENT 'åä»·',
			`remark` varchar(255) NULL COMMENT 'å¤æ³¨',
			`create_time` datetime(0) NULL DEFAULT NULL COMMENT 'åå»ºæ¶é´',
			`update_time` datetime(0) NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
			`create_user` bigint NULL DEFAULT NULL COMMENT 'åå»ºè',
			`update_user` bigint NULL DEFAULT NULL COMMENT 'æ´æ°è',
			PRIMARY KEY (`id`)
			) COMMENT = 'è½æºç±»å';

			CREATE TABLE `product-inventory-management-zsjc`.`energy_consumption_detail`
			(
			`id` int NOT NULL AUTO_INCREMENT,
			`energy_id` int NULL COMMENT 'å¤æ£å³èè½æºç±»åid',
			`type` varchar(255) NULL COMMENT 'åå¬/çäº§',
			`meter_reading_location` varchar(255) NULL COMMENT 'æè¡¨ä½ç½®',
			`meter_reading_date` date NULL COMMENT 'æè¡¨æ¥æ',
			`start_code` decimal(10, 2) NULL COMMENT 'èµ·ç ',
			`stop_code` decimal(10, 2) NULL COMMENT 'æ¢ç ',
			`dosage` decimal(10, 2) NULL COMMENT 'ç¨é',
			`remark` varchar(255) NULL COMMENT 'å¤æ³¨',
			`create_time` datetime(0) NULL DEFAULT NULL COMMENT 'åå»ºæ¶é´',
			`update_time` datetime(0) NULL DEFAULT NULL COMMENT 'æ´æ°æ¶é´',
			`create_user` bigint NULL DEFAULT NULL COMMENT 'åå»ºè',
			`update_user` bigint NULL DEFAULT NULL COMMENT 'æ´æ°è',
			PRIMARY KEY (`id`)
			) COMMENT = 'è½æºç±»å-è½èæè¡¨æç»';

			CREATE TABLE `product-inventory-management-zsjc`.`energy_consumption_detail_file`
			(
			`id` int NOT NULL AUTO_INCREMENT,
			`energy_consumption_detail_id` int NULL COMMENT 'å³èå¤é®è½èæè¡¨id',
			`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
			`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
			`file_size` double NULL DEFAULT NULL,
			`create_time` timestamp(0) NULL DEFAULT NULL,
			`create_user` int NULL DEFAULT NULL,
			`update_time` timestamp(0) NULL DEFAULT NULL,
			`update_user` int NULL DEFAULT NULL,
			PRIMARY KEY (`id`)
			) COMMENT = 'è½æºç±»å-è½èæè¡¨æç»_éä»¶';

			alter table product_order
			drop column sales_ledger_id,
			drop column sale_ledger_product_id,
			drop column product_model_id;

			alter table production_plan
			add assigned_quantity DECIMAL(10, 4) default 0 not null COMMENT 'ä¸åæ°é';

			alter table product_order
			add plan_complete_time date NULL DEFAULT NULL COMMENT 'è®¡åå®ææ¶é´';

			# çäº§è®¢åä¸çäº§è®¡åå³èè¡¨
			drop table if exists product_order_plan;
			create table product_order_plan
			(
			id bigint auto_increment primary key,
			product_order_id bigint not null default 0 comment 'çäº§è®¢åid',
			production_plan_id bigint not null default 0 comment 'çäº§è®¡åid',
			create_time datetime null comment 'å½å¥æ¶é´',
			update_time datetime null comment 'æ´æ°æ¶é´',
			assigned_quantity DECIMAL(10, 4) default 0 not null comment 'ä¸åæ°é',
			index idx_product_order_id (product_order_id),
			index idx_production_plan_id (production_plan_id),
			unique idx_product_order_production_plan (product_order_id, production_plan_id)
			);

			CREATE TABLE `product_material`
			(
			`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ä¸»é®ID',
			`tenant_id` BIGINT DEFAULT NULL COMMENT 'ç§æ·ID',
			`material_type_id` INT DEFAULT NULL COMMENT 'ç©æç±»åID',
			`inventory_category_id` INT DEFAULT NULL COMMENT 'åè´§ç±»å«ID',
			`material_name` VARCHAR(255) NOT NULL COMMENT 'ç©æåç§°',
			`base_unit` VARCHAR(50) DEFAULT NULL COMMENT 'åºæ¬åä½',
			`remark` TEXT COMMENT 'å¤æ³¨',
			`create_time` DATETIME DEFAULT CURRENT_TIMESTAMP,
			`update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
			PRIMARY KEY (`id`),
			KEY `idx_form_instance_id` (`form_instance_id`)
			KEY `idx_type_id` (`material_type_id`),
			KEY `idx_cat_id` (`inventory_category_id`),
			UNIQUE KEY `uk_material_name` (`material_name`)
			) ENGINE = INNODB
			DEFAULT CHARSET = utf8mb4 COMMENT = 'éå®çäº§éæ±';
			DEFAULT CHARSET = utf8mb4 COMMENT = 'ç©æä¸»è¡¨';
			CREATE TABLE `product_material_sku`
			(
			`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ä¸»é®ID',
			`material_id` BIGINT NOT NULL COMMENT 'ç©æID',
			`identifier_code` VARCHAR(100) DEFAULT NULL COMMENT 'æ è¯ç¼ç ',
			`material_code` VARCHAR(100) DEFAULT NULL COMMENT 'ç©æç¼ç ',
			`specification` VARCHAR(255) DEFAULT NULL COMMENT 'è§æ ¼åå·',
			`supply_type` VARCHAR(20) DEFAULT NULL COMMENT 'ä¾åºæ¹å¼',
			`originator_name` VARCHAR(100) DEFAULT NULL COMMENT 'æäº¤äººå§å',
			`originator_org` VARCHAR(255) DEFAULT 'å®å¤ä¸åç»¿è½å®ä¸éå¢æéå¬å¸',
			`form_instance_id` VARCHAR(100) DEFAULT NULL COMMENT 'å®æè¡¨åå®ä¾ID',
			`form_modified_time` DATETIME DEFAULT NULL COMMENT 'å®æä¿®æ¹æ¶é´',
			`create_time` DATETIME DEFAULT CURRENT_TIMESTAMP,
			`update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
			PRIMARY KEY (`id`),
			KEY `idx_material_id` (`material_id`),
			UNIQUE KEY `uk_material_spec` (`material_id`, `specification`),
			CONSTRAINT `fk_material` FOREIGN KEY (`material_id`) REFERENCES `product_material` (`id`) ON DELETE CASCADE
			) ENGINE = INNODB
			DEFAULT CHARSET = utf8mb4 COMMENT = 'ç©æè§æ ¼è¡¨';

			ALTER TABLE product_material_sku
			DROP FOREIGN KEY fk_material;

			DROP TABLE IF EXISTS `product_material_config`;
			CREATE TABLE `product_material_config`
			(
			`id` int NOT NULL AUTO_INCREMENT,
			`config_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'åºåç±»å: MATERIAL_TYPE æ INVENTORY_CAT',
			`config_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'æ¾ç¤ºçåç§°',
			PRIMARY KEY (`id`) USING BTREE
			) ENGINE = InnoDB
			AUTO_INCREMENT = 39
			CHARACTER SET = utf8mb3
			COLLATE = utf8mb3_general_ci COMMENT = 'ç©æä¿¡æ¯è¡¨éç½®è¡¨'
			ROW_FORMAT = Dynamic;

			SET FOREIGN_KEY_CHECKS = 1;


			alter table production_plan
			add status tinyint default 0 not null comment 'ç¶æ 0æªä¸å 1å·²ä¸å';


			ALTER TABLE `product-inventory-management-zsjc`.`production_plan`
			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`;
			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 = 'åºç¡åæ°å®ä¹è¡¨';

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