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