Ding Qi

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

—

Potential ability

-3

Home reputation

0

Current reputation

0

World reputation

1

International appearances

0

Coaching qualification

8

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

10

Hair colour code

0

Hair length 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

A staff_ability row exists, but none of its 26 values are recorded.

Coaching

A staff_coaching row exists, but none of its 6 values are recorded.

Tactical style

A staff_tactical_style row exists, but none of its 17 values are recorded.

Career spells

Marked current: 4 of 11 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
Dalian Wanda	Player	1999-01-01	2000-01-01	Ended
Dalian Shide	Player	2000-01-01	2002-01-01	Ended
Chengdu Tiancheng	Player	2002-01-01	—	Current
Sichuan FC	Player	2009-08-01	—	Current
Sichuan Dujiangyan	Player	2011-03-01	2011-12-31	Ended
Sichuan Dujiangyan	Player / Coach	2011-03-01	2011-12-31	Ended
Dalian Longjuanfeng	Player	2012-03-01	2012-12-31	Ended
Shenyang Weishi	Player	2012-12-31	2016-01-01	Ended
Manzhouli Biancheng Xuelang	Player	2016-01-01	—	Current
Shaoxing Shangyu Pterosaur	Manager	2021-01-01	2021-12-31	Ended
Shaoxing Shangyu Pterosaur	Coach	2021-01-01	—	Current

National-team spells

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

Club contract

Club

Shaoxing Shangyu Pterosaur

Team

Team 2000136384

Joined

2021-01-01

Contract start

2021-01-01

Expires

—

Weekly wage

£0

Squad numbers

Squad numbers from club_squad_number, keyed on team_uid.

Team	Number
Team 2000136384	—

Languages

Languages from person_language.

Language	First language	Proficiency
Chinese	Yes	—

Relations and preferences

No relations or preferences are recorded for this person.