Martin Schmidt

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

90

Potential ability

120

Home reputation

90

Current reputation

90

World reputation

20

International appearances

—

Coaching qualification

0

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

6

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 4 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.

Career spells from staff_history, in the order the export wrote them.

Club	Role	From	To	Status
FC Raron	Assistant Manager	2001-07-01	2003-06-30	Ended
FC Raron	Manager	2003-07-01	2008-06-30	Ended
1.FSV Mainz 05 II	Manager	2010-07-01	—	Current
FC Thun Berner Oberland U21	Manager	2008-07-01	2010-06-30	Ended

National-team spells

No national-team spells are recorded in person_nation_contract for this person.

Club contract

Club

1.FSV Mainz 05 II

Team

1.FSV Mainz 05 II

Joined

2010-07-01

Expires

2012-06-30

Weekly wage

—

Languages

Languages from person_language.

Language	First language	Proficiency
German	Yes	1
French	No	2
Italian	No	2
English	No	3

Relations and preferences

No relations or preferences are recorded for this person.