From e8ad669f7c97d45cd23630dc101180a130d6c17e Mon Sep 17 00:00:00 2001
From: dongyukun <1208714201@qq.com>
Date: 星期二, 05 十一月 2024 10:04:57 +0800
Subject: [PATCH] tag当前值开发
---
iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql b/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql
index 660929d..f6e6d3c 100644
--- a/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql
+++ b/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql
@@ -159,7 +159,8 @@
`source_type` VARCHAR(10) COMMENT '数据源类型',
`source_id` VARCHAR(36) COMMENT '数据源ID',
`tag_no` VARCHAR(64) COMMENT '测点Tag',
- `dimension` INT COMMENT '尺度' ,
+ `dimension` INT COMMENT '平滑尺度(min)' ,
+ `value_type` VARCHAR(36) COMMENT '值类型(数字量，模拟量)',
PRIMARY KEY (id) USING BTREE,
UNIQUE KEY `uk_point_id` (`point_id`) USING BTREE,
KEY `uk_tag_no` (`tag_no`) USING BTREE
@@ -283,7 +284,7 @@
`item_no` VARCHAR(36) COMMENT '指标编码' ,
`item_name` VARCHAR(36) COMMENT '指标名称' ,
`item_type` VARCHAR(20) COMMENT '指标类型' ,
- `item_category` VARCHAR(20) COMMENT '指标分类' ,
+ `item_category` VARCHAR(36) COMMENT '指标分类' ,
`coefficient` decimal(10, 4) COMMENT '转换系数',
`precision` int COMMENT '指标精度',
`time_granularity` VARCHAR(10) COMMENT '时间粒度' ,
--
Gitblit v1.9.3