MT
Tables (7)
Chat
- chat_id — INT
- match_id — INT — NOT NULL
- message — TEXT
- sent_at — DATETIME
- sender_id — INT
- receiver_id — INT
MenteeProfile
- mentee_id — INT
- user_id — INT — NOT NULL
- personality — VARCHAR(200)
- learning_style — VARCHAR(200)
- major — VARCHAR(200)
- goal — VARCHAR(200)
MentorProfile
- mentor_id — INT
- user_id — INT — NOT NULL
- personality — VARCHAR(200)
- learning_style — VARCHAR(200)
- major — VARCHAR(200)
- goal — VARCHAR(200)
- introduction — TEXT
- available_time — VARCHAR(200)
MentoringMatch
- match_id — INT
- mentor_id — INT — NOT NULL
- mentee_id — INT — NOT NULL
- request_channel — VARCHAR(20)
- match_status — VARCHAR(20)
- ai_score — INT
- matched_date — DATE
Review
- review_id — INT
- match_id — INT — NOT NULL
- content — TEXT
- created_at — DATETIME
- rating — INT
Schedule
- schedule_id — INT
- match_id — INT — NOT NULL
- schedule_date — DATE
- location — VARCHAR(200)
User
- Key — Primary key — NOT NULL
- user_id — INT
- user_type — VARCHAR(20)
- name — VARCHAR(50)
- email — VARCHAR(100)
- password — VARCHAR(100)
- phone — VARCHAR(20)
- Field