查老赖

数据库

ucs

SQL

搜索日志

CREATE TABLE `tb_risk_shixin_search_log` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` int(11) NOT NULL DEFAULT '0',
 `search_key` varchar(255) NOT NULL,
 `search_filter` varchar(2000) 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 `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

热词

CREATE TABLE `tb_risk_shixin_hot_key` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `keyword` varchar(255) NOT NULL,
 `company_name_digest` varchar(32) NOT NULL,
 `operation` varchar(255) NOT NULL DEFAULT 'system',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`),
 KEY `keyword` (`keyword`),
 KEY `company_name_digest` (`company_name_digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8