Strona główna Odkrywaj Pomoc
Zaloguj się
chongqing
/
chongqing-server
Obserwuj 2
Polub 0
Forkuj 0
Files Problemy 0 Oczekujące zmiany 0 Wiki
Drzewo: b11523984f
Gałęzie Tagi
chongqing-se...
/
sql
/
sys_dept.sql

sys_dept.sql 8.0 KB
Historia Czysty

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : localhost_3306
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80045
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : chongqing-test
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80045
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 24/04/2026 15:37:53
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for sys_dept
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `sys_dept`;
    24. 

  24. CREATE TABLE `sys_dept`  (
    25. 

  25.   `dept_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '部门id',
    26. 

  26.   `parent_id` bigint(0) NULL DEFAULT 0 COMMENT '父部门id',
    27. 

  27.   `ancestors` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '祖级列表',
    28. 

  28.   `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称',
    29. 

  29.   `order_num` int(0) NULL DEFAULT 0 COMMENT '显示顺序',
    30. 

  30.   `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人',
    31. 

  31.   `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
    32. 

  32.   `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
    33. 

  33.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
    34. 

  34.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    35. 

  35.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    36. 

  36.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    37. 

  37.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    38. 

  38.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    39. 

  39.   `dept_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'STATION' COMMENT '部门类型',
    40. 

  40.   `dept_type_desc` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '机构站' COMMENT '部门类型名称',
    41. 

  41.   PRIMARY KEY (`dept_id`) USING BTREE,
    42. 

  42.   INDEX `idx_sys_dept_parent_id`(`parent_id`) USING BTREE
    43. 

  43. ) ENGINE = InnoDB AUTO_INCREMENT = 131 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;
    44. 

  44. 

  45. -- ----------------------------
    46. 

  46. -- Records of sys_dept
    47. 

  47. -- ----------------------------
    48. 

  48. 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', '机构站');
    49. 

  49. INSERT INTO `sys_dept` VALUES (101, 100, '0,100', '旅检一部', 0, NULL, NULL, NULL, '0', '0', 'admin', '2026-04-22 12:34:06', '', NULL, 'BRIGADE', '机构站');
    50. 

  50. 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', '机构站');
    51. 

  51. INSERT INTO `sys_dept` VALUES (103, 100, '0,100', '旅检三部', 2, NULL, NULL, NULL, '0', '0', 'admin', '2026-04-22 12:34:55', '', NULL, 'BRIGADE', '机构站');
    52. 

  52. 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', '机构站');
    53. 

  53. 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', '机构站');
    54. 

  54. 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', '机构站');
    55. 

  55. INSERT INTO `sys_dept` VALUES (107, 103, '0,100,103', '拓新班组', 3, '杨小瑜', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:38:01', '', NULL, 'MANAGER', '机构站');
    56. 

  56. 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', '机构站');
    57. 

  57. INSERT INTO `sys_dept` VALUES (109, 103, '0,100,103', '木兰班组', 5, '陈殷红', NULL, NULL, '0', '0', 'admin', '2026-04-22 12:42:27', '', NULL, 'MANAGER', '机构站');
    58. 

  58. 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', '机构站');
    59. 

  59. 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', '机构站');
    60. 

  60. 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', '机构站');
    61. 

  61. 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', '机构站');
    62. 

  62. 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', '机构站');
    63. 

  63. 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', '机构站');
    64. 

  64. 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', '机构站');
    65. 

  65. 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', '机构站');
    66. 

  66. 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', '机构站');
    67. 

  67. 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', '机构站');
    68. 

  68. 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', '机构站');
    69. 

  69. 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', '机构站');
    70. 

  70. 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', '机构站');
    71. 

  71. 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', '机构站');
    72. 

  72. 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', '机构站');
    73. 

  73. 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', '机构站');
    74. 

  74. 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', '机构站');
    75. 

  75. 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', '机构站');
    76. 

  76. 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', '机构站');
    77. 

  77. 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', '机构站');
    78. 

  78. 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', '机构站');
    79. 

  79. 

  80. SET FOREIGN_KEY_CHECKS = 1;
    81. 

  81.