Match_Tracker_ERD

Tables (5)

Favorite

  • Favorite ID (favorite_id) — SERIAL — Primary key — NOT NULL
  • User ID (user_id) — SERIAL — Foreign key → User.User ID — NOT NULL
  • Team ID (team_id) — SERIAL — Foreign key → Team.Team ID — NOT NULL

Match

  • Match ID (match_id) — SERIAL — Primary key — NOT NULL
  • Match Date (match_date) — TIMESTAMP — NOT NULL
  • Home Team Score (home_team_score) — INT
  • Away Team Score (away_team_score) — INT
  • Sport ID (sport_id) — SERIAL — Foreign key → Sport.Sport ID — NOT NULL
  • Home Team ID (home_team_id) — SERIAL — Foreign key → Team.Team ID — NOT NULL
  • Away Team ID (away_team_id) — SERIAL — Foreign key → Team.Team ID — NOT NULL

Sport

  • Sport ID (sport_id) — SERIAL — Primary key — NOT NULL
  • Sport Name (sport_name) — VARCHAR(15) UNIQUE — NOT NULL

Team

  • Team ID (team_id) — SERIAL — Primary key — NOT NULL
  • Team Name (team_name) — VARCHAR(30) — NOT NULL
  • Hometown (hometown) — VARCHAR(30) — NOT NULL
  • Sport ID (sport_id) — SERIAL — Foreign key → Sport.Sport ID — NOT NULL

User

  • User ID (user_id) — SERIAL — Primary key — NOT NULL
  • Username (username) — VARCHAR(20) UNIQUE — NOT NULL
  • Password (password) — VARCHAR(20) — NOT NULL
  • Age (age) — INT — NOT NULL
  • Role (role) — VARCHAR(20) — NOT NULL