From a08dce3de307ce138396db5fe7274ead2ef5c573 Mon Sep 17 00:00:00 2001 From: liyong <18434998025@163.com> Date: 星期二, 20 一月 2026 17:12:08 +0800 Subject: [PATCH] Merge branch 'jtwy' of http://114.132.189.42:9002/r/product-inventory-management-after into sqd-hb --- doc/create_table_production_product_main.sql | 36 ++++++++++++++++++++++++++++++++++++ 1 files changed, 36 insertions(+), 0 deletions(-) diff --git a/doc/create_table_production_product_main.sql b/doc/create_table_production_product_main.sql new file mode 100644 index 0000000..18fb92d --- /dev/null +++ b/doc/create_table_production_product_main.sql @@ -0,0 +1,36 @@ +drop table if exists production_product_main; +create table production_product_main +( + id bigint auto_increment + primary key, + product_no varchar(255) not null comment '鎶ュ伐鍗曞彿', + user_id bigint not null comment '鎶ュ伐鐢ㄦ埛id', + work_order_id bigint not null comment '宸ュ崟id', + status int not null comment '鐘舵�� 0 寰呮姤宸� 1 寰呯‘璁�', + create_time datetime null comment '褰曞叆鏃堕棿', + tenant_id bigint not null comment '绉熸埛id' +); + +drop table if exists production_product_output; +create table production_product_output +( + id bigint auto_increment + primary key, + product_main_id bigint not null comment '鎶ュ伐鍗昳d', + product_model_id bigint not null comment '浜у搧id', + quantity numeric(16, 4) not null comment '鏁伴噺', + create_time datetime null comment '褰曞叆鏃堕棿', + tenant_id bigint not null comment '绉熸埛id' +); + +drop table if exists production_product_input; +create table production_product_input +( + id bigint auto_increment + primary key, + product_main_id bigint not null comment '鎶ュ伐鍗昳d', + product_model_id bigint not null comment '浜у搧id', + quantity numeric(16, 4) not null comment '鏁伴噺', + create_time datetime null comment '褰曞叆鏃堕棿', + tenant_id bigint not null comment '绉熸埛id' +) -- Gitblit v1.9.3