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