chongqing-server/sql/sys_dept.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80045
 Source Host           : localhost:3306
 Source Schema         : chongqing-test

 Target Server Type    : MySQL
 Target Server Version : 80045
 File Encoding         : 65001

 Date: 24/04/2026 15:37:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`  (
  `dept_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `parent_id` bigint(0) NULL DEFAULT 0 COMMENT '父部门id',
  `ancestors` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
  `order_num` int(0) NULL DEFAULT 0 COMMENT '显示顺序',
  `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `dept_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'STATION' COMMENT '部门类型',
  `dept_type_desc` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '机构站' COMMENT '部门类型名称',
  PRIMARY KEY (`dept_id`) USING BTREE,
  INDEX `idx_sys_dept_parent_id`(`parent_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 131 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES (100, 0, '0', '安检站', 1, '', '', '', '0', '0', 'admin', '2025-07-07 16:07:22', 'admin', '2025-11-28 16:00:40', 'STATION', '机构站');
INSERT INTO `sys_dept` VALUES (101, 100, '0,100', '旅检一部', 0, NULL, NULL, NULL, '0', '0', 'admin', '2026-04-22 12:34:06', '', NULL, 'BRIGADE', '机构站');
INSERT INTO `sys_dept` VALUES (102, 100, '0,100', '旅检二部', 1, NULL, NULL, NULL, '0', '0', 'admin', '2026-04-22 12:34:31', 'admin', '2026-04-22 12:34:39', 'BRIGADE', '机构站');
INSERT INTO `sys_dept` VALUES (103, 100, '0,100', '旅检三部', 2, NULL, NULL, NULL, '0', '0', 'admin', '2026-04-22 12:34:55', '', NULL, 'BRIGADE', '机构站');
INSERT INTO `sys_dept` VALUES (104, 103, '0,100,103', '安平班组', 0, '项锐', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:35:56', 'admin', '2026-04-22 12:49:15', 'MANAGER', '机构站');
INSERT INTO `sys_dept` VALUES (105, 103, '0,100,103', '屹动班组', 1, '李健', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:36:57', 'admin', '2026-04-22 12:48:49', 'MANAGER', '机构站');
INSERT INTO `sys_dept` VALUES (106, 103, '0,100,103', '芮盾班组', 2, '刘怡春', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:37:25', 'admin', '2026-04-22 12:37:33', 'MANAGER', '机构站');
INSERT INTO `sys_dept` VALUES (107, 103, '0,100,103', '拓新班组', 3, '杨小瑜', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:38:01', '', NULL, 'MANAGER', '机构站');
INSERT INTO `sys_dept` VALUES (108, 103, '0,100,103', '安行班组', 4, '赵金鹏', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:41:57', 'admin', '2026-04-22 12:54:23', 'MANAGER', '机构站');
INSERT INTO `sys_dept` VALUES (109, 103, '0,100,103', '木兰班组', 5, '陈殷红', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:42:27', '', NULL, 'MANAGER', '机构站');
INSERT INTO `sys_dept` VALUES (110, 104, '0,100,103,104', '陈行小组', 0, '陈行', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:43:12', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (111, 104, '0,100,103,104', '杨龙小组', 1, '杨龙', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:43:32', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (112, 104, '0,100,103,104', '王岚玉小组', 2, '王岚玉', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:49:55', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (113, 105, '0,100,103,105', '凌静小组', 0, '凌静', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:50:34', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (114, 105, '0,100,103,105', '张长圣小组', 1, '张长圣', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:50:54', 'admin', '2026-04-22 12:51:22', 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (115, 105, '0,100,103,105', '代航小组', 2, '代航', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:51:15', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (116, 106, '0,100,103,106', '卢兴旭小组', 0, '卢兴旭', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:51:41', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (117, 106, '0,100,103,106', '张露小组', 1, '张露', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:52:06', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (118, 106, '0,100,103,106', '刘婷婷小组', 2, '刘婷婷', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:52:25', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (119, 107, '0,100,103,107', '贾剑雄小组', 0, '贾剑雄', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:52:53', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (120, 107, '0,100,103,107', '聂倩小组', 1, '聂倩', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:53:08', 'admin', '2026-04-22 12:53:38', 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (121, 107, '0,100,103,107', '肖灿小组', 2, '肖灿', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:53:32', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (122, 108, '0,100,103,108', '周游波小组', 0, '周游波', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:54:12', 'admin', '2026-04-22 12:54:36', 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (123, 108, '0,100,103,108', '刘欢欢小组', 1, '刘欢欢', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:54:54', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (124, 108, '0,100,103,108', '史飞小组', 2, '史飞', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:55:17', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (125, 109, '0,100,103,109', '赵俊秀小组', 0, '赵俊秀', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:55:39', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (126, 109, '0,100,103,109', '李学伟小组', 1, '李学伟', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:55:59', 'admin', '2026-04-22 15:26:01', 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (127, 109, '0,100,103,109', '罗园园小组', 2, '罗园园', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:56:25', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (128, 109, '0,100,103,109', '尹一澄小组', 3, '尹一澄', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:56:43', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (129, 109, '0,100,103,109', '李川小组', 4, '李川', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:57:00', '', NULL, 'TEAMS', '机构站');
INSERT INTO `sys_dept` VALUES (130, 109, '0,100,103,109', '罗方程雪小组', 5, '罗方程雪', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:57:20', '', NULL, 'TEAMS', '机构站');

SET FOREIGN_KEY_CHECKS = 1;