Mysqlテーブル構造

remark :

CREATE DATABASE `citic-fans-service` DEFAULT CHARACTER SET utf8mb4;


/* USE `citic-fans-service`; */


DROP TABLE IF EXISTS `t_user`;


CREATE TABLE `t_user` (
  `id` bigint(30) NOT NULL AUTO_INCREMENT,
  `open_id` varchar(100) DEFAULT NULL COMMENT '  openId',
  `nick_name` varchar(255) DEFAULT NULL COMMENT '  ',
  `head_img_url` varchar(255) DEFAULT NULL COMMENT '  ',
  `channels` varchar(50) DEFAULT '' COMMENT '  ',
  `init_sub` int(1) DEFAULT '1' COMMENT '0      1                 ',
  `ever_sub` int(1) DEFAULT '1' COMMENT '       0     1  ',
  `now_sub` int(1) DEFAULT '1' COMMENT '        0     1  ',
  `join_activity` int(1) DEFAULT '0' COMMENT '            ',
  `join_as_activity` varchar(255) DEFAULT NULL COMMENT '       ',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '    ',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '    ',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_openId` (`open_id`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;


ALTER TABLE t_user MODIFY create_time timestamp NULL DEFAULT NULL COMMENT '    ';