+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_cmdb_mgmt_user_passwordvarchar(128)
last_logindatetime(6)
is_superusertinyint(1)
usernamevarchar(150)Unique Index
first_namevarchar(30)
last_namevarchar(30)
emailvarchar(254)
is_stafftinyint(1)
is_activetinyint(1)
date_joineddatetime(6)
okayapi_cmdb_mgmt_user_namevarchar(10)
positionvarchar(20)

Guess You Like

MySQL Table Design okayapi_cmdb_auth_group

MySQL Table Design okayapi_cmdb_auth_group_permissions

MySQL Table Design okayapi_cmdb_auth_permission

MySQL Table Design okayapi_cmdb_c_test_person

MySQL Table Design okayapi_cmdb_django_admin_log

MySQL Table Design okayapi_cmdb_django_content_type

MySQL Table Design okayapi_cmdb_django_migrations

MySQL Table Design okayapi_cmdb_django_session

MySQL Table Design okayapi_cmdb_mgmt_department

MySQL Table Design okayapi_cmdb_mgmt_department_permissions

MySQL Table Design okayapi_cmdb_mgmt_field

MySQL Table Design okayapi_cmdb_mgmt_permission

MySQL Table Design okayapi_cmdb_mgmt_restpwverifycode

MySQL Table Design okayapi_cmdb_mgmt_table

MySQL Table Design okayapi_cmdb_mgmt_user_departments

MySQL Table Design okayapi_cmdb_mgmt_user_groups

MySQL Table Design okayapi_cmdb_mgmt_user_permissions

MySQL Table Design okayapi_cmdb_mgmt_user_user_permissions

TOP ↑