ss
Tables (4)
ChatRoom
- id — bigint — Primary key — NOT NULL
- name — text — NOT NULL
- description — text — NOT NULL
- normalizedId — text
- createdAt — timestamp(0) — NOT NULL
- updatedAt — timestamp(0)
- deletedAt — timestamp(0)
- lastChattedAt — timestamp(6)
- totalChatCount — bigint — NOT NULL
- totalMemberCount — integer — NOT NULL
- imageId — integer
- rank — integer
- totalSenderCount — integer — NOT NULL
ChatRoomPermission (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- chatRoomId (id) — bigint — Foreign key → ChatRoom.id — NOT NULL
- permissionId (Key2) — bigint — Foreign key → Permission.id — NOT NULL
Permission (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
- message (Field2) — varchar
UserOnChatRoomPermission
- userId (Key) — bigint — Primary key — NOT NULL
- chatRoomPermissionId (Key2) — bigint — Foreign key → ChatRoomPermission.id — NOT NULL