+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_migo_sys_user:/tablelist/okayapi_migo_sys_user.html


-- MySQL Table okayapi_migo_sys_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_migo_sys_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NULL COMMENT '',
    `username` varchar(50) NULL COMMENT '用户名',
    `okayapi_migo_sys_user_password` varchar(100) NULL COMMENT '密码',
    `email` varchar(100) NULL COMMENT '邮箱',
    `mobile` varchar(100) NULL COMMENT '手机号',
    `okayapi_migo_sys_user_status` tinyint(4) NULL COMMENT '状态  0:禁用   1:正常',
    `create_user_id` bigint(20) NULL COMMENT '创建者ID',
    `create_time` datetime NULL COMMENT '创建时间',
    KEY `user_id` (`user_id`),
    KEY `username` (`username`),
    KEY `okayapi_migo_sys_user_password` (`okayapi_migo_sys_user_password`),
    KEY `email` (`email`),
    KEY `mobile` (`mobile`),
    KEY `okayapi_migo_sys_user_status` (`okayapi_migo_sys_user_status`),
    KEY `create_user_id` (`create_user_id`),
    KEY `create_time` (`create_time`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'migo权限管理-系统用户';

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


MySQL database table structure design

Displaying 1-8 of 8 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
user_idbigint(20)
usernamevarchar(50)用户名Unique Index
okayapi_migo_sys_user_passwordvarchar(100)密码
emailvarchar(100)邮箱
mobilevarchar(100)手机号
okayapi_migo_sys_user_statustinyint(4)状态 0:禁用 1:正常
create_user_idbigint(20)创建者ID
create_timedatetime创建时间

Guess You Like

MySQL Table Design okayapi_migo_schedule_job

MySQL Table Design okayapi_migo_schedule_job_log

MySQL Table Design okayapi_migo_sys_config

MySQL Table Design okayapi_migo_sys_log

MySQL Table Design okayapi_migo_sys_menu

MySQL Table Design okayapi_migo_sys_oss

MySQL Table Design okayapi_migo_sys_role

MySQL Table Design okayapi_migo_sys_role_menu

MySQL Table Design okayapi_migo_sys_user_role

MySQL Table Design okayapi_migo_tb_token

MySQL Table Design okayapi_migo_tb_user

MySQL Table Design okayapi_rights_assign

TOP ↑