okayapi_cmdb_mgmt_department - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_cmdb_mgmt_department：/tablelist/okayapi_cmdb_mgmt_department.html


-- MySQL Table okayapi_cmdb_mgmt_department
-- From: OkayAPI.com
CREATE TABLE `okayapi_cmdb_mgmt_department` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_cmdb_mgmt_department_name` varchar(20) NULL COMMENT '',
    `okayapi_cmdb_mgmt_department_level` smallint(6) NULL COMMENT '',
    `create_time` datetime(6) NULL COMMENT '',
    `parent_id` int(11) NULL COMMENT '',
    KEY `okayapi_cmdb_mgmt_department_name` (`okayapi_cmdb_mgmt_department_name`),
    KEY `okayapi_cmdb_mgmt_department_level` (`okayapi_cmdb_mgmt_department_level`),
    KEY `create_time` (`create_time`),
    KEY `parent_id` (`parent_id`),
    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-4 of 4 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
okayapi_cmdb_mgmt_department_name	varchar(20)		否
okayapi_cmdb_mgmt_department_level	smallint(6)		否
create_time	datetime(6)		否
parent_id	int(11)		是

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_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

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