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)