MatchMate
Tables (5)
MATCHES
- match_id — INT — Primary key — NOT NULL
- creator_id — INT — Foreign key → USERS.user_id — NOT NULL
- match_date — DATETIME — NOT NULL
- location — VARCHAR(100) — NOT NULL
- max_players — INT — NOT NULL
- current_players — INT
- status — VARCHAR(20)
MATCH_PARTICIPANTS
- participant_id — INT — Primary key — NOT NULL
- match_id — INT — Foreign key → MATCHES.match_id — NOT NULL
- user_id — INT — Foreign key → USERS.user_id — NOT NULL
- team — VARCHAR(10)
MATCH_RESULTS
- result_id — INT — Primary key — NOT NULL
- match_id — INT — Foreign key → MATCHES.match_id — NOT NULL
- home_score — INT — NOT NULL
- away_score — INT — NOT NULL
- mvp_user_id — INT — Foreign key → USERS.user_id
REVIEWS
- review_id — INT — Primary key — NOT NULL
- match_id — INT — Foreign key → MATCHES.match_id — NOT NULL
- reviewer_id — INT — Foreign key → USERS.user_id — NOT NULL
- reviewee_id — INT — Foreign key → USERS.user_id — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT — EX
USERS
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- soccer_level — VARCHAR(20) — NOT NULL
- total_wins — INT
- total_draws — INT
- total_losses — INT
- mvp_count — INT