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