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

zhangherong

2025-04-08 a4f1c76ccacaf7d1e31ef05268c9806bbcb565e9

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

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

@@ -4,7 +4,7 @@
  "avatar": "",
  "version": "4.9.2",
  "createdTime": "2025-3-10 16:38:19",
  "updatedTime": "2025-4-3 10:59:38",
  "updatedTime": "2025-4-8 16:18:02",
  "dbConns": [],
  "profile": {
    "default": {
@@ -6077,7 +6077,7 @@
        },
        {
          "defKey": "maintenance_date",
          "defName": "计划执行日期",
          "defName": "计划保养日期",
          "comment": "",
          "type": "",
          "len": "",
@@ -6171,6 +6171,35 @@
          "uiHint": null
        },
        {
          "defKey": "image_files",
          "defName": "保养执行图片",
          "comment": "id以逗号分隔",
          "type": "NVARCHAR(MAX)",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "domain": "",
          "refDict": null,
          "extProps": {},
          "notes": {},
          "attr1": "",
          "attr2": "",
          "attr3": "",
          "attr4": "",
          "attr5": "",
          "attr6": "",
          "attr7": "",
          "attr8": "",
          "attr9": "",
          "id": "54A97B48-FC9A-4D82-AFEC-2F637201A38F",
          "baseType": "B17BDED3-085F-40E1-9019-3B79CF2BF075",
          "uiHint": null
        },
        {
          "defKey": "creation_method",
          "defName": "创建方式",
          "comment": "",
@@ -6191,7 +6220,7 @@
        },
        {
          "defKey": "confirm_user",
          "defName": "确认人",
          "defName": "班组长确认人",
          "comment": "",
          "type": "",
          "len": "",
@@ -6248,10 +6277,10 @@
          "uiHint": null
        },
        {
          "defKey": "image_files",
          "defName": "保养执行图片",
          "comment": "id以逗号分隔",
          "type": "NVARCHAR(MAX)",
          "defKey": "confirm_comment",
          "defName": "确认意见",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
@@ -6259,22 +6288,11 @@
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "domain": "",
          "refDict": null,
          "refDict": "",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
          "extProps": {},
          "notes": {},
          "attr1": "",
          "attr2": "",
          "attr3": "",
          "attr4": "",
          "attr5": "",
          "attr6": "",
          "attr7": "",
          "attr8": "",
          "attr9": "",
          "id": "54A97B48-FC9A-4D82-AFEC-2F637201A38F",
          "baseType": "B17BDED3-085F-40E1-9019-3B79CF2BF075",
          "uiHint": null
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "2338A77F-55F7-43BC-A6CC-D818BE8D29A8"
        },
        {
          "defKey": "remark",
@@ -6294,6 +6312,180 @@
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "id": "EC51465B-73D9-49B4-BF56-ED20F35EBD36",
          "uiHint": null
        },
        {
          "defKey": "initial_acceptance_user",
          "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": "C969E09F-8AD1-4A20-A793-6EFAD8610F48"
        },
        {
          "defKey": "initial_acceptance_time",
          "defName": "初验收时间",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "89D69E81-EA34-42EE-9FA2-93B8BD27E098",
          "extProps": {},
          "domain": "7CFFA0D3-6A93-4DDC-BC10-DF21211064DC",
          "id": "B9E49AD8-55AB-4954-84BE-36858D86CAED"
        },
        {
          "defKey": "initial_acceptance_comment",
          "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": "9AC27978-F998-42F3-8936-AD90FF8D29E1"
        },
        {
          "defKey": "initial_acceptance_files",
          "defName": "初验收附件",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "B17BDED3-085F-40E1-9019-3B79CF2BF075",
          "extProps": {},
          "domain": "13DE7063-440C-426F-B1DF-25EC824C6DB8",
          "id": "119F7E0C-A772-4137-8369-7188D6A64E84"
        },
        {
          "defKey": "final_acceptance_user",
          "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": "E1FC7D11-D7AF-43A4-863B-450F3F7F3F3E",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
        },
        {
          "defKey": "final_acceptance_time",
          "defName": "终验收时间",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "domain": "7CFFA0D3-6A93-4DDC-BC10-DF21211064DC",
          "refDict": "",
          "extProps": {},
          "notes": {},
          "attr1": "",
          "attr2": "",
          "attr3": "",
          "attr4": "",
          "attr5": "",
          "attr6": "",
          "attr7": "",
          "attr8": "",
          "attr9": "",
          "id": "7040A23E-9CD9-4BAB-A6D8-D4EBB01DB00E",
          "baseType": "89D69E81-EA34-42EE-9FA2-93B8BD27E098"
        },
        {
          "defKey": "final_acceptance_comment",
          "defName": "终验收意见",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
          "refDict": "",
          "extProps": {},
          "notes": {},
          "attr1": "",
          "attr2": "",
          "attr3": "",
          "attr4": "",
          "attr5": "",
          "attr6": "",
          "attr7": "",
          "attr8": "",
          "attr9": "",
          "id": "5414E5A4-8579-4D96-9C31-F272C24CB59B",
          "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
        },
        {
          "defKey": "final_acceptance_files",
          "defName": "终验收附件",
          "comment": "",
          "type": "",
          "len": "",
          "scale": "",
          "primaryKey": false,
          "notNull": false,
          "autoIncrement": false,
          "defaultValue": "",
          "hideInGraph": false,
          "refDict": "",
          "baseType": "B17BDED3-085F-40E1-9019-3B79CF2BF075",
          "extProps": {},
          "domain": "13DE7063-440C-426F-B1DF-25EC824C6DB8",
          "id": "C33F90DB-84F7-4B0C-A461-8CE40FA3FD5E"
        }
      ],
      "correlations": [],