MySQL Create Table SQL
Table Structure: okayapi_cmdb_mgmt_user:/tablelist/okayapi_cmdb_mgmt_user.html
-- MySQL Table okayapi_cmdb_mgmt_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_cmdb_mgmt_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_cmdb_mgmt_user_password` varchar(128) NOT NULL COMMENT '',
`last_login` datetime(6) NOT NULL COMMENT '',
`is_superuser` tinyint(1) NOT NULL COMMENT '',
`username` varchar(150) NOT NULL COMMENT '',
`first_name` varchar(30) NOT NULL COMMENT '',
`last_name` varchar(30) NOT NULL COMMENT '',
`email` varchar(254) NOT NULL COMMENT '',
`is_staff` tinyint(1) NOT NULL COMMENT '',
`is_active` tinyint(1) NOT NULL COMMENT '',
`date_joined` datetime(6) NOT NULL COMMENT '',
`okayapi_cmdb_mgmt_user_name` varchar(10) NOT NULL COMMENT '',
`position` varchar(20) NOT NULL COMMENT '',
KEY `okayapi_cmdb_mgmt_user_password` (`okayapi_cmdb_mgmt_user_password`),
KEY `last_login` (`last_login`),
KEY `is_superuser` (`is_superuser`),
KEY `username` (`username`),
KEY `first_name` (`first_name`),
KEY `last_name` (`last_name`),
KEY `email` (`email`),
KEY `is_staff` (`is_staff`),
KEY `is_active` (`is_active`),
KEY `date_joined` (`date_joined`),
KEY `okayapi_cmdb_mgmt_user_name` (`okayapi_cmdb_mgmt_user_name`),
KEY `position` (`position`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CMDB管理-用户';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_cmdb_mgmt_user_password | varchar(128) | 否 | ||||
last_login | datetime(6) | 是 | ||||
is_superuser | tinyint(1) | 否 | ||||
username | varchar(150) | 否 | Unique Index | |||
first_name | varchar(30) | 否 | ||||
last_name | varchar(30) | 否 | ||||
varchar(254) | 否 | |||||
is_staff | tinyint(1) | 否 | ||||
is_active | tinyint(1) | 否 | ||||
date_joined | datetime(6) | 否 | ||||
okayapi_cmdb_mgmt_user_name | varchar(10) | 否 | ||||
position | varchar(20) | 否 |