From 88162af48f9e01761b9ed2fc5ad11f8889a612db Mon Sep 17 00:00:00 2001
From: chenhj <1263187585@qq.com>
Date: 星期一, 22 十二月 2025 16:49:04 +0800
Subject: [PATCH] 产品结构
---
src/main/java/com/ruoyi/production/pojo/ProductStructure.java | 54 +++++++++++++++++++++++++++
doc/create_table_product_structure.sql | 14 +++++++
2 files changed, 68 insertions(+), 0 deletions(-)
diff --git a/doc/create_table_product_structure.sql b/doc/create_table_product_structure.sql
new file mode 100644
index 0000000..253548d
--- /dev/null
+++ b/doc/create_table_product_structure.sql
@@ -0,0 +1,14 @@
+# 浜у搧缁撴瀯
+drop table if exists production_product_structure;
+create table product_structure
+(
+ id bigint auto_increment
+ primary key,
+ product_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 '闇�姹傛暟閲�',
+ unit varchar(255) not null comment '鍗曚綅',
+ disk_quantity numeric(16, 4) not null comment '鐩樻暟閲�',
+ tenant_id bigint not null comment '绉熸埛id'
+);
diff --git a/src/main/java/com/ruoyi/production/pojo/ProductStructure.java b/src/main/java/com/ruoyi/production/pojo/ProductStructure.java
new file mode 100644
index 0000000..dc2528f
--- /dev/null
+++ b/src/main/java/com/ruoyi/production/pojo/ProductStructure.java
@@ -0,0 +1,54 @@
+package com.ruoyi.production.pojo;
+
+import com.baomidou.mybatisplus.annotation.*;
+import lombok.Data;
+
+import java.math.BigDecimal;
+
+@TableName("product_structure")
+@Data
+public class ProductStructure {
+
+ private static final long serialVersionUID = 1L;
+
+ @TableId(value = "id", type = IdType.AUTO)
+ private Long id;
+
+ /**
+ * 浜у搧鍚嶇О
+ */
+ private Long productId;
+
+ /**
+ * 宸ュ簭id
+ */
+ private Long processId;
+
+ /**
+ * 鍗曚綅浜у嚭闇�瑕佹暟閲�
+ */
+ private BigDecimal unitQuantity;
+
+ /**
+ * 闇�姹傛暟閲�
+ */
+ private BigDecimal demandedQuantity;
+
+ /**
+ * 鍗曚綅
+ */
+ private String unit;
+
+ /**
+ * 鐩樻暟閲�
+ */
+ private BigDecimal diskQuantity;
+
+ /**
+ * 绉熸埛ID
+ */
+ @TableField(fill = FieldFill.INSERT)
+ private Long tenantId;
+
+
+}
--
Gitblit v1.9.3