+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_qi_ace_base_user:/tablelist/okayapi_qi_ace_base_user.html


-- MySQL Table okayapi_qi_ace_base_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_qi_ace_base_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `username` varchar(255) NULL COMMENT '',
    `okayapi_qi_ace_base_user_password` varchar(255) NULL COMMENT '',
    `okayapi_qi_ace_base_user_name` varchar(255) NULL COMMENT '',
    `birthday` varchar(255) NULL COMMENT '',
    `address` varchar(255) NULL COMMENT '',
    `mobile_phone` varchar(255) NULL COMMENT '',
    `tel_phone` varchar(255) NULL COMMENT '',
    `email` varchar(255) NULL COMMENT '',
    `sex` char(1) NULL COMMENT '',
    `okayapi_qi_ace_base_user_type` char(1) NULL COMMENT '',
    `okayapi_qi_ace_base_user_status` char(1) NULL COMMENT '',
    `description` varchar(255) NULL COMMENT '',
    `crt_time` datetime NULL COMMENT '',
    `crt_user` varchar(255) NULL COMMENT '',
    `crt_name` varchar(255) NULL COMMENT '',
    `crt_host` varchar(255) NULL COMMENT '',
    `upd_time` datetime NULL COMMENT '',
    `upd_user` varchar(255) NULL COMMENT '',
    `upd_name` varchar(255) NULL COMMENT '',
    `upd_host` varchar(255) NULL COMMENT '',
    `attr1` varchar(255) NULL COMMENT '',
    `attr2` varchar(255) NULL COMMENT '',
    `attr3` varchar(255) NULL COMMENT '',
    `attr4` varchar(255) NULL COMMENT '',
    `attr5` varchar(255) NULL COMMENT '',
    `attr6` varchar(255) NULL COMMENT '',
    `attr7` varchar(255) NULL COMMENT '',
    `attr8` varchar(255) NULL COMMENT '',
    KEY `username` (`username`),
    KEY `okayapi_qi_ace_base_user_password` (`okayapi_qi_ace_base_user_password`),
    KEY `okayapi_qi_ace_base_user_name` (`okayapi_qi_ace_base_user_name`),
    KEY `birthday` (`birthday`),
    KEY `address` (`address`),
    KEY `mobile_phone` (`mobile_phone`),
    KEY `tel_phone` (`tel_phone`),
    KEY `email` (`email`),
    KEY `sex` (`sex`),
    KEY `okayapi_qi_ace_base_user_type` (`okayapi_qi_ace_base_user_type`),
    KEY `okayapi_qi_ace_base_user_status` (`okayapi_qi_ace_base_user_status`),
    KEY `description` (`description`),
    KEY `crt_time` (`crt_time`),
    KEY `crt_user` (`crt_user`),
    KEY `crt_name` (`crt_name`),
    KEY `crt_host` (`crt_host`),
    KEY `upd_time` (`upd_time`),
    KEY `upd_user` (`upd_user`),
    KEY `upd_name` (`upd_name`),
    KEY `upd_host` (`upd_host`),
    KEY `attr1` (`attr1`),
    KEY `attr2` (`attr2`),
    KEY `attr3` (`attr3`),
    KEY `attr4` (`attr4`),
    KEY `attr5` (`attr5`),
    KEY `attr6` (`attr6`),
    KEY `attr7` (`attr7`),
    KEY `attr8` (`attr8`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'qi后台管理系统-用户表';

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


MySQL database table structure design

Displaying 1-28 of 28 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
usernamevarchar(255)
okayapi_qi_ace_base_user_passwordvarchar(255)
okayapi_qi_ace_base_user_namevarchar(255)
birthdayvarchar(255)
addressvarchar(255)
mobile_phonevarchar(255)
tel_phonevarchar(255)
emailvarchar(255)
sexchar(1)
okayapi_qi_ace_base_user_typechar(1)
okayapi_qi_ace_base_user_statuschar(1)
descriptionvarchar(255)
crt_timedatetime
crt_uservarchar(255)
crt_namevarchar(255)
crt_hostvarchar(255)
upd_timedatetime
upd_uservarchar(255)
upd_namevarchar(255)
upd_hostvarchar(255)
attr1varchar(255)
attr2varchar(255)
attr3varchar(255)
attr4varchar(255)
attr5varchar(255)
attr6varchar(255)
attr7varchar(255)
attr8varchar(255)

Guess You Like

MySQL Table Design okayapi_qi_ace_sys_dept_relation

MySQL Table Design okayapi_qi_ace_sys_oauth_client_details

MySQL Table Design okayapi_qi_ace_sys_role_menu

MySQL Table Design okayapi_qi_ace_base_group

MySQL Table Design okayapi_qi_ace_base_group_leader

MySQL Table Design okayapi_qi_ace_base_group_member

MySQL Table Design okayapi_qi_ace_base_group_type

MySQL Table Design okayapi_qi_ace_base_menu

MySQL Table Design okayapi_qi_ace_base_resource_authority

MySQL Table Design okayapi_qi_ace_gate_log

MySQL Table Design okayapi_qi_ace_auth_client

MySQL Table Design okayapi_qi_ace_auth_client_service

MySQL Table Design okayapi_qi_ace_sys_dict

MySQL Table Design okayapi_qi_ace_sys_dict_item

MySQL Table Design okayapi_qi_ace_sys_log

MySQL Table Design okayapi_qi_ace_sys_menu

TOP ↑