From bd843578d19a1e500310bd85d4b601af3300bbd8 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期四, 12 三月 2026 15:38:00 +0800
Subject: [PATCH] feat: 物料信息表配置表
---
doc/宁夏-中盛建材.sql | 114 +++++++++++++++++++++++++++++++++------------------------
1 files changed, 66 insertions(+), 48 deletions(-)
diff --git "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
index 4b84c86..64a938d 100644
--- "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
+++ "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
@@ -39,54 +39,57 @@
) 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 '鏇存柊鑰�',
+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 = '鑳芥簮绫诲瀷';
+) 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 '鏇存柊鑰�',
+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 = '鑳芥簮绫诲瀷-鑳借�楁妱琛ㄦ槑缁�';
+) COMMENT = '鑳芥簮绫诲瀷-鑳借�楁妱琛ㄦ槑缁�';
-CREATE TABLE `product-inventory-management-zsjc`.`energy_consumption_detail_file` (
- `id` int NOT NULL AUTO_INCREMENT,
- `energy_consumption_detail_id` int NULL COMMENT '鍏宠仈澶栭敭鑳借�楁妱琛╥d',
- `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,
+CREATE TABLE `product-inventory-management-zsjc`.`energy_consumption_detail_file`
+(
+ `id` int NOT NULL AUTO_INCREMENT,
+ `energy_consumption_detail_id` int NULL COMMENT '鍏宠仈澶栭敭鑳借�楁妱琛╥d',
+ `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 = '鑳芥簮绫诲瀷-鑳借�楁妱琛ㄦ槑缁哶闄勪欢';
+) COMMENT = '鑳芥簮绫诲瀷-鑳借�楁妱琛ㄦ槑缁哶闄勪欢';
alter table product_order
-drop column sales_ledger_id,
-drop column sale_ledger_product_id,
-drop column product_model_id;
+ 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 '涓嬪彂鏁伴噺';
@@ -98,12 +101,12 @@
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 '涓嬪彂鏁伴噺',
+ 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)
@@ -148,4 +151,19 @@
DEFAULT CHARSET = utf8mb4 COMMENT = '鐗╂枡瑙勬牸琛�';
ALTER TABLE product_material_sku
- DROP FOREIGN KEY fk_material;
\ No newline at end of file
+ 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;
--
Gitblit v1.9.3