hongsimi
Tables (7)
ChatMessage
- Key (chat_message_id) — Primary key — NOT NULL
- id (member_id) — Foreign key → Member.id — NOT NULL
- Key (chat_room_id) — Foreign key → ChatRoom.Key — NOT NULL
- Field (content)
ChatParticipant
- Key (chat_participant_id) — Primary key — NOT NULL
- id (member_id) — Foreign key → Member.id — NOT NULL
- Key (chat_room_id) — Foreign key → ChatRoom.Key — NOT NULL
ChatRoom
- Key (chat_room_id) — Primary key — NOT NULL
- Field (room_type) — Enum
- Field (created_at) — DateTime
- Field (couseName) — String
Course
- Key (course_id) — Primary key — NOT NULL
- Key (major_id) — Foreign key → Major.Key — NOT NULL
- Field (grade) — int
- Field (name) — String
Major
- Key (major_id) — Primary key — NOT NULL
- Field (name) — String
Member
- id (member_id) — Primary key — NOT NULL
- Key (major_id) — Foreign key → Major.Key — NOT NULL
- email — String
- password — String
- Field (name) — String
- Field (grade) — int
MessageReadStatus
- Key (readstaus_id) — Primary key — NOT NULL
- id (member_id) — Foreign key → Member.id — NOT NULL
- Key (chat_message_id) — Foreign key → ChatMessage.Key — NOT NULL
- Key (chat_room_id) — Foreign key → ChatRoom.Key — NOT NULL
- Field (isRead) — boolean