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