matesoul commented on issue #3638:
URL:
https://github.com/apache/incubator-seatunnel/issues/3638#issuecomment-1336154470
CREATE TABLE `bd_dq_rule` (
`id` bigint unsigned NOT NULL COMMENT '主键ID',
`code` varchar(100) DEFAULT NULL COMMENT '规则编号',
`name` varchar(100) DEFAULT NULL COMMENT '规则名称',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`dimension` tinyint unsigned DEFAULT NULL COMMENT
'质量维度（1：完整性，2：有效性，3：准确性，4：唯一性，5：一致性，6：合理性）',
`grain` tinyint unsigned DEFAULT NULL COMMENT '检核粒度（1：表级，2：字段级）',
`type` tinyint unsigned DEFAULT NULL COMMENT '类型（0：数值型，1：波动率型）',
`del_flag` tinyint unsigned DEFAULT '0' COMMENT '删除状态（0：正常，1：已删除）',
`create_by` varchar(64) NOT NULL COMMENT '创建人',
`create_time` bigint unsigned NOT NULL COMMENT '创建时间',
`update_by` varchar(64) NOT NULL COMMENT '修改人',
`update_time` bigint unsigned NOT NULL COMMENT '修改时间',
PRIMARY KEY (`id`),
KEY `idx_code` (`code`) USING BTREE COMMENT '编号',
KEY `idx_name` (`name`) USING BTREE COMMENT '名称',
KEY `idx_flag` (`del_flag`) USING BTREE COMMENT '删除状态',
KEY `idx_create_time` (`create_time`) USING BTREE COMMENT '创建时间',
KEY `idx_grain` (`grain`) USING BTREE COMMENT '检核粒度'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='度量规则信息表';
INSERT INTO bd_dq_rule
(id,code,name,description,dimension,grain,`type`,del_flag,create_by,create_time,update_by,update_time)
VALUES
(5,'T5','表行数，1天波动率。','基准值为昨天的样本（表行数），比较当天采集的表行数，对比波动率。',6,1,1,0,'admin',1651137665807,'admin',1651137665807);
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
