okayapi_ry_sys_dept

-- MySQL Table okayapi_ry_sys_dept
-- From: OkayAPI.com
CREATE TABLE `okayapi_ry_sys_dept` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `dept_id` bigint(20) NULL COMMENT '部门id',
    `parent_id` bigint(20) NULL DEFAULT '0' COMMENT '父部门id',
    `ancestors` varchar(50) NULL COMMENT '祖级列表',
    `dept_name` varchar(30) NULL COMMENT '部门名称',
    `order_num` int(4) NULL DEFAULT '0' COMMENT '显示顺序',
    `leader` varchar(20) NULL COMMENT '负责人',
    `phone` varchar(11) NULL COMMENT '联系电话',
    `email` varchar(50) NULL COMMENT '邮箱',
    `okayapi_ry_sys_dept_status` char(1) NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
    `del_flag` char(1) NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    `create_by` varchar(64) NULL COMMENT '创建者',
    `create_time` datetime NULL COMMENT '创建时间',
    `update_by` varchar(64) NULL COMMENT '更新者',
    KEY `dept_id` (`dept_id`),
    KEY `parent_id` (`parent_id`),
    KEY `ancestors` (`ancestors`),
    KEY `dept_name` (`dept_name`),
    KEY `order_num` (`order_num`),
    KEY `leader` (`leader`),
    KEY `phone` (`phone`),
    KEY `email` (`email`),
    KEY `okayapi_ry_sys_dept_status` (`okayapi_ry_sys_dept_status`),
    KEY `del_flag` (`del_flag`),
    KEY `create_by` (`create_by`),
    KEY `create_time` (`create_time`),
    KEY `update_by` (`update_by`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'RuoYi后台管理系统-部门表';

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