From 65265bc02e8d82fba3a02442241c64296cc1da16 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期四, 03 四月 2025 11:46:33 +0800
Subject: [PATCH] art: 设备管理-保养明细表设计修改
---
db/数据库产品化设计.pdma.json | 526 +++++++++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 459 insertions(+), 67 deletions(-)
diff --git "a/db/\346\225\260\346\215\256\345\272\223\344\272\247\345\223\201\345\214\226\350\256\276\350\256\241.pdma.json" "b/db/\346\225\260\346\215\256\345\272\223\344\272\247\345\223\201\345\214\226\350\256\276\350\256\241.pdma.json"
index e8289ed..ab78d08 100644
--- "a/db/\346\225\260\346\215\256\345\272\223\344\272\247\345\223\201\345\214\226\350\256\276\350\256\241.pdma.json"
+++ "b/db/\346\225\260\346\215\256\345\272\223\344\272\247\345\223\201\345\214\226\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-4-2 16:31:59",
+ "updatedTime": "2025-4-3 10:59:38",
"dbConns": [],
"profile": {
"default": {
@@ -5034,24 +5034,6 @@
"baseType": "89D69E81-EA34-42EE-9FA2-93B8BD27E098"
},
{
- "defKey": "del_flag",
- "defName": "鍒犻櫎鏍囪",
- "comment": "",
- "type": "",
- "len": "",
- "scale": "",
- "primaryKey": false,
- "notNull": false,
- "autoIncrement": false,
- "defaultValue": "",
- "hideInGraph": false,
- "refDict": "",
- "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811",
- "extProps": {},
- "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E",
- "id": "39162D96-7C18-41E9-9671-F793292FEE76"
- },
- {
"defKey": "order_id",
"defName": "宸ュ崟ID",
"comment": "",
@@ -5070,8 +5052,8 @@
"id": "A0CAA912-9F8F-4433-B351-5B3CC855B9E9"
},
{
- "defKey": "item_id",
- "defName": "鐐规椤笽D",
+ "defKey": "item_code",
+ "defName": "椤圭洰搴忓彿",
"comment": "",
"type": "",
"len": "",
@@ -5081,11 +5063,77 @@
"autoIncrement": false,
"defaultValue": "",
"hideInGraph": false,
+ "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E",
"refDict": "",
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
"extProps": {},
- "domain": "16120F75-6AA7-4483-868D-F07F511BB081",
- "id": "50AD4BEC-50F3-44B7-BB9A-A5919C291429"
+ "notes": {},
+ "attr1": "",
+ "attr2": "",
+ "attr3": "",
+ "attr4": "",
+ "attr5": "",
+ "attr6": "",
+ "attr7": "",
+ "attr8": "",
+ "attr9": "",
+ "id": "1A6322A1-04F0-4B5D-AF1D-C1464E24055E",
+ "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811"
+ },
+ {
+ "defKey": "item_name",
+ "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": "40482F90-DAA1-4491-8002-E5D2588AEC17",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ },
+ {
+ "defKey": "item_demand",
+ "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": "8C9DE0B4-2106-4EBF-9238-789C2A90B850",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
},
{
"defKey": "inspection_result",
@@ -5104,6 +5152,34 @@
"extProps": {},
"domain": "73FD2BAD-2358-4336-B96D-45DC897BD792",
"id": "E7313542-BDC6-471A-981D-B78AD380ADD7"
+ },
+ {
+ "defKey": "report_flag",
+ "defName": "鎶ヤ慨鏍囪",
+ "comment": "",
+ "type": "",
+ "len": "",
+ "scale": "",
+ "primaryKey": false,
+ "notNull": false,
+ "autoIncrement": false,
+ "defaultValue": "",
+ "hideInGraph": false,
+ "domain": "6F7C1C5C-D159-41E6-BF9D-54DEEFA79AFF",
+ "refDict": "",
+ "extProps": {},
+ "notes": {},
+ "attr1": "",
+ "attr2": "",
+ "attr3": "",
+ "attr4": "",
+ "attr5": "",
+ "attr6": "",
+ "attr7": "",
+ "attr8": "",
+ "attr9": "",
+ "id": "35FA6D36-9C0A-4091-85EA-4EEBF4AAD9CA",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
},
{
"defKey": "exception_description",
@@ -5634,7 +5710,7 @@
"defKey": "image_files",
"defName": "鐓х墖鏂囦欢ids",
"comment": "id浠ラ�楀彿鍒嗛殧",
- "type": "",
+ "type": "NVARCHAR(MAX)",
"len": "",
"scale": "",
"primaryKey": false,
@@ -5642,7 +5718,7 @@
"autoIncrement": false,
"defaultValue": "",
"hideInGraph": false,
- "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
+ "domain": "",
"refDict": "",
"extProps": {},
"notes": {},
@@ -5656,7 +5732,7 @@
"attr8": "",
"attr9": "",
"id": "EE4EB8B1-04DB-4DBF-81D8-149B8DB974A5",
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ "baseType": "B17BDED3-085F-40E1-9019-3B79CF2BF075"
},
{
"defKey": "remark",
@@ -6485,8 +6561,8 @@
"uiHint": null
},
{
- "defKey": "item_id",
- "defName": "淇濆吇椤笽D",
+ "defKey": "item_code",
+ "defName": "椤圭洰搴忓彿",
"comment": "",
"type": "",
"len": "",
@@ -6496,12 +6572,105 @@
"autoIncrement": false,
"defaultValue": "",
"hideInGraph": false,
- "refDict": null,
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
+ "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E",
+ "refDict": "",
"extProps": {},
- "domain": "16120F75-6AA7-4483-868D-F07F511BB081",
- "id": "AECDD803-2B62-4857-8210-CDD8685469F4",
- "uiHint": null
+ "notes": {},
+ "attr1": "",
+ "attr2": "",
+ "attr3": "",
+ "attr4": "",
+ "attr5": "",
+ "attr6": "",
+ "attr7": "",
+ "attr8": "",
+ "attr9": "",
+ "id": "AE188805-76CE-46C8-8699-30F6E9E80C8C",
+ "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811"
+ },
+ {
+ "defKey": "item_name",
+ "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": "E811854D-6262-4068-9D21-F5A3625FFADE",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ },
+ {
+ "defKey": "sub_item_name",
+ "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": "70EEAB74-649A-4F29-8EE2-DE955A614D65",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ },
+ {
+ "defKey": "item_demand",
+ "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": "2E1597EE-EC77-4889-8072-8980A9E850EE",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
},
{
"defKey": "maintenance_result",
@@ -6806,25 +6975,6 @@
"baseType": "89D69E81-EA34-42EE-9FA2-93B8BD27E098"
},
{
- "defKey": "del_flag",
- "defName": "鍒犻櫎鏍囪",
- "comment": "",
- "type": "",
- "len": "",
- "scale": "",
- "primaryKey": false,
- "notNull": false,
- "autoIncrement": false,
- "defaultValue": "",
- "hideInGraph": false,
- "refDict": null,
- "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811",
- "extProps": {},
- "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E",
- "id": "9A747FBA-8305-46F8-8B70-70C5EBCC6048",
- "uiHint": null
- },
- {
"defKey": "order_id",
"defName": "宸ュ崟ID",
"comment": "",
@@ -6844,8 +6994,8 @@
"uiHint": null
},
{
- "defKey": "item_id",
- "defName": "淇濆吇椤笽D",
+ "defKey": "item_code",
+ "defName": "椤圭洰搴忓彿",
"comment": "",
"type": "",
"len": "",
@@ -6855,12 +7005,105 @@
"autoIncrement": false,
"defaultValue": "",
"hideInGraph": false,
- "refDict": null,
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
+ "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E",
+ "refDict": "",
"extProps": {},
- "domain": "16120F75-6AA7-4483-868D-F07F511BB081",
- "id": "A8B565C8-EBED-410E-9E14-F9DF47AF5524",
- "uiHint": null
+ "notes": {},
+ "attr1": "",
+ "attr2": "",
+ "attr3": "",
+ "attr4": "",
+ "attr5": "",
+ "attr6": "",
+ "attr7": "",
+ "attr8": "",
+ "attr9": "",
+ "id": "4128FEA7-A1B8-46C6-B91D-C4809E085D4F",
+ "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811"
+ },
+ {
+ "defKey": "item_name",
+ "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": "4DECC234-F66F-46E8-A720-16533C49A87F",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ },
+ {
+ "defKey": "sub_item_name",
+ "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": "365AB0F0-2D6F-4E40-B13E-01B58A0641B5",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ },
+ {
+ "defKey": "item_demand",
+ "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": "59BC967D-166B-4540-88A9-475A17A3CB1F",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
},
{
"defKey": "maintenance_result",
@@ -6880,6 +7123,34 @@
"domain": "73FD2BAD-2358-4336-B96D-45DC897BD792",
"id": "04206397-FC18-4115-80E6-3BC4ECCDBFF1",
"uiHint": null
+ },
+ {
+ "defKey": "report_flag",
+ "defName": "鎶ヤ慨鏍囪",
+ "comment": "",
+ "type": "",
+ "len": "",
+ "scale": "",
+ "primaryKey": false,
+ "notNull": false,
+ "autoIncrement": false,
+ "defaultValue": "",
+ "hideInGraph": false,
+ "domain": "6F7C1C5C-D159-41E6-BF9D-54DEEFA79AFF",
+ "refDict": "",
+ "extProps": {},
+ "notes": {},
+ "attr1": "",
+ "attr2": "",
+ "attr3": "",
+ "attr4": "",
+ "attr5": "",
+ "attr6": "",
+ "attr7": "",
+ "attr8": "",
+ "attr9": "",
+ "id": "8C674EE8-2BEA-4778-B3AD-2545480FF017",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
},
{
"defKey": "exception_description",
@@ -7771,8 +8042,8 @@
"uiHint": null
},
{
- "defKey": "item_id",
- "defName": "淇濆吇椤笽D",
+ "defKey": "item_code",
+ "defName": "椤圭洰搴忓彿",
"comment": "",
"type": "",
"len": "",
@@ -7782,12 +8053,133 @@
"autoIncrement": false,
"defaultValue": "",
"hideInGraph": false,
- "refDict": null,
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
+ "domain": "6BC8F04B-6CFA-4995-98D3-318F5CDD774E",
+ "refDict": "",
"extProps": {},
- "domain": "16120F75-6AA7-4483-868D-F07F511BB081",
- "id": "FB3A79A6-5D6C-46F1-BA69-66D2C93BCC65",
- "uiHint": null
+ "notes": {},
+ "attr1": "",
+ "attr2": "",
+ "attr3": "",
+ "attr4": "",
+ "attr5": "",
+ "attr6": "",
+ "attr7": "",
+ "attr8": "",
+ "attr9": "",
+ "id": "F5AA0F54-8AAC-4B45-80C1-A001743C2F91",
+ "baseType": "1D764C4A-6F9F-421E-B11A-6F3E23B51811"
+ },
+ {
+ "defKey": "item_name",
+ "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": "18AD988B-4B72-485A-9970-F6DA09DEE706",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ },
+ {
+ "defKey": "sub_item_name",
+ "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": "6C472DCB-47D7-4C1C-BD5B-4DA4D43D4FF7",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ },
+ {
+ "defKey": "item_demand",
+ "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": "19345E5D-63BB-4ADA-BE3C-93443CDCE5FC",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ },
+ {
+ "defKey": "report_flag",
+ "defName": "鎶ヤ慨鏍囪",
+ "comment": "",
+ "type": "",
+ "len": "",
+ "scale": "",
+ "primaryKey": false,
+ "notNull": false,
+ "autoIncrement": false,
+ "defaultValue": "",
+ "hideInGraph": false,
+ "domain": "6F7C1C5C-D159-41E6-BF9D-54DEEFA79AFF",
+ "refDict": "",
+ "extProps": {},
+ "notes": {},
+ "attr1": "",
+ "attr2": "",
+ "attr3": "",
+ "attr4": "",
+ "attr5": "",
+ "attr6": "",
+ "attr7": "",
+ "attr8": "",
+ "attr9": "",
+ "id": "833FA58B-3317-4A5C-9C06-355B8947E192",
+ "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
},
{
"defKey": "maintenance_result",
--
Gitblit v1.9.3