.| standings | ..
| standings > standing |
|---|
| id | Unique identifier for the standings | | name | Name of the standings | | sport_id | Unique identifier for the sport in which the standings |
| occurres
....group | | id | Unique identifier for group. Could be empty value
|
| name | Name of the group. Could be empty value| occurres | | sport_name | Name of the sport | | type_id | Unique identifier for the standings type. e.g. Away standings, World Cup standings, Event's final result | | type_name | Name of standings type. e.g. Standings table, Top scorers, Cards | | subtype | Name of subtype of standings. Possible values: - standings
- under_over
- form
- overall_stats
| | object_id | Unique identifier for object selected in the object_type | | object_type | Type of object (kind of scope) for which data is generated. Possible values: - sport (e.g. WTA Ranking)
- season (standings for England Premiership)
- stage (standings in second round of competitions)
| | object_name | Name of selected object e.g. European Championship (competition_season), Premier League (competition_season), FC Barcelona (team),
Relegation Round (stage), FC Barcelona - Manchester United (event) | | stage_name_id | Unique identifier for the stage's name. | | item_status | Describes status of the item (record). Possible values: - active - the record is active
- deleted - the record was deleted by the admin. When an event was added by mistake
|
|
| ut | Information about the date and time of when the record was last updated. Format UNIX_TIMESTAMP |
...groups | | reset_group_rank | Describes type of rank in groups. Possible values: - yes - (default) each possible group in standings has it's own rank and it starts from value 1
- no - all possible groups share the same rank e.g. rank in group B could start from the value higher than last value in group A.
| | competition_id | Unique identifier for the competition | | season_id | Unique identifier for the season | | stage_id | Unique identifier for the stage | | ut | Information about the date and time of when the |
| group | record was last updated. Format UNIX_TIMESTAMP |
| .....participants | ......participant |
|---|
| id | Unique identifier for participant |
| name | Name of participant |
| area_id | Area identifier for participant |
| area_name | Area name for participant |
| rank | Present position, place in standings |
| last_rank | Last position, place in standings |
| zone_name | Standings zone name |
| subparticipant_id | Participants team identifier (could be empty) |
| subparticipant_name | Participants team name (could be empty) |
| subparticipant_slug | Friendly url for the subparticipant (could be empty) |
| participant_slug | Friendly url for the participant |
......columns |
|
.......column | | id | Identifier for the columns/stats |
| name | Name of the column (title) |
| short_name | Abbreviated name of the column (title) |
| code | Attribute for internal purpose |
| value | Value of the column for a single participant |
| ....corrections | .....correction | standings > standing > groups |
|---|
| standings > standing > groups > group |
|---|
|
| standings > standing > groups > group > participants |
|---|
| standings > standing > groups > group > participants > participant |
|---|
| Include Page |
|---|
| Participant node |
|---|
| Participant node |
|---|
|
|
| standings > standing > groups > group > participants > participant > columns |
|---|
| standings > standing > groups > group > participants > participant > columns > column |
|---|
|
| standings > standing > groups > group > corrections |
|---|
| standings > standing > groups > group > corrections > correction |
|---|
| participant_id | Identifier for the participant | | participant_name | Name of the participant | | value | Correction value, e.g. "+2" | | reason | Determines the reason of corrections. Possible reasons: - Association decision
- Disqualified
- Financial issues
- Quit
- Regulations
|
|
....zones | .....
|
|---|
| standings > standing > groups > group > zones |
|---|
| standings > standing > groups > group > zones > zone |
|---|
| id | Identifier for the zone | | name | Name of the zone | | colour | The CSS colour for the zone |
|