+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_cloud_authority_user:/tablelist/okayapi_cloud_authority_user.html


-- MySQL Table okayapi_cloud_authority_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_cloud_authority_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_name` varchar(64) NULL COMMENT '用户名称',
    `user_pic` varchar(255) NULL COMMENT '用户头像',
    `third_id` varchar(40) NULL COMMENT '第三方id',
    `third_true_name` varchar(64) NULL COMMENT '真实姓名',
    `user_email` varchar(255) NULL COMMENT '用户邮箱',
    `user_mobile` varchar(20) NULL COMMENT '用户电话',
    `is_valid` int(1) NULL COMMENT '是否启用(0无效,1有效)',
    `is_del` int(1) NULL COMMENT '是否删除(0未删除,1删除)',
    `pwd` varchar(32) NULL COMMENT '',
    `real_name` varchar(32) NULL COMMENT '真实姓名',
    `description` varchar(32) NULL COMMENT '描叙信息',
    `dept` varchar(132) NULL COMMENT '所属部门',
    `last_modify_time` varchar(32) NULL COMMENT '最近修改时间',
    `last_modify_user` varchar(32) NULL COMMENT '最近修改用户',
    `create_time` varchar(32) NULL COMMENT '创建时间',
    `create_user` varchar(32) NULL COMMENT '创建用户',
    `token` varchar(32) NULL COMMENT '',
    KEY `user_name` (`user_name`),
    KEY `user_pic` (`user_pic`),
    KEY `third_id` (`third_id`),
    KEY `third_true_name` (`third_true_name`),
    KEY `user_email` (`user_email`),
    KEY `user_mobile` (`user_mobile`),
    KEY `is_valid` (`is_valid`),
    KEY `is_del` (`is_del`),
    KEY `pwd` (`pwd`),
    KEY `real_name` (`real_name`),
    KEY `description` (`description`),
    KEY `dept` (`dept`),
    KEY `last_modify_time` (`last_modify_time`),
    KEY `last_modify_user` (`last_modify_user`),
    KEY `create_time` (`create_time`),
    KEY `create_user` (`create_user`),
    KEY `token` (`token`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'k8s管理-用户';

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


MySQL database table structure design

Displaying 1-17 of 17 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
user_namevarchar(64)用户名称
user_picvarchar(255)用户头像
third_idvarchar(40)第三方id
third_true_namevarchar(64)真实姓名
user_emailvarchar(255)用户邮箱
user_mobilevarchar(20)用户电话
is_validint(1)是否启用(0无效,1有效)
is_delint(1)是否删除(0未删除,1删除)
pwdvarchar(32)
real_namevarchar(32)真实姓名
descriptionvarchar(32)描叙信息
deptvarchar(132)所属部门
last_modify_timevarchar(32)最近修改时间
last_modify_uservarchar(32)最近修改用户
create_timevarchar(32)创建时间
create_uservarchar(32)创建用户
tokenvarchar(32)

Guess You Like

MySQL Table Design okayapi_cloud_api_resource

MySQL Table Design okayapi_cloud_app

MySQL Table Design okayapi_cloud_app_configure

MySQL Table Design okayapi_cloud_app_service

MySQL Table Design okayapi_log_show_appname

MySQL Table Design okayapi_log_show_ip

MySQL Table Design okayapi_log_show_filter

MySQL Table Design okayapi_log_data_source

MySQL Table Design okayapi_log_show_history

MySQL Table Design okayapi_cloud_app_template

MySQL Table Design okayapi_cloud_auto_scale

MySQL Table Design okayapi_cloud_auto_scale_log

MySQL Table Design okayapi_cloud_build_job

MySQL Table Design okayapi_cloud_build_job_history

MySQL Table Design okayapi_cloud_ci_dockerfile

MySQL Table Design okayapi_cloud_ci_perm

MySQL Table Design okayapi_cloud_ci_release_history

MySQL Table Design okayapi_cloud_ci_release_log

MySQL Table Design okayapi_cloud_ci_service

MySQL Table Design okayapi_cloud_cluster

TOP ↑