+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_zd_user_info:/tablelist/okayapi_zd_user_info.html


-- MySQL Table okayapi_zd_user_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_zd_user_info` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_no` varchar(20) NOT NULL COMMENT '用户编号,用于登录等',
    `password` varchar(50) NOT NULL COMMENT '密码',
    `user_name` varchar(50) NOT NULL COMMENT '用户名',
    `email` varchar(50) NOT NULL COMMENT '邮箱',
    `avatar` varchar(100) NOT NULL COMMENT '头像',
    `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0=未删除 1=已删除 2=已停用',
    `create_uid` bigint(20) NOT NULL COMMENT '创建人用户ID',
    `phone` varchar(20) NOT NULL COMMENT '手机号',
    `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '性别 0=女 1=男',
    KEY `user_no` (`user_no`),
    KEY `password` (`password`),
    KEY `user_name` (`user_name`),
    KEY `email` (`email`),
    KEY `avatar` (`avatar`),
    KEY `del_flag` (`del_flag`),
    KEY `create_uid` (`create_uid`),
    KEY `phone` (`phone`),
    KEY `sex` (`sex`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'WIKI-用户信息表';

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


MySQL database table structure design

Displaying 1-9 of 9 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
user_novarchar(20)用户编号,用于登录等Unique Index
passwordvarchar(50)密码
user_namevarchar(50)用户名
emailvarchar(50)邮箱
avatarvarchar(100)头像
del_flagtinyint(4)0是否删除 0=未删除 1=已删除 2=已停用0
create_uidbigint(20)创建人用户ID
phonevarchar(20)手机号
sextinyint(4)0性别 0=女 1=男0

Guess You Like

MySQL Table Design okayapi_zd_auth_info

MySQL Table Design okayapi_zd_user_auth

MySQL Table Design okayapi_zd_wiki_page

MySQL Table Design okayapi_zd_wiki_page_comment

MySQL Table Design okayapi_zd_wiki_page_content

MySQL Table Design okayapi_zd_wiki_page_file

MySQL Table Design okayapi_zd_wiki_page_history

MySQL Table Design okayapi_zd_wiki_page_zan

MySQL Table Design okayapi_zd_wiki_space

MySQL Table Design okayapi_zd_zyplayer_storage

MySQL Table Design okayapi_zd_db_favorite

MySQL Table Design okayapi_zd_db_history

TOP ↑