socketprac

Tables (4)

ChatMessage

  • id (PK) — Long — Primary key — NOT NULL
  • user_id (PK2) — User — Foreign key → User.id
  • chatroom_id (PK3) — ChatRoom — Foreign key → ChatRoom.id — NOT NULL
  • type (Field) — MessageType
  • message (Field2) — String

ChatRoom

  • id (PK) — Long — Primary key — NOT NULL
  • chatRoomName (Field) — String
  • category (Field2) — Set<String>

User

  • id (PK) — Long — Primary key
  • email (Field) — String
  • password (Field2) — String
  • nickname (Field3) — String
  • profileUrl (Field4) — String

UserChatRoom

  • id (PK) — Long — Primary key — NOT NULL
  • user_id (PK2) — User — Foreign key → User.id
  • chatroom_id (PK3) — ChatRoom — Foreign key → ChatRoom.id — NOT NULL