okayapi_72crm_admin_dept - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_72crm_admin_dept：/tablelist/okayapi_72crm_admin_dept.html


-- MySQL Table okayapi_72crm_admin_dept
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_admin_dept` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `dept_id` int(11) NULL COMMENT '',
    `pid` int(11) NULL DEFAULT '0' COMMENT '父级ID 顶级部门为0',
    `okayapi_72crm_admin_dept_name` varchar(64) NULL COMMENT '部门名称',
    `num` int(4) NULL COMMENT '排序 越大越靠后',
    `remark` varchar(64) NULL COMMENT '部门备注',
    KEY `dept_id` (`dept_id`),
    KEY `pid` (`pid`),
    KEY `okayapi_72crm_admin_dept_name` (`okayapi_72crm_admin_dept_name`),
    KEY `num` (`num`),
    KEY `remark` (`remark`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-部门表';

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

MySQL database table structure design

Displaying 1-5 of 5 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
dept_id	int(11)		否
pid	int(11)	0	是	父级ID 顶级部门为0	0
okayapi_72crm_admin_dept_name	varchar(64)		否	部门名称
num	int(4)		是	排序越大越靠后
remark	varchar(64)		是	部门备注