From bdf30cc2aee70b1c82b954afc9e6025d1be1ffb9 Mon Sep 17 00:00:00 2001 From: zhangherong <571457620@qq.com> Date: 星期三, 18 六月 2025 14:05:29 +0800 Subject: [PATCH] art: 生产管控模块数据库设计修改 --- db/双林新火炬MES数据库设计.pdma.json | 66 +++++++++++++++++++++------------ 1 files changed, 42 insertions(+), 24 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 092500b..8773955 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-17 16:01:24", + "updatedTime": "2025-6-18 11:45:09", "dbConns": [], "profile": { "default": { @@ -10319,8 +10319,8 @@ "codeRoot": "" } }, - "defKey": "mes_production_plan", - "defName": "SAP鐢熶骇璁㈠崟璁″垝", + "defKey": "mes_production_order", + "defName": "SAP鐢熶骇璁㈠崟", "comment": "", "properties": { "partitioned by": "(date string)", @@ -10570,9 +10570,9 @@ "id": "5983EA32-6658-4840-B5B3-CD547AE93CEE" }, { - "defKey": "plan_code", - "defName": "璁″垝鍗曞彿", - "comment": "", + "defKey": "order_code", + "defName": "鐢熶骇璁㈠崟鍙�", + "comment": "SAP鍚屾", "type": "", "len": "", "scale": "", @@ -10588,7 +10588,7 @@ "id": "CCC37F14-E0CF-43FD-81AF-F5479C53FD73" }, { - "defKey": "plan_category", + "defKey": "order_category", "defName": "璁㈠崟绫诲瀷", "comment": "", "type": "", @@ -10678,7 +10678,7 @@ "id": "99F977A3-41FC-4836-8C08-AAF9AEE92AB6" }, { - "defKey": "plan_quantity", + "defKey": "order_quantity", "defName": "鐢熶骇鏁伴噺", "comment": "", "type": "", @@ -10714,7 +10714,7 @@ "id": "B8C83956-8C3F-4EDE-8FB7-123AFC7968E3" }, { - "defKey": "plan_status", + "defKey": "order_status", "defName": "璁″垝鐘舵��", "comment": "", "type": "", @@ -11139,7 +11139,7 @@ "id": "A03DC96A-CA2B-42A0-9114-32A13838CC50" }, { - "defKey": "order_code", + "defKey": "work_order_code", "defName": "宸ュ崟鍙�(浠诲姟鍙�)", "comment": "", "type": "", @@ -11285,7 +11285,7 @@ "id": "743FA9CD-1E43-4DA2-A74F-DB3040C95610" }, { - "defKey": "work_date", + "defKey": "work_order_date", "defName": "鎺掍骇鏃ユ湡", "comment": "", "type": "", @@ -11303,7 +11303,7 @@ "id": "66DCAB1A-9D83-4EC1-8451-BCDCA594DDA2" }, { - "defKey": "order_status", + "defKey": "work_order_status", "defName": "宸ュ崟鐘舵��", "comment": "鏂板缓銆佸彂甯冦�侀噸鍙戝竷", "type": "", @@ -12063,7 +12063,7 @@ "id": "ABF02681-A2E7-4077-AEEF-7338AF47C4B8" }, { - "defKey": "plan_id", + "defKey": "order_id", "defName": "鐢熸垚璁㈠崟ID", "comment": "", "type": "", @@ -12398,7 +12398,7 @@ "id": "B43CBCB3-5BC6-4411-9999-C50D2C6A8A5D" }, { - "defKey": "plan_id", + "defKey": "order_id", "defName": "鐢熸垚璁㈠崟ID", "comment": "", "type": "", @@ -56960,7 +56960,7 @@ "baseType": "89D69E81-EA34-42EE-9FA2-93B8BD27E098" }, { - "defKey": "order_id", + "defKey": "work_order_id", "defName": "宸ュ崟ID", "comment": "", "type": "", @@ -62640,7 +62640,7 @@ "id": "5B833F2B-D8C6-478D-B830-604D2CC6AAF0" }, { - "defKey": "order_id", + "defKey": "work_order_id", "defName": "宸ュ崟ID", "comment": "", "type": "", @@ -63238,7 +63238,7 @@ "id": "9322D87A-5855-4D67-A19D-5D9F33BFB50E" }, { - "defKey": "plan_id", + "defKey": "order_id", "defName": "璁㈠崟ID", "comment": "鍗婃垚鍝佹姤宸ワ紝鏃犻渶缁戝畾鍒扮敓浜ц鍗�", "type": "", @@ -63256,7 +63256,7 @@ "id": "0A646552-E539-44E6-AB49-69CF4BF16522" }, { - "defKey": "order_id", + "defKey": "work_order_id", "defName": "宸ュ崟ID", "comment": "", "type": "", @@ -63681,7 +63681,7 @@ "id": "CCF472FA-99A7-4E74-8D96-CC39A6702972" }, { - "defKey": "plan_id", + "defKey": "order_id", "defName": "鐢熶骇璁㈠崟ID", "comment": "", "type": "", @@ -63699,7 +63699,7 @@ "id": "86274CB0-2DAA-488C-AC16-FA00B580D9BA" }, { - "defKey": "order_id", + "defKey": "work_order_id", "defName": "宸ュ崟ID", "comment": "", "type": "", @@ -64144,7 +64144,7 @@ "id": "1FE85A2B-FC0D-4F3D-98DD-9272E8DAD737" }, { - "defKey": "plan_id", + "defKey": "order_id", "defName": "鐢熶骇璁㈠崟ID", "comment": "", "type": "", @@ -64162,7 +64162,7 @@ "id": "A672223A-0E07-490E-A920-E519F6FBE275" }, { - "defKey": "order_code", + "defKey": "work_order_code", "defName": "绉诲簱鍗曞彿", "comment": "", "type": "", @@ -64615,7 +64615,7 @@ "id": "F37A4605-33B2-4ADC-AD50-B0CAE5A8D6D5" }, { - "defKey": "order_id", + "defKey": "work_order_id", "defName": "宸ュ崟ID", "comment": "", "type": "", @@ -65060,7 +65060,7 @@ "id": "FBAA1CFF-AA71-46F8-B401-4EC0D39B022A" }, { - "defKey": "order_id", + "defKey": "work_order_id", "defName": "宸ュ崟ID", "comment": "", "type": "", @@ -65898,6 +65898,24 @@ "id": "F80D66E7-8670-4B1C-9940-041DBAD0580A" }, { + "defKey": "request_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": "850A2C7A-D321-4283-B735-7BCC56DF7933" + }, + { "defKey": "material_number", "defName": "鐗╂枡缂栫爜", "comment": "", -- Gitblit v1.9.3