信用圈

数据库

ucs

SQL

信用圈触发关键字表

CREATE TABLE `tb_credit_circle_keyword` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `keyword` varchar(255) NOT NULL,
 `reply` varchar(2000) DEFAULT NULL,
 `reply1` varchar(2000) NOT NULL,
 `reply2` varchar(2000) NOT NULL,
 `operation` varchar(200) NOT NULL DEFAULT 'system',
 `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0代表自动触发，1代表点击触发',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

十个机器人数据要拷贝

债务

CREATE TABLE `tb_credit_circle_debt` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` int(11) NOT NULL,
 `company_name_digest` varchar(32) NOT NULL,
 `company_name` varchar(200) DEFAULT NULL,
 `assoc_name` varchar(200) NOT NULL,
 `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1该公司欠我方，2我方欠该公司',
 `money` varchar(255) 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 `company_name_digest` (`company_name_digest`),
 KEY `assoc_name` (`assoc_name`),
 KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

被艾特的关系

CREATE TABLE `tb_credit_circle_aite_map` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `company_name_digest` varchar(32) NOT NULL,
 `master_user_id` int(11) NOT NULL COMMENT '艾特用户',
 `slave_user_id` int(11) NOT NULL COMMENT '被艾特的用户',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`),
 KEY `company_name_digest` (`company_name_digest`),
 KEY `masrt_user_id` (`master_user_id`),
 KEY `slave_user_id` (`slave_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8