From 720eb777fc52d44639c19db1342f72717dc77c6a Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期三, 19 三月 2025 11:39:48 +0800
Subject: [PATCH] art: 设备管理数据库设计修改
---
db/数据库产品化设计.pdma.json | 418 +++++++++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 390 insertions(+), 28 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 af1f06a..0ecca2c 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-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"
}
--
Gitblit v1.9.3