-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
False
-
False
-
CREATE TABLE recon_data_dependency (
id BIGINT UNSIGNED unsigned AUTO_INCREMENT NOT NULL COMMENT '自增 ID',
table_name VARCHAR(100) DEFAULT '' NOT NULL COMMENT '依赖表名',
date VARCHAR(32) DEFAULT '' NOT NULL COMMENT '日期',
status TINYINT DEFAULT 1 NOT NULL COMMENT '依赖表状态,1-初始 2-同步中 3-同步失败 4-同步完成',
sync_offset BIGINT DEFAULT 0 NOT NULL COMMENT '同步偏移量',
ready_time BIGINT DEFAULT 0 NOT NULL COMMENT '依赖表就绪时间',
created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '创建时间',
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '更新时间',
UNIQUE INDEX uniq_table_name_date (table_name, date),
PRIMARY KEY(id)) COMMENT = '任务数据依赖表'