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