exmaple

Tables (4)

Chat_Room

  • chat_id — BIGINT
  • mentor_id — BIGINT — Foreign key → Mentor.mentor_id
  • mentee_id — BIGINT — Foreign key → Mentee.mentee_id

Mentee

  • mentee_id — BIGINT
  • mentee_name — VARCHAR(255) — NOT NULL

Mentor

  • mentor_id — BIGINT
  • mentor_name — VARCHAR(255) — NOT NULL

Message

  • message_id — BIGINT
  • chat_id — BIGINT — Foreign key → Chat_Room.chat_id — NOT NULL
  • sender_id — BIGINT — Foreign key → Mentor.mentor_id — NOT NULL
  • receiver_id — BIGINT — Foreign key → Mentee.mentee_id — NOT NULL
  • message_content — TEXT
  • sent_at — TIMESTAMP
  • is_checked — TINYINT(1)