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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
username | varchar(255) | 是 | ||||
okayapi_qi_ace_base_user_password | varchar(255) | 是 | ||||
okayapi_qi_ace_base_user_name | varchar(255) | 是 | ||||
birthday | varchar(255) | 是 | ||||
address | varchar(255) | 是 | ||||
mobile_phone | varchar(255) | 是 | ||||
tel_phone | varchar(255) | 是 | ||||
varchar(255) | 是 | |||||
sex | char(1) | 是 | ||||
okayapi_qi_ace_base_user_type | char(1) | 是 | ||||
okayapi_qi_ace_base_user_status | char(1) | 是 | ||||
description | varchar(255) | 是 | ||||
crt_time | datetime | 是 | ||||
crt_user | varchar(255) | 是 | ||||
crt_name | varchar(255) | 是 | ||||
crt_host | varchar(255) | 是 | ||||
upd_time | datetime | 是 | ||||
upd_user | varchar(255) | 是 | ||||
upd_name | varchar(255) | 是 | ||||
upd_host | varchar(255) | 是 | ||||
attr1 | varchar(255) | 是 | ||||
attr2 | varchar(255) | 是 | ||||
attr3 | varchar(255) | 是 | ||||
attr4 | varchar(255) | 是 | ||||
attr5 | varchar(255) | 是 | ||||
attr6 | varchar(255) | 是 | ||||
attr7 | varchar(255) | 是 | ||||
attr8 | varchar(255) | 是 |