From e390e7b4fd3d0cb623e39a537bff8fc5247c083c Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期三, 25 六月 2025 13:44:56 +0800
Subject: [PATCH] art: 数据库设计表优化
---
db/双林新火炬MES数据库设计.pdma.json | 78 +++++++++++++++++---------------------
1 files changed, 35 insertions(+), 43 deletions(-)
diff --git "a/db/\345\217\214\346\236\227\346\226\260\347\201\253\347\202\254MES\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json" "b/db/\345\217\214\346\236\227\346\226\260\347\201\253\347\202\254MES\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json"
index 9724489..e8d6f42 100644
--- "a/db/\345\217\214\346\236\227\346\226\260\347\201\253\347\202\254MES\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json"
+++ "b/db/\345\217\214\346\236\227\346\226\260\347\201\253\347\202\254MES\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json"
@@ -4,7 +4,7 @@
"avatar": "",
"version": "4.9.2",
"createdTime": "2025-3-10 16:38:19",
- "updatedTime": "2025-6-24 11:05:00",
+ "updatedTime": "2025-6-24 16:55:39",
"dbConns": [],
"profile": {
"default": {
@@ -10679,7 +10679,7 @@
},
{
"defKey": "order_quantity",
- "defName": "鐢熶骇鏁伴噺",
+ "defName": "璁㈠崟鏁伴噺",
"comment": "",
"type": "",
"len": "",
@@ -11394,7 +11394,7 @@
},
{
"defKey": "republish_time",
- "defName": "閲嶅彂甯冨疄闄�",
+ "defName": "閲嶅彂甯冩椂闂�",
"comment": "",
"type": "",
"len": "",
@@ -11765,7 +11765,7 @@
},
{
"defKey": "factory_id",
- "defName": "宸ュ巶/杞﹂棿/浜х嚎ID",
+ "defName": "浜х嚎ID",
"comment": "",
"type": "",
"len": "",
@@ -47582,7 +47582,7 @@
},
{
"defKey": "factory_id",
- "defName": "宸ュ巶/杞﹂棿/浜х嚎",
+ "defName": "浜х嚎ID",
"comment": "",
"type": "",
"len": "",
@@ -47891,7 +47891,7 @@
},
{
"defKey": "factory_id",
- "defName": "宸ュ巶/杞﹂棿/浜х嚎",
+ "defName": "浜х嚎ID",
"comment": "",
"type": "",
"len": "",
@@ -61260,42 +61260,6 @@
"id": "D289B913-6D18-4B25-A874-F2D6C4851638"
},
{
- "defKey": "factory_id",
- "defName": "浜х嚎ID",
- "comment": "",
- "type": "",
- "len": "",
- "scale": "",
- "primaryKey": false,
- "notNull": false,
- "autoIncrement": false,
- "defaultValue": "",
- "hideInGraph": false,
- "refDict": "",
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
- "extProps": {},
- "domain": "16120F75-6AA7-4483-868D-F07F511BB081",
- "id": "BF32A63E-E233-466C-AADF-E86C542EBB80"
- },
- {
- "defKey": "warehose_id",
- "defName": "绾胯竟浠揑D",
- "comment": "",
- "type": "",
- "len": "",
- "scale": "",
- "primaryKey": false,
- "notNull": false,
- "autoIncrement": false,
- "defaultValue": "",
- "hideInGraph": false,
- "refDict": "",
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
- "extProps": {},
- "domain": "16120F75-6AA7-4483-868D-F07F511BB081",
- "id": "EAC48250-72AD-4BE9-8FD4-44FA24C8CE22"
- },
- {
"defKey": "material_unit",
"defName": "鍗曚綅",
"comment": "",
@@ -61561,7 +61525,7 @@
{
"defKey": "inventory_category",
"defName": "搴撳瓨绫诲瀷",
- "comment": "鍏ュ簱銆佷笂鏂欍�佷笅鏂�",
+ "comment": "鍏ュ簱銆佷笅鏂�",
"type": "",
"len": "",
"scale": "",
@@ -62359,6 +62323,34 @@
"id": "9056CBAC-AC31-46AC-802D-7ECC455F7834"
},
{
+ "defKey": "batch_number",
+ "defName": "鎵规鍙�",
+ "comment": "",
+ "type": "",
+ "len": "",
+ "scale": "",
+ "primaryKey": false,
+ "notNull": false,
+ "autoIncrement": false,
+ "defaultValue": "",
+ "hideInGraph": false,
+ "domain": "54611CCC-CA4B-42E1-9F32-4944C85B85A6",
+ "refDict": "",
+ "extProps": {},
+ "notes": {},
+ "attr1": "",
+ "attr2": "",
+ "attr3": "",
+ "attr4": "",
+ "attr5": "",
+ "attr6": "",
+ "attr7": "",
+ "attr8": "",
+ "attr9": "",
+ "id": "9B4B24DD-A18A-4A23-8976-898E0C77297A",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ },
+ {
"defKey": "outbound_staff",
"defName": "鍑哄簱浜�",
"comment": "",
--
Gitblit v1.9.3