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