art: 数据库设计修改

zhangherong

2025-06-19 d06002585c89d036895e9624a34bc38327e7189c

art: 数据库设计修改

 db/Ë«ÁÖлð¾æMESÊý¾Ý¿âÉè¼Æ.pdma.json

@@ -4,7 +4,7 @@
  "avatar": "",
  "version": "4.9.2",
  "createdTime": "2025-3-10 16:38:19",
  "updatedTime": "2025-6-18 11:45:09",
  "updatedTime": "2025-6-19 16:05:48",
  "dbConns": [],
  "profile": {
    "default": {
@@ -10697,7 +10697,7 @@
        },
        {
          "defKey": "production_unit",
          "defName": "单位",
          "defName": "产品单位",
          "comment": "",
          "type": "",
          "len": "",
@@ -10710,12 +10710,12 @@
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "BE09D493-E183-402D-ACC4-EEA21EB35B8E",
          "domain": "73FD2BAD-2358-4336-B96D-45DC897BD792",
          "id": "B8C83956-8C3F-4EDE-8FB7-123AFC7968E3"
        },
        {
          "defKey": "order_status",
          "defName": "计划状态",
          "defName": "订单状态",
          "comment": "",
          "type": "",
          "len": "",
@@ -11424,7 +11424,7 @@
        }
      },
      "defKey": "base_shift_group",
      "defName": "班制",
      "defName": "班组",
      "comment": "",
      "properties": {
        "partitioned by": "(date string)",
@@ -11812,8 +11812,8 @@
          "codeRoot": ""
        }
      },
      "defKey": "pms_process_route",
      "defName": "工艺路线信息",
      "defKey": "pms_material_process",
      "defName": "物料工序",
      "comment": "",
      "properties": {
        "partitioned by": "(date string)",
@@ -12063,24 +12063,6 @@
          "id": "ABF02681-A2E7-4077-AEEF-7338AF47C4B8"
        },
        {
          "defKey": "order_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": "E81969FC-3874-4E64-B07F-FD3C1350DE5B"
        },
        {
          "defKey": "material_number",
          "defName": "物料编码",
          "comment": "",
@@ -12099,8 +12081,54 @@
          "id": "2741DB1D-955B-42D0-B873-6BC3C4429B8E"
        },
        {
          "defKey": "material_name",
          "defName": "物料名称",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": true,
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "refDict": "",
          "extProps": {},
          "notes": {},
          "attr1": "",
          "attr2": "",
          "attr3": "",
          "attr4": "",
          "attr5": "",
          "attr6": "",
          "attr7": "",
          "attr8": "",
          "attr9": "",
          "id": "CADE8A93-4759-4DA5-8210-942102A9F18B",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
        },
        {
          "defKey": "factory_id",
          "defName": "产线ID(SAP工作中心)",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "F5683C11-B21C-44C4-AF88-2D9A92F7444F"
        },
        {
          "defKey": "process_code",
          "defName": "工艺编码",
          "defName": "工序号",
          "comment": "",
          "type": "",
          "len": "",
@@ -12118,7 +12146,7 @@
        },
        {
          "defKey": "process_name",
          "defName": "工艺名称",
          "defName": "工序名称",
          "comment": "",
          "type": "",
          "len": "",
@@ -12133,6 +12161,24 @@
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "8D4019F7-4CAC-49D8-855E-4F1094F0E4DA"
        },
        {
          "defKey": "control_code",
          "defName": "控制码",
          "comment": "ZP01的工序必须报工",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "50679B39-7BD3-4DCD-A47D-ECC426128A34"
        }
      ],
      "correlations": [],
@@ -49135,6 +49181,276 @@
          "extProps": {},
          "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E",
          "id": "DBB838C6-F10A-4139-A532-52A5F1C940FE"
        },
        {
          "defKey": "supplier_code",
          "defName": "供应商编码",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "B965D5D7-3379-4BF4-BDB3-304185112BEF"
        },
        {
          "defKey": "supplier_name",
          "defName": "供应商名称",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "3551E2B2-64BD-4AD9-AC7B-4EB9B9C78F61"
        },
        {
          "defKey": "supplier_status",
          "defName": "供应商名称",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "7B5C2DD1-F102-4B95-A317-C2F7A6200EAE"
        },
        {
          "defKey": "country",
          "defName": "国家",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "30DE34FA-8BFB-4042-8574-5AF91F35D699"
        },
        {
          "defKey": "province",
          "defName": "省份",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "AC4315D7-8C0E-4D6A-93B3-E60F3B24F66E"
        },
        {
          "defKey": "city",
          "defName": "城市",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "4DE19040-4B23-4CDA-BE0E-9DF4F363A01E"
        },
        {
          "defKey": "address",
          "defName": "详细地址",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "20FC5967-A6AB-4A10-BE92-7E0F70A1A848"
        },
        {
          "defKey": "postcode",
          "defName": "邮编",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "CE906B38-7183-41BE-A9B4-A7E7233B54B4"
        },
        {
          "defKey": "contact",
          "defName": "联系人",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "03CACE9D-7194-468B-A5CE-93F8FDCFAEBC"
        },
        {
          "defKey": "fax",
          "defName": "传真",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "6957BFF0-9BFC-4795-874F-E6B35915591B"
        },
        {
          "defKey": "email",
          "defName": "邮箱",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "ACE1A026-7B03-47C9-A851-11DB4542F7F8"
        },
        {
          "defKey": "phone",
          "defName": "电话",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "76F9D55C-6C5D-4210-AA8E-DE5278F0E20F"
        },
        {
          "defKey": "company_telephone",
          "defName": "公司电话",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "743CD74E-39B2-4871-BA0D-B129714705D5"
        },
        {
          "defKey": "official_website",
          "defName": "官方网站",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "EA9DFC2F-AAF7-4B40-B5D1-2B700363A56C"
        },
        {
          "defKey": "remark",
          "defName": "备注",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "6AE806DC-E022-4DDB-BB92-D0AF4A640088"
        }
      ],
      "correlations": [],