zsxzs

Tables (10)

ChatRoomPermissionGroup (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • chatRoomId (Field) — int
  • groupId (Key2) — int — Foreign key → PermissionGroup.id — NOT NULL

Permission (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • action (Field3) — enum(JOIN_CHATROOM, UPDATE_CHATROOM...)

PermissionGroup (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar

PermissionHierarchy (Untitled10)

  • permissionId (Key) — int — Foreign key → Permission.id — NOT NULL
  • parentPermissionId (Key2) — int — Foreign key → Permission.id — NOT NULL

PermissionOnPermissionGroup (Untitled3)

  • permissionId (Key) — int — Foreign key → Permission.id — NOT NULL
  • groupId (Key2) — int — Foreign key → PermissionGroup.id — NOT NULL

PermissionOnRole (Untitled6)

  • roleId (Key2) — int — Foreign key → Role.id — NOT NULL
  • permissionId (Key) — int — Foreign key → Permission.id — NOT NULL

PermissionOnUser (Untitled8)

  • permissionId (Key) — int — Foreign key → Permission.id — NOT NULL
  • userId (Key2) — int — Foreign key → User.id — NOT NULL

Role (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar

RoleOnUser (Untitled7)

  • roleId (Key) — int — Foreign key → Role.id — NOT NULL
  • userId (Key2) — int — Foreign key → User.id — NOT NULL

User (Untitled9)

  • id (Key) — int — Primary key — NOT NULL