| id | Unique identifier for the standings |
| name | Name of the standings |
| sport_id | Unique identifier for the sport in which the standings 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
|
| 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 record was last updated. Format UNIX_TIMESTAMP |