+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_kite_auth_user:/tablelist/okayapi_kite_auth_user.html


-- MySQL Table okayapi_kite_auth_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_kite_auth_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `uid` int(11) NULL COMMENT 'UID',
    `role_ids` varchar(64) NULL COMMENT '用户所属角色组',
    `username` varchar(64) NULL COMMENT '用户名',
    `password` varchar(255) NULL COMMENT '管理员密码',
    `phone` char(11) NULL COMMENT '手机号',
    `email` varchar(255) NULL COMMENT '电子邮箱',
    `status` tinyint(4) NULL DEFAULT '0' COMMENT '状态 0 正常 1禁用',
    `score` int(11) NULL COMMENT '积分',
    `avatar` varchar(255) NULL COMMENT '头像',
    `resume` varchar(500) NULL COMMENT '个人简介',
    `create_at` int(11) NULL COMMENT '创建时间',
    `update_at` int(11) NULL COMMENT '',
    KEY `uid` (`uid`),
    KEY `role_ids` (`role_ids`),
    KEY `username` (`username`),
    KEY `password` (`password`),
    KEY `phone` (`phone`),
    KEY `email` (`email`),
    KEY `status` (`status`),
    KEY `score` (`score`),
    KEY `avatar` (`avatar`),
    KEY `resume` (`resume`),
    KEY `create_at` (`create_at`),
    KEY `update_at` (`update_at`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '建站系统-用户所属表';

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


MySQL database table structure design

Displaying 1-12 of 12 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
uidint(11)UID
role_idsvarchar(64)用户所属角色组
usernamevarchar(64)用户名Unique Index
passwordvarchar(255)管理员密码
phonechar(11)手机号Normal Index
emailvarchar(255)电子邮箱Normal Index
statustinyint(4)0状态 0 正常 1禁用0
scoreint(11)积分
avatarvarchar(255)头像
resumevarchar(500)个人简介
create_atint(11)创建时间Normal Index
update_atint(11)

Guess You Like

MySQL Table Design okayapi_kite_addons

MySQL Table Design okayapi_kite_auth_role

MySQL Table Design okayapi_kite_auth_rule

MySQL Table Design okayapi_kite_block

MySQL Table Design okayapi_kite_document_category

MySQL Table Design okayapi_kite_document_comments

MySQL Table Design okayapi_kite_document_comments_like

MySQL Table Design okayapi_kite_document_content

MySQL Table Design okayapi_kite_document_content_extra

MySQL Table Design okayapi_kite_document_content_like

MySQL Table Design okayapi_kite_document_field

MySQL Table Design okayapi_kite_document_model

MySQL Table Design okayapi_kite_document_model_field

MySQL Table Design okayapi_kite_feedback

MySQL Table Design okayapi_kite_hooks

MySQL Table Design okayapi_kite_language

MySQL Table Design okayapi_kite_link

MySQL Table Design okayapi_kite_log

MySQL Table Design okayapi_kite_message

MySQL Table Design okayapi_kite_navigation

TOP ↑