+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_zheng_upms_user:/tablelist/okayapi_zheng_upms_user.html


-- MySQL Table okayapi_zheng_upms_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_upms_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `username` varchar(20) NULL COMMENT '帐号',
    `okayapi_zheng_upms_user_password` varchar(32) NULL COMMENT '密码MD5(密码+盐)',
    `salt` varchar(32) NULL COMMENT '盐',
    `realname` varchar(20) NULL COMMENT '姓名',
    `avatar` varchar(150) NULL COMMENT '头像',
    `phone` varchar(20) NULL COMMENT '电话',
    `email` varchar(50) NULL COMMENT '邮箱',
    `sex` tinyint(4) NULL COMMENT '性别',
    `locked` tinyint(4) NULL COMMENT '状态(0:正常,1:锁定)',
    `ctime` bigint(20) NULL COMMENT '创建时间',
    KEY `username` (`username`),
    KEY `okayapi_zheng_upms_user_password` (`okayapi_zheng_upms_user_password`),
    KEY `salt` (`salt`),
    KEY `realname` (`realname`),
    KEY `avatar` (`avatar`),
    KEY `phone` (`phone`),
    KEY `email` (`email`),
    KEY `sex` (`sex`),
    KEY `locked` (`locked`),
    KEY `ctime` (`ctime`),
    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-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
usernamevarchar(20)帐号
okayapi_zheng_upms_user_passwordvarchar(32)密码MD5(密码+盐)
saltvarchar(32)
realnamevarchar(20)姓名
avatarvarchar(150)头像
phonevarchar(20)电话
emailvarchar(50)邮箱
sextinyint(4)性别
lockedtinyint(4)状态(0:正常,1:锁定)
ctimebigint(20)创建时间

Guess You Like

MySQL Table Design okayapi_logs

MySQL Table Design okayapi_app_version

MySQL Table Design okayapi_tea

MySQL Table Design okayapi_tea_swiper

MySQL Table Design okayapi_tea_moment

MySQL Table Design okayapi_tea_order

MySQL Table Design okayapi_tea_user

MySQL Table Design okayapi_tea_shopcar

MySQL Table Design okayapi_zheng_cms_article

MySQL Table Design okayapi_zheng_cms_article_category

MySQL Table Design okayapi_zheng_cms_article_tag

MySQL Table Design okayapi_zheng_cms_category

MySQL Table Design okayapi_zheng_cms_comment

MySQL Table Design okayapi_zheng_cms_page

MySQL Table Design okayapi_zheng_cms_setting

MySQL Table Design okayapi_zheng_cms_system

MySQL Table Design okayapi_zheng_cms_tag

MySQL Table Design okayapi_zheng_cms_topic

MySQL Table Design okayapi_zheng_pay_in_order

MySQL Table Design okayapi_zheng_pay_in_order_detail

TOP ↑