4sys_tenant_rel.sql 1.3 KB

123456789101112131415161718192021222324252627282930313233343536
  1. USE hnqzx;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for sys_ent_rel
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `sys_ent_rel`;
  8. CREATE TABLE `sys_ent_rel`
  9. (
  10. `rel_id` INT(20) AUTO_INCREMENT COMMENT 'id',
  11. `ent_id` INT(20) NOT NULL COMMENT '企业id',
  12. `e_type` VARCHAR(8) NOT NULL COMMENT '租户类型',
  13. `pro_line` VARCHAR(8) NOT NULL COMMENT '产品线',
  14. `e_level` VARCHAR(8) NOT NULL COMMENT '租户层级',
  15. `parent_id` INT(20) NOT NULL COMMENT '父级id',
  16. `root_id` INT(20) NOT NULL COMMENT '顶层id',
  17. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  18. `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  19. PRIMARY KEY `pk_id` (`rel_id`) USING BTREE,
  20. INDEX `idx_type` (`e_type`) USING BTREE,
  21. INDEX `idx_pro_line` (`pro_line`) USING BTREE,
  22. INDEX `idx_pid` (`parent_id`) USING BTREE,
  23. INDEX `idx_level` (`e_level`) USING BTREE,
  24. INDEX `idx_rid` (`root_id`) USING BTREE
  25. ) ENGINE = InnoDB
  26. DEFAULT CHARSET = utf8mb4 COMMENT ='企业层级关系表';
  27. -- ----------------------------
  28. -- Records of sys_tenant_rel
  29. -- ----------------------------
  30. BEGIN;
  31. COMMIT;
  32. SET FOREIGN_KEY_CHECKS = 1;