From 180a6391cf13bee5d95579b2317cd5d8c64bb80c Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期一, 21 四月 2025 17:31:30 +0800
Subject: [PATCH] art: 设备管理-数据库设计整理修改
---
db/数据库产品化设计.pdma.json | 96 +++++++++++++++++++++++++++++++++++++----------
1 files changed, 75 insertions(+), 21 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 b56842e..11b75a8 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-17 16:10:18",
+ "updatedTime": "2025-4-21 17:30:43",
"dbConns": [],
"profile": {
"default": {
@@ -3923,9 +3923,9 @@
"defaultValue": "",
"hideInGraph": false,
"refDict": "",
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
+ "baseType": "B17BDED3-085F-40E1-9019-3B79CF2BF075",
"extProps": {},
- "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
+ "domain": "13DE7063-440C-426F-B1DF-25EC824C6DB8",
"id": "5576D652-16B0-4098-A22E-0B2F5EF98107"
}
],
@@ -4809,7 +4809,7 @@
{
"defKey": "image_files",
"defName": "鐓х墖鏂囦欢ids",
- "comment": "id浠ラ�楀彿鍒嗛殧",
+ "comment": "",
"type": "",
"len": "",
"scale": "",
@@ -4819,9 +4819,9 @@
"defaultValue": "",
"hideInGraph": false,
"refDict": "",
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64",
+ "baseType": "B17BDED3-085F-40E1-9019-3B79CF2BF075",
"extProps": {},
- "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
+ "domain": "13DE7063-440C-426F-B1DF-25EC824C6DB8",
"id": "F42A4411-75B9-4486-8B8D-98A86DB0F861"
}
],
@@ -5745,8 +5745,8 @@
{
"defKey": "image_files",
"defName": "鐓х墖鏂囦欢ids",
- "comment": "id浠ラ�楀彿鍒嗛殧",
- "type": "NVARCHAR(MAX)",
+ "comment": "",
+ "type": "",
"len": "",
"scale": "",
"primaryKey": false,
@@ -5754,7 +5754,7 @@
"autoIncrement": false,
"defaultValue": "",
"hideInGraph": false,
- "domain": "",
+ "domain": "13DE7063-440C-426F-B1DF-25EC824C6DB8",
"refDict": "",
"extProps": {},
"notes": {},
@@ -6209,8 +6209,8 @@
{
"defKey": "image_files",
"defName": "淇濆吇鎵ц鍥剧墖",
- "comment": "id浠ラ�楀彿鍒嗛殧",
- "type": "NVARCHAR(MAX)",
+ "comment": "",
+ "type": "",
"len": "",
"scale": "",
"primaryKey": false,
@@ -6218,7 +6218,7 @@
"autoIncrement": false,
"defaultValue": "",
"hideInGraph": false,
- "domain": "",
+ "domain": "13DE7063-440C-426F-B1DF-25EC824C6DB8",
"refDict": null,
"extProps": {},
"notes": {},
@@ -7959,7 +7959,7 @@
{
"defKey": "image_files",
"defName": "鐓х墖鏂囦欢ids",
- "comment": "id浠ラ�楀彿鍒嗛殧",
+ "comment": "",
"type": "",
"len": "",
"scale": "",
@@ -7968,7 +7968,7 @@
"autoIncrement": false,
"defaultValue": "",
"hideInGraph": false,
- "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
+ "domain": "13DE7063-440C-426F-B1DF-25EC824C6DB8",
"refDict": "",
"extProps": {},
"notes": {},
@@ -7982,7 +7982,7 @@
"attr8": "",
"attr9": "",
"id": "4D8E08DB-BB54-49DE-A079-8B5F92964F14",
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ "baseType": "B17BDED3-085F-40E1-9019-3B79CF2BF075"
},
{
"defKey": "remark",
@@ -9788,6 +9788,24 @@
"id": "522BCC0E-5AE9-4473-BE36-A68202A7E1ED"
},
{
+ "defKey": "fault_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": "A55D711F-243B-4B6B-84E0-471527DAE875"
+ },
+ {
"defKey": "fault_type",
"defName": "鏁呴殰鍒嗙被",
"comment": "",
@@ -9844,7 +9862,7 @@
{
"defKey": "image_files",
"defName": "鐓х墖鏂囦欢ids",
- "comment": "id浠ラ�楀彿鍒嗛殧",
+ "comment": "",
"type": "",
"len": "",
"scale": "",
@@ -9853,7 +9871,7 @@
"autoIncrement": false,
"defaultValue": "",
"hideInGraph": false,
- "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
+ "domain": "13DE7063-440C-426F-B1DF-25EC824C6DB8",
"refDict": "",
"extProps": {},
"notes": {},
@@ -9867,7 +9885,7 @@
"attr8": "",
"attr9": "",
"id": "0552EC0A-4846-49B3-BA5A-6049CD295D13",
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ "baseType": "B17BDED3-085F-40E1-9019-3B79CF2BF075"
},
{
"defKey": "remark",
@@ -10405,7 +10423,7 @@
{
"defKey": "image_files",
"defName": "鐓х墖鏂囦欢ids",
- "comment": "id浠ラ�楀彿鍒嗛殧",
+ "comment": "",
"type": "",
"len": "",
"scale": "",
@@ -10414,7 +10432,7 @@
"autoIncrement": false,
"defaultValue": "",
"hideInGraph": false,
- "domain": "9092C4E0-1A54-4859-ABBB-5B62DBC27573",
+ "domain": "13DE7063-440C-426F-B1DF-25EC824C6DB8",
"refDict": "",
"extProps": {},
"notes": {},
@@ -10428,7 +10446,43 @@
"attr8": "",
"attr9": "",
"id": "F12C512D-9550-40EA-8583-C6476F69C135",
- "baseType": "FC9790A7-36B8-4A48-8F9A-BC1042BCFE64"
+ "baseType": "B17BDED3-085F-40E1-9019-3B79CF2BF075"
+ },
+ {
+ "defKey": "is_use_spare",
+ "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": "36816184-4B15-4AC7-A460-4E8EC004871D"
+ },
+ {
+ "defKey": "spare_part_description",
+ "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": "3945E6D0-A58E-4B40-AFDA-6D8D477DE78F"
}
],
"correlations": [],
--
Gitblit v1.9.3