okayapi_zheng_ucenter_user_details - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_zheng_ucenter_user_details：/tablelist/okayapi_zheng_ucenter_user_details.html


-- MySQL Table okayapi_zheng_ucenter_user_details
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_ucenter_user_details` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `signature` varchar(300) NULL COMMENT '个性签名',
    `real_name` varchar(20) NULL COMMENT '真实姓名',
    `birthday` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '出生日期',
    `question` varchar(100) NULL COMMENT '帐号安全问题',
    `answer` varchar(100) NULL COMMENT '帐号安全答案',
    KEY `signature` (`signature`),
    KEY `real_name` (`real_name`),
    KEY `birthday` (`birthday`),
    KEY `question` (`question`),
    KEY `answer` (`answer`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'zheng敏捷开发-用户详情表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-5 of 5 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
signature	varchar(300)		是	个性签名
real_name	varchar(20)		是	真实姓名
birthday	timestamp	CURRENT_TIMESTAMP	否	出生日期	CURRENT_TIMESTAMP
question	varchar(100)		是	帐号安全问题
answer	varchar(100)		是	帐号安全答案