'
⽤户信息表
(customer_inf)
CREATE TABLE customer_inf(
customer_inf_id INT UNSIGNED AUTO_INCREMENT NOT NULL COMMENT '
⾃增主键
ID',
customer_id INT UNSIGNED NOT NULL COMMENT 'customer_login
表的⾃增
ID',
customer_name VARCHAR(20) NOT NULL COMMENT '
⽤户真实姓名
',
identity_card_type TINYINT NOT NULL DEFAULT 1 COMMENT '
证件类型:
1
⾝份证,
2
军官证,
3
护照
',
identity_card_no VARCHAR(20) COMMENT '
证件号码
',
mobile_phone INT UNSIGNED COMMENT '
⼿机号
',
customer_email VARCHAR(50) COMMENT '
邮箱
',
gender CHAR(1) COMMENT '
性别
',
user_point INT NOT NULL DEFAULT 0 COMMENT '
⽤户积分
',
register_time TIMESTAMP NOT NULL COMMENT '
注册时间
',
birthday DATETIME COMMENT '
会员⽣⽇
',
customer_level TINYINT NOT NULL DEFAULT 1 COMMENT '
会员级别:
1
普通会员,
2
青铜,
3
⽩银,
4
黄⾦,
5
钻⽯
',
user_money DECIMAL(8,2) NOT NULL DEFAULT 0.00 COMMENT '
⽤户余额
',
modified_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '
最后修改时间
',
PRIMARY KEY pk_customerinfid(customer_inf_id)
) ENGINE = innodb COMMENT '
⽤户信息表