PL Match

Tables (3)

MATCH (Untitled)

  • MATCH_ID (Key) — INT — Primary key — NOT NULL
  • DATE (Field) — DATE
  • OPPONENT (Field2) — STRING
  • LOCATION (Field3) — STRING
  • ROUND (Field4) — INT
  • IS_HOME (Field5) — BOOLEAN
  • HOME_SCORE (Field6) — INT
  • AWAY_SCORE (Field7) — INT

PLAYER (Untitled2)

  • PLAYER_ID (Key) — INT — Primary key — NOT NULL
  • NAME (Field) — STRING
  • DATE_OF_BIRTH (Field2) — DATE
  • NATIONALITY (Field3) — STRING
  • HEIGHT (Field4) — INT
  • WEIGHT (Field5) — INT
  • BACK_NUMBER (Field6) — INT

RATING (Untitled3)

  • RATING_ID (Key) — INT — Primary key — NOT NULL
  • PLAYER_ID (Key2) — INT — Foreign key → PLAYER.PLAYER_ID — NOT NULL
  • MATCH_ID (Key3) — INT — Foreign key → MATCH.MATCH_ID — NOT NULL
  • POSITION (Field) — STRING
  • MINUTES_PLAYED (Field2) — INT
  • RATING (Field3) — DOUBLE