MySQL 建表模板

MySQL 建表模板

create table t_member (
    id bigint unsigned not null auto_increment primary key comment '会员id',
    name  varchar(20) not null comment '会员姓名',
    sex tinyint(1) unsigned not null default 0 comment '性别: 0:无,1:男,2:女',
    citizen_id char(18) null comment '身份证号码',
    update_time datetime on update current_timestamp not null default current_timestamp comment '更新时间',
    create_time datetime not null default current_timestamp comment '创建时间',
    remark varchar(100) null comment '备注'
) engine = innodb default charset = utf8mb4 comment = '会员基础信息表';