企业工商异常名录通知

数据库

wiki
SQL

CREATE TABLE `tb_company_business_abnormal_list` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `company_name_digest` varchar(32) NOT NULL DEFAULT '' COMMENT '企业名称digest',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态，1为异常中，2为移除',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_digest` (`company_name_digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='企业工商异常名录通知表';