Football Pro Simulator ERD
Tables (11)
ClubFacilities
- facility_id — SERIAL — Primary key
- club_id — SERIAL — Foreign key → Clubs.club_id
- training_ground_quality — NUMERIC(5,2)
- youth_facility_quality — NUMERIC(5,2)
- stadium_facility_quality — NUMERIC(5,2)
Clubs
- club_id — SERIAL — Primary key
- name — VARCHAR(100) — NOT NULL
- short_name — VARCHAR(50)
- league_id — INTEGER — NOT NULL
- stadium_id — INTEGER
- founded_year — INTEGER
- reputation — NUMERIC(5,2)
- budget — BIGINT
- home_color — VARCHAR(20)
- away_color — VARCHAR(20)
- logo_path — VARCHAR(255)
Injuries
- injury_id — SERIAL — Primary key
- player_id — INTEGER — NOT NULL
- injury_type — VARCHAR(100)
- start_date — DATE — NOT NULL
- expected_recovery_date — DATE
- actual_recovery_date — DATE
- severity — VARCHAR(50)
Leagues
- league_id — SERIAL — Primary key
- name — VARCHAR(100) — NOT NULL
- country — VARCHAR(100)
- level — INTEGER
- number_of_clubs — INTEGER
- promotion_rules — TEXT
- relegation_rules — TEXT
- season_start_date — DATE
- season_end_date — DATE
Matches
- match_id — SERIAL — Primary key
- league_id — INTEGER — NOT NULL
- season — VARCHAR(20)
- match_day — INTEGER
- match_date — DATE — NOT NULL
- home_club_id — INTEGER — NOT NULL
- away_club_id — INTEGER — NOT NULL
- stadium_id — INTEGER
- home_score — INTEGER
- away_score — INTEGER
- attendance — INTEGER
- referee — VARCHAR(100)
PlayerAttributes
- player_attr_id — SERIAL — Primary key
- player_id (player_id2) — SERIAL — Foreign key → Players.player_id
- player_id — INTEGER — NOT NULL
- season — VARCHAR(20)
- date_recorded — DATE
- pace — NUMERIC(5,2)
- shooting — NUMERIC(5,2)
- passing — NUMERIC(5,2)
- dribbling — NUMERIC(5,2)
- defending — NUMERIC(5,2)
- physicality — NUMERIC(5,2)
- mentality — NUMERIC(5,2)
- vision — NUMERIC(5,2)
- stamina — NUMERIC(5,2)
- composure — NUMERIC(5,2)
PlayerMatchStats
- pms_id — SERIAL — Primary key
- player_id — INTEGER — NOT NULL
- match_id — INTEGER — NOT NULL
- minutes_played — INTEGER
- goals — INTEGER
- assists — INTEGER
- yellow_cards — INTEGER
- red_cards — INTEGER
- shots — INTEGER
- passes_completed — INTEGER
- tackles — INTEGER
- dribbles — INTEGER
Players
- player_id — SERIAL — Primary key
- name — VARCHAR(150) — NOT NULL
- date_of_birth — DATE
- nationality — VARCHAR(100)
- height_cm — NUMERIC(5,2)
- weight_kg — NUMERIC(5,2)
- preferred_foot — VARCHAR(10)
- positions — VARCHAR(100)
- current_club_id — INTEGER
- contract_start_date — DATE
- contract_end_date — DATE
- wage — BIGINT
- potential_ability — NUMERIC(5,2)
- current_ability — NUMERIC(5,2)
Stadiums
- stadium_id — SERIAL — Primary key
- name — VARCHAR(100) — NOT NULL
- capacity — INTEGER
- location — VARCHAR(100)
- pitch_condition_rating — NUMERIC(3,2)
- pitch_size_length — NUMERIC(5,2)
- pitch_size_width — NUMERIC(5,2)
Staff
- staff_id — SERIAL — Primary key
- name — VARCHAR(150) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- nationality — VARCHAR(100)
- date_of_birth — DATE
- current_club_id — INTEGER
- attribute_coaching — NUMERIC(5,2)
- attribute_scouting — NUMERIC(5,2)
- attribute_fitness — NUMERIC(5,2)
Transfers
- transfer_id — SERIAL — Primary key
- player_id — INTEGER — NOT NULL
- from_club_id — INTEGER
- to_club_id — INTEGER
- transfer_date — DATE — NOT NULL
- fee — BIGINT
- is_loan — BOOLEAN
- loan_end_date — DATE