From 277b5047d00a3e9094bafd5ecb078976fbf6a92d Mon Sep 17 00:00:00 2001
From: yaowanxin <3588231647@qq.com>
Date: 星期四, 08 一月 2026 18:59:04 +0800
Subject: [PATCH] 华玺砂浆转移-采购代码、发货和发货审核、报修和报修审核、采购模板，查询采购模板接口、财务管理的存货核算数据接口、财务管理的固定资产核算获取台账接口、采购审批,接口、客户分类字段、采购台账字段,实现采购异常记录的添加接口、黑名单,添加资质管理字段,可上传资质文件-至军泰伟业
---
doc/create_table_product_structure.sql | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/doc/create_table_product_structure.sql b/doc/create_table_product_structure.sql
index 253548d..83af495 100644
--- a/doc/create_table_product_structure.sql
+++ b/doc/create_table_product_structure.sql
@@ -1,10 +1,10 @@
# 浜у搧缁撴瀯
-drop table if exists production_product_structure;
+drop table if exists product_structure;
create table product_structure
(
id bigint auto_increment
primary key,
- product_id bigint not null comment '浜у搧id',
+ product_model_id bigint not null comment '浜у搧id',
process_id bigint not null comment '宸ュ簭id',
unit_quantity numeric(16, 4) not null comment '鍗曚綅浜у嚭闇�瑕佹暟閲�',
demanded_quantity numeric(16, 4) not null comment '闇�姹傛暟閲�',
@@ -12,3 +12,5 @@
disk_quantity numeric(16, 4) not null comment '鐩樻暟閲�',
tenant_id bigint not null comment '绉熸埛id'
);
+alter table product_structure
+ add parent_id bigint null comment '鐖秈d';
--
Gitblit v1.9.3