art: 生产管控模块数据库设计修改

zhangherong

2025-06-18 bdf30cc2aee70b1c82b954afc9e6025d1be1ffb9

art: 生产管控模块数据库设计修改

 db/Ë«ÁÖлð¾æMESÊý¾Ý¿âÉè¼Æ.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": "申请单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": "850A2C7A-D321-4283-B735-7BCC56DF7933"
        },
        {
          "defKey": "material_number",
          "defName": "物料编码",
          "comment": "",