GitLab

#数据库 ucs

CREATE TABLE `tb_person_vip_sign` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` int(11) NOT NULL,
 `agreement_no` varchar(255) NOT NULL,
 `sign_price` float(11,4) NOT NULL DEFAULT '0.0000',
 `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1有效，2无效',
 `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`),
 KEY `agreement_no` (`agreement_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `tb_person_auto_log` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` int(11) NOT NULL,
 `execute_time` timestamp NULL DEFAULT NULL,
 `status` tinyint(1) NOT NULL COMMENT '1有效，2无效',
 `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1签约，2延迟',
 `result` varchar(2500) DEFAULT 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_person_sign_price` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `order_no` varchar(64) NOT NULL,
 `sign_price` float(11,4) NOT NULL,
 `execute_time` timestamp NULL DEFAULT NULL,
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`),
 KEY `order_no` (`order_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8