22 lines
677 B
SQL
22 lines
677 B
SQL
-- Version: 2025.7.31 14:52:27
|
||
Drop Table T_STA_SAMPLE@
|
||
|
||
Create Table T_STA_SAMPLE(
|
||
tagName VARCHAR(50) NOT NULL,
|
||
tagDate TIMESTAMP NOT NULL,
|
||
type VARCHAR(50) NOT NULL,
|
||
tagChinese VARCHAR(100),
|
||
data ,
|
||
CONSTRAINT pk_T_STA_SAMPLE PRIMARY KEY (tagName, tagDate, type)
|
||
)
|
||
IN TB8KUSREMS INDEX IN TB8KIDXEMS@
|
||
|
||
COMMENT ON Table T_STA_SAMPLE IS '统计数据样本'@
|
||
|
||
COMMENT ON T_STA_SAMPLE (tagName IS 'TagName')@
|
||
COMMENT ON T_STA_SAMPLE (tagDate IS '记录时间')@
|
||
COMMENT ON T_STA_SAMPLE (type IS '样本类型')@
|
||
COMMENT ON T_STA_SAMPLE (tagChinese IS 'Tag点中文')@
|
||
COMMENT ON T_STA_SAMPLE (data IS '具体的数据分布情况，JSON格式（最大1000个值）')@
|
||
|