+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_ry_sys_user:/tablelist/okayapi_ry_sys_user.html


-- MySQL Table okayapi_ry_sys_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_ry_sys_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `email` varchar(50) NULL COMMENT '用户邮箱',
    `phonenumber` varchar(11) NULL COMMENT '手机号码',
    `sex` char(1) NULL DEFAULT '0' COMMENT '用户性别(0男 1女 2未知)',
    `avatar` varchar(100) NULL COMMENT '头像路径',
    `okayapi_ry_sys_user_password` varchar(50) NULL COMMENT '密码',
    `salt` varchar(20) NULL COMMENT '盐加密',
    `okayapi_ry_sys_user_status` char(1) NULL DEFAULT '0' COMMENT '帐号状态(0正常 1停用)',
    `del_flag` char(1) NULL DEFAULT '0' COMMENT '删除标志(0代表存在 2代表删除)',
    `login_ip` varchar(128) NULL COMMENT '最后登录IP',
    `login_date` datetime NULL COMMENT '最后登录时间',
    `pwd_update_date` datetime NULL COMMENT '密码最后更新时间',
    `create_by` varchar(64) NULL COMMENT '创建者',
    `create_time` datetime NULL COMMENT '创建时间',
    `update_by` varchar(64) NULL COMMENT '更新者',
    `remark` varchar(500) NULL COMMENT '备注',
    `user_id` bigint(20) NULL COMMENT '用户ID',
    `dept_id` bigint(20) NULL COMMENT '部门ID',
    `login_name` varchar(30) NULL COMMENT '登录账号',
    `user_name` varchar(30) NULL COMMENT '用户昵称',
    `user_type` varchar(2) NULL DEFAULT '00' COMMENT '用户类型(00系统用户 01注册用户)',
    KEY `email` (`email`),
    KEY `phonenumber` (`phonenumber`),
    KEY `sex` (`sex`),
    KEY `avatar` (`avatar`),
    KEY `okayapi_ry_sys_user_password` (`okayapi_ry_sys_user_password`),
    KEY `salt` (`salt`),
    KEY `okayapi_ry_sys_user_status` (`okayapi_ry_sys_user_status`),
    KEY `del_flag` (`del_flag`),
    KEY `login_ip` (`login_ip`),
    KEY `login_date` (`login_date`),
    KEY `pwd_update_date` (`pwd_update_date`),
    KEY `create_by` (`create_by`),
    KEY `create_time` (`create_time`),
    KEY `update_by` (`update_by`),
    KEY `remark` (`remark`),
    KEY `user_id` (`user_id`),
    KEY `dept_id` (`dept_id`),
    KEY `login_name` (`login_name`),
    KEY `user_name` (`user_name`),
    KEY `user_type` (`user_type`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'RuoYi后台管理系统-用户信息表';

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


MySQL database table structure design

Displaying 1-20 of 20 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
emailvarchar(50)用户邮箱
phonenumbervarchar(11)手机号码
sexchar(1)0用户性别(0男 1女 2未知)0
avatarvarchar(100)头像路径
okayapi_ry_sys_user_passwordvarchar(50)密码
saltvarchar(20)盐加密
okayapi_ry_sys_user_statuschar(1)0帐号状态(0正常 1停用)0
del_flagchar(1)0删除标志(0代表存在 2代表删除)0
login_ipvarchar(128)最后登录IP
login_datedatetime最后登录时间
pwd_update_datedatetime密码最后更新时间
create_byvarchar(64)创建者
create_timedatetime创建时间
update_byvarchar(64)更新者
remarkvarchar(500)备注
user_idbigint(20)用户ID
dept_idbigint(20)部门ID
login_namevarchar(30)登录账号
user_namevarchar(30)用户昵称
user_typevarchar(2)00用户类型(00系统用户 01注册用户)00

Guess You Like

MySQL Table Design okayapi_ry_sys_dept

MySQL Table Design okayapi_ry_sys_post

MySQL Table Design okayapi_ry_sys_role

MySQL Table Design okayapi_ry_sys_menu

MySQL Table Design okayapi_ry_sys_user_role

MySQL Table Design okayapi_ry_sys_role_menu

MySQL Table Design okayapi_ry_sys_role_dept

MySQL Table Design okayapi_ry_sys_user_post

MySQL Table Design okayapi_ry_sys_oper_log

MySQL Table Design okayapi_ry_sys_dict_type

MySQL Table Design okayapi_ry_sys_dict_data

MySQL Table Design okayapi_ry_sys_config

MySQL Table Design okayapi_ry_sys_logininfor

MySQL Table Design okayapi_ry_sys_user_online

MySQL Table Design okayapi_ry_sys_job

MySQL Table Design okayapi_ry_sys_job_log

MySQL Table Design okayapi_ry_sys_notice

MySQL Table Design okayapi_ry_gen_table

MySQL Table Design okayapi_ry_gen_table_column

TOP ↑