GitLab

CREATE TABLE `company_early_warning_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司id',
  `time_index` int(11) NOT NULL DEFAULT '0' COMMENT '年月 Ym',
  `data_key` varchar(20) NOT NULL DEFAULT 'lawsuit_count' COMMENT 'lawsuit_count 司法诉讼数量, penalty_count 行政处罚数量, unusual_count 异常名录数量, user_report_count 用户举报数量',
  `data_value` int(11) NOT NULL DEFAULT '0' COMMENT '数值',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_ctd` (`company_id`,`time_index`,`data_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `company_early_warning` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司id',
  `data_key` varchar(20) NOT NULL DEFAULT 'lawsuit_count' COMMENT 'lawsuit_count 司法诉讼数量, penalty_count 行政处罚数量, unusual_count 异常名录数量, user_report_count 用户举报数量',
  `data_value` int(11) NOT NULL DEFAULT '0' COMMENT '数值',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_cd` (`company_id`,`data_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `data_statistics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time_index` int(11) NOT NULL DEFAULT '0' COMMENT '年月 Ym',
  `data_key` varchar(20) NOT NULL DEFAULT 'lawsuit_count' COMMENT 'lawsuit_count 司法诉讼数量, penalty_count 行政处罚数量, unusual_count 异常名录数量, user_report_count 用户举报数量, new_company_count 新增公司数量, total_company_count 公司总数量, early_warning_count 预警数量',
  `data_value` int(11) NOT NULL DEFAULT '0' COMMENT '数值',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_td` (`time_index`,`data_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;