From e7fec9ecae7757284d676f41b2fe1b32943c0f25 Mon Sep 17 00:00:00 2001
From: chenhj <1263187585@qq.com>
Date: 星期一, 22 十二月 2025 17:52:33 +0800
Subject: [PATCH] 数据表创建
---
doc/create_table_process_route.sql | 11 +++++++++++
doc/create_table_product_structure.sql | 2 +-
doc/create_table_process_route_item.sql | 11 +++++++++++
3 files changed, 23 insertions(+), 1 deletions(-)
diff --git a/doc/create_table_process_route.sql b/doc/create_table_process_route.sql
new file mode 100644
index 0000000..9bc08ec
--- /dev/null
+++ b/doc/create_table_process_route.sql
@@ -0,0 +1,11 @@
+# 宸ヨ壓璺嚎
+drop table if exists process_route;
+create table process_route
+(
+ id bigint auto_increment primary key,
+ product_id bigint not null default 0 comment '浜у搧id',
+ description varchar(255) not null default '' comment '鎻忚堪',
+ tenant_id bigint not null comment '绉熸埛id',
+ create_time datetime null comment '褰曞叆鏃堕棿',
+ update_time datetime null comment '鏇存柊鏃堕棿'
+);
diff --git a/doc/create_table_process_route_item.sql b/doc/create_table_process_route_item.sql
new file mode 100644
index 0000000..306deaf
--- /dev/null
+++ b/doc/create_table_process_route_item.sql
@@ -0,0 +1,11 @@
+# 宸ヨ壓璺嚎椤圭洰
+drop table if exists process_route_item;
+create table process_route_item
+(
+ id bigint auto_increment primary key,
+ route_id bigint not null default 0 comment '宸ヨ壓璺嚎id',
+ product_id bigint not null default 0 comment '浜у搧id',
+ tenant_id bigint not null comment '绉熸埛id',
+ create_time datetime null comment '褰曞叆鏃堕棿',
+ update_time datetime null comment '鏇存柊鏃堕棿'
+);
diff --git a/doc/create_table_product_structure.sql b/doc/create_table_product_structure.sql
index 253548d..b91b3a1 100644
--- a/doc/create_table_product_structure.sql
+++ b/doc/create_table_product_structure.sql
@@ -1,5 +1,5 @@
# 浜у搧缁撴瀯
-drop table if exists production_product_structure;
+drop table if exists product_structure;
create table product_structure
(
id bigint auto_increment
--
Gitblit v1.9.3