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