Derek McInnes
Staff record
staff is the non-playing subtype of person: people this export decoded as staff
rather than as players. It is only one of the three places a career can live. Plenty of well-known managers
have no staff row at all — some are stored as players, and many sit in
person_unclassified, whose subtype the decoder could not determine. Whichever table a person
is in, their jobs come from staff_history joined to job_type, which is the table
below.
- Current ability
- 127
- Potential ability
- 140
- Home reputation
- 119
- Current reputation
- 125
- World reputation
- —
- International appearances
- 2
- Coaching qualification
- 1
Ability and the three reputations are the raw game figures, which run to roughly 200 rather than to 20 —
they are printed exactly as stored and nothing is converted. coaching_qualification is a badge
level with no lookup table in the export, so it is shown as the stored number and no name is invented for it.
Appearance
- Ethnicity code
- 1
- Hair colour code
- 3
- Skin tone code
- 2
Raw codes from the source. The export carries no lookup table for any of them, so they are shown as stored and are not given names.
Non-playing ability
This version's export has no staff_ability row for this person.
Coaching
This version's export has no staff_coaching row for this person.
Tactical style
This version's export has no staff_tactical_style row for this person.
Career spells
Marked current: 1 of 3 spells. A spell counts as current when
date_left is empty or falls in the future — the source records plenty of long-finished
spells with no end date, so more than one spell can carry the mark.
| Club | Role | From | To | Status |
|---|---|---|---|---|
| St. Johnstone | Manager | 2007-11-26 | 2011-10-15 | Ended |
| Bristol City | Manager | 2011-10-15 | 2013-01-12 | Ended |
| Aberdeen | Manager | 2013-04-06 | — | Current |
National-team spells
No national-team spells are recorded in person_nation_contract for this person.
Club contract
Languages
| Language | First language | Proficiency |
|---|---|---|
| English | Yes | 1 |
Relations and preferences
No relations or preferences are recorded for this person.
Personal information
Personality
Personality is stored on the same 1–20 scale as the attributes, and is shown exactly as recorded. A dash is a value the export did not record, which is not a zero.