...
.participant | |||||||
|---|---|---|---|---|---|---|---|
| id | Unique identifier for participant | ||||||
| type | Participant type. Could be:
| ||||||
| name | Participant name | ||||||
| short_name | Participant short name, max length: 20 charactes | ||||||
| acronym | Max 3 characters length mini name | ||||||
| gender | Participant gender | ||||||
| area_id | Unique identifier of participant area | ||||||
| area_name | Participant area name | ||||||
| sport_id | Unique identifier of sport in which participant occures | ||||||
| area_code | Max 3 characters length area name | ||||||
| national | Determines if participant is national team | ||||||
| website | Participant official website. | ||||||
| ut | Information about date and time when record was last updated. Format YYYY-MM-DD HH:MM:SS. UTC timezone. | ||||||
| ..details (team) | details for type participant: team | ..details (person) | details for type participant: person | ||||
| founded | Date when team was founded | weight | Participant weight | ||||
| phone | Date when team was founded | height | Participant height | ||||
| Date when team was founded | nickname | Participant nickname | |||||
| address | Addres when team is located | position_idname | Unique identifier Name of participant position | ||||
| venue_id | Unique identifier of venue in which team is playing home games | position_name | Name of participant positionbirthdate | Participant birthdate | |||
| venue_name | Name of venue in which team is playing home games | birthdate | Participant birthdate | born_place | Participant born place | ||
| is_retired | Determines if participant is retired | subtype_id | Unique identifier of subtype for participant | ||||
| subtype_name | Participant subtype name , i.e. coach,. Possible values:
| ||||||