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