1
Tables (5)
Chat
- chat_id — INT — Primary key — NOT NULL
- matching_id — INT — Foreign key → Matching.matching_id — NOT NULL
- sender_id — INT — Foreign key → User.user_id — NOT NULL
- message — TEXT
- sent_at — DATETIME
Game_Profile
- profile_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- game_name — VARCHAR(50)
- rank_level — VARCHAR(30)
- position — VARCHAR(30)
- play_time — VARCHAR(50)
- mic_use — BOOLEAN
Matching
- matching_id — INT — Primary key — NOT NULL
- sender_id — INT — Foreign key → User.user_id — NOT NULL
- receiver_id — INT — Foreign key → User.user_id — NOT NULL
- status — VARCHAR(20)
- created_at — DATETIME
Review
- review_id — INT — Primary key — NOT NULL
- reviewer_id — INT — Foreign key → User.user_id — NOT NULL
- target_id — INT — Foreign key → User.user_id — NOT NULL
- rating — INT
- content — TEXT
- created_at — DATETIME
User
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(50)
- email — VARCHAR(100)
- password — VARCHAR(100)
- nickname — VARCHAR(50)
- created_at — DATETIME