art: 设备管理数据库设计修改

zhangherong

2025-03-19 720eb777fc52d44639c19db1342f72717dc77c6a

art: 设备管理数据库设计修改

 db/Êý¾Ý¿â²úÆ·»¯Éè¼Æ.pdma.json

@@ -4,7 +4,7 @@
  "avatar": "",
  "version": "4.9.2",
  "createdTime": "2025-3-10 16:38:19",
  "updatedTime": "2025-3-14 17:48:33",
  "updatedTime": "2025-3-19 11:36:59",
  "dbConns": [],
  "profile": {
    "default": {
@@ -620,7 +620,7 @@
        "freeze": false
      }
    ],
    "modelType": "modalAll",
    "modelType": "modalGroup",
    "recentColors": [
      "#d148d1",
      "#ce4bce",
@@ -14782,12 +14782,12 @@
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "54611CCC-CA4B-42E1-9F32-4944C85B85A6",
          "domain": "BE09D493-E183-402D-ACC4-EEA21EB35B8E",
          "id": "8E2E374D-26D3-43F7-B21D-9F426E598DAA"
        },
        {
          "defKey": "file_name",
          "defName": "文件原始名称",
          "defName": "文件名称",
          "comment": "",
          "type": "",
          "len": "",
@@ -14820,24 +14820,6 @@
          "extProps": {},
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "7DD92935-AF34-4DCF-8AF7-310BF043C96C"
        },
        {
          "defKey": "full_path",
          "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": "13A5EDE6-6902-4DFE-95E6-7D853D1CE808"
        },
        {
          "defKey": "file_suffix",
@@ -15248,7 +15230,7 @@
        },
        {
          "defKey": "day_format",
          "defName": "天 ç¼–码格式",
          "defName": "天编码格式",
          "comment": "",
          "type": "",
          "len": "",
@@ -15281,10 +15263,355 @@
          "extProps": {},
          "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E",
          "id": "81BF4261-D1BC-494E-981B-7B069AAFAD6A"
        }
      ],
      "correlations": [],
      "indexes": [],
      "type": "P"
    },
    {
      "id": "C0BBEF88-3FC1-443D-AC9D-EC780080BC93",
      "env": {
        "base": {
          "nameSpace": "",
          "codeRoot": ""
        }
      },
      "defKey": "sys_business_code_seq",
      "defName": "业务编码生成序列",
      "comment": "",
      "properties": {
        "partitioned by": "(date string)",
        "row format delimited": "",
        "fields terminated by ','": "",
        "collection items terminated by '-'": "",
        "map keys terminated by ':'": "",
        "store as textfile;": ""
      },
      "sysProps": {
        "nameTemplate": "{defKey}[{defName}]"
      },
      "notes": {},
      "headers": [
        {
          "refKey": "hideInGraph",
          "hideInGraph": true
        },
        {
          "defKey": "current_num",
          "defName": "当前序号",
          "refKey": "defKey",
          "freeze": false,
          "hideInGraph": false
        },
        {
          "refKey": "defName",
          "freeze": false,
          "hideInGraph": false
        },
        {
          "refKey": "primaryKey",
          "freeze": false,
          "hideInGraph": false
        },
        {
          "refKey": "notNull",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "autoIncrement",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "domain",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "type",
          "freeze": false,
          "hideInGraph": false
        },
        {
          "refKey": "len",
          "freeze": false,
          "hideInGraph": false
        },
        {
          "refKey": "scale",
          "freeze": false,
          "hideInGraph": false
        },
        {
          "refKey": "comment",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "refDict",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "defaultValue",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "isStandard",
          "freeze": false,
          "hideInGraph": false
        },
        {
          "refKey": "uiHint",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "extProps",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "attr1",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "attr2",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "attr3",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "attr4",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "attr5",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "attr6",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "attr7",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "attr8",
          "freeze": false,
          "hideInGraph": true
        },
        {
          "refKey": "attr9",
          "freeze": false,
          "hideInGraph": true
        }
      ],
      "fields": [
        {
          "defKey": "id",
          "defName": "主键",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": true,
          "notNull": true,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "16120F75-6AA7-4483-868D-F07F511BB081",
          "id": "9DD983C4-9AB5-4A9F-B7CA-0203B1E580AD"
        },
        {
          "defKey": "create_by",
          "defName": "创建人",
          "comment": "",
          "domain": "54611CCC-CA4B-42E1-9F32-4944C85B85A6",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": true,
          "refDict": "",
          "uiHint": "",
          "id": "8FD1D5E4-2A2B-4052-828A-C1C0AB1BD31E",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
        },
        {
          "defKey": "create_time",
          "defName": "创建时间",
          "comment": "",
          "domain": "7CFFA0D3-6A93-4DDC-BC10-DF21211064DC",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": true,
          "refDict": "",
          "uiHint": "",
          "id": "D59D8049-B400-4650-AF75-67EF1B60B5AC",
          "baseType": "89D69E81-EA34-42EE-9FA2-93B8BD27E098"
        },
        {
          "defKey": "update_by",
          "defName": "更新人",
          "comment": "",
          "domain": "54611CCC-CA4B-42E1-9F32-4944C85B85A6",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": true,
          "refDict": "",
          "uiHint": "",
          "id": "56CA7F2E-C1D6-47B9-BB08-2A3E442D3778",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
        },
        {
          "defKey": "update_time",
          "defName": "更新时间",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": true,
          "domain": "7CFFA0D3-6A93-4DDC-BC10-DF21211064DC",
          "refDict": "",
          "extProps": {},
          "notes": {},
          "attr1": "",
          "attr2": "",
          "attr3": "",
          "attr4": "",
          "attr5": "",
          "attr6": "",
          "attr7": "",
          "attr8": "",
          "attr9": "",
          "id": "B415329C-1A9B-4992-9164-138B6BC194F4",
          "baseType": "89D69E81-EA34-42EE-9FA2-93B8BD27E098"
        },
        {
          "defKey": "rule_id",
          "defName": "规则编码",
          "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": "1361B964-C35F-4FBF-808F-7FFD289A133E"
        },
        {
          "defKey": "prefix",
          "defName": "前缀",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "54611CCC-CA4B-42E1-9F32-4944C85B85A6",
          "id": "223B017A-F289-4FE4-AF2B-BC9847ECF977"
        },
        {
          "defKey": "current_year",
          "defName": "当前年份",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "54611CCC-CA4B-42E1-9F32-4944C85B85A6",
          "id": "F103D770-A2A4-4E1F-9D80-6768C7431AD7"
        },
        {
          "defKey": "current_month",
          "defName": "当前月份",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "54611CCC-CA4B-42E1-9F32-4944C85B85A6",
          "id": "ABF01002-A024-417D-8765-75FD12826579"
        },
        {
          "defKey": "current_day",
          "defName": "当前天",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "domain": "54611CCC-CA4B-42E1-9F32-4944C85B85A6",
          "id": "35896231-A3CC-44D7-8B39-06DB21B05DC7"
        },
        {
          "defKey": "current_seq",
          "defName": "当前序列值",
          "comment": "",
          "type": "",
          "len": "",
@@ -15298,7 +15625,7 @@
          "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811",
          "extProps": {},
          "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E",
          "id": "C65F1569-4D7D-4400-A25D-492661AD94B4"
          "id": "20C01EF4-19BC-40DE-8BB6-CC1915FD8AC2"
        }
      ],
      "correlations": [],
@@ -15938,6 +16265,39 @@
          "id": "6C803912-BF5E-404E-8ABB-6CB5C8C42BA9"
        }
      ]
    },
    {
      "defKey": "process_parameters_category",
      "defName": "工艺参数分类",
      "sort": "",
      "intro": "",
      "id": "3AA9C9FB-86F2-4836-83EB-E2F8B2E540E7",
      "items": [
        {
          "defKey": "1",
          "defName": "加工范围",
          "sort": "",
          "parentKey": "",
          "intro": "",
          "enabled": true,
          "attr1": "",
          "attr2": "",
          "attr3": "",
          "id": "81046783-462D-4D8E-995A-9BA2106B8476"
        },
        {
          "defKey": "2",
          "defName": "形位公差",
          "sort": "",
          "parentKey": "",
          "intro": "",
          "enabled": true,
          "attr1": "",
          "attr2": "",
          "attr3": "",
          "id": "6D24525A-2701-47DB-976C-424B244268D0"
        }
      ]
    }
  ],
  "viewGroups": [
@@ -15980,7 +16340,8 @@
        "804A08AE-C5BE-49C9-BCA3-B6521C236EE1",
        "918CE0CD-78C7-4BEF-95F3-BAE2C4F828ED",
        "378CF92C-B63B-4D7F-84DF-5D2F84CE4753",
        "DD05C32B-EF6C-40DB-A6BB-3A9E3AD75E65"
        "DD05C32B-EF6C-40DB-A6BB-3A9E3AD75E65",
        "C0BBEF88-3FC1-443D-AC9D-EC780080BC93"
      ],
      "refViews": [],
      "refDiagrams": [],
@@ -15993,7 +16354,8 @@
        "7C1D42A1-3178-484D-800D-AF47EC1B2836",
        "26337992-3648-404E-AB89-521D93C6F5DB",
        "401E137A-715C-4AF4-A54C-4EDCB8EB44A6",
        "9F5E1ECC-9826-4C0B-BC55-725E0ADCA2F6"
        "9F5E1ECC-9826-4C0B-BC55-725E0ADCA2F6",
        "3AA9C9FB-86F2-4836-83EB-E2F8B2E540E7"
      ],
      "id": "8270D4EA-5A4E-46A2-B341-B84890AD8F5F"
    }