GitLab

数据库：ucs

表名：tb_biz_hot_person

sql：

CREATE TABLE `tb_biz_hot_person` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(225) NOT NULL,
  `company_name_digest` varchar(32) NOT NULL,
  `person_name` varchar(255) NOT NULL,
  `hot_title` varchar(100) NOT NULL,
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_tb_biz_hot_person_company_name` (`company_name`),
  KEY `ix_tb_biz_hot_person_person_name` (`person_name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8