Ohcoach Data Explorer
Tables (12)
API Activity (Untitled3)
- API Activity ID (Key) — Primary key — NOT NULL
- API Fixture ID (match_id) — Foreign key → API Match(Pair).API Fixture ID — NOT NULL
- Mapping Team ID (mapping_team_id) — NOT NULL — Foreign key → Team.Mapping Team ID — NOT NULL
- API Team ID (Field2)
- Activity Date (Field)
- Activity Start Time (Field3)
- Activty Ende Time (Field4)
- Mapping Activity ID (och_activity_id) — Foreign key → Activity.Mapping Activity ID — NOT NULL
API Match(Pair) (match)
- API Fixture ID (match_id) — Primary key — NOT NULL
- API Home Team ID (api_home_team_id)
- API Away Team ID (api_away_team_id)
- Activity Date (Field)
- Activity Start Time (Field2)
- Activity End Time (Field3)
API Team (api_team)
- API Team ID (api_team_id) — NOT NULL — Primary key — NOT NULL
- API Team Name (api_team_name) — NOT NULL
Activity (activity)
- Mapping Activity ID (och_activity_id) — Primary key — NOT NULL
- Ohcoach Activity ID (Field)
- API Activity ID (Field2)
- Activity Date (activity_ date)
- Ohcoach Activity Start TIme (activity_start_time)
- Ohcoach Activity End TIme (activity_end_time)
- Api Activity Start Time (Field3)
- Api Activity End Time (Field4)
Cell (cell)
- Cell Data ID (cell_data_id) — Primary key — NOT NULL
- Ohcoach Activity ID (Key) — Foreign key → Ohcoach Activity.Ohcoach Activity ID — NOT NULL
- Mapping Team ID (mapping_team_id) — NOT NULL — Foreign key → Ohcoach Activity.Mapping Team ID — NOT NULL
- Ohcoach Activity ID (Field)
- Ohcoach Session ID (och_session_id)
- Ohcoach P{layer ID (och_player_id) — NOT NULL
- Ohcoach Team ID (och_team_id)
- Activity Date (activity_date)
Event(Pair) (event)
- Event Data ID (event_data_id) — Primary key — NOT NULL
- API Activity ID (api_activity_id)
- Activity Date (activity_date)
- API Fixture ID (match_id) — Foreign key → API Match(Pair).API Fixture ID — NOT NULL
League-Team (league_mapper)
- Ohcoach Leage ID (och_league_id) — Primary key — NOT NULL
- Season (season) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- League Name (league_name)
- Country Code (country_code)
- Season (Field)
- Season Start Date (Field2)
- Season End Date (Field3)
Ohcoach Activity (Untitled2)
- Ohcoach Activity ID (Key) — Primary key — NOT NULL
- Mapping Team ID (mapping_team_id) — NOT NULL — Foreign key → Team.Mapping Team ID — NOT NULL
- Mapping Activity ID (och_activity_id) — Foreign key → Activity.Mapping Activity ID — NOT NULL
- Ohcoach Team ID (Field)
- Activity Date (Field2)
- Activity Start Time (Field3)
- Activity End Time (Field4)
Ohcoach Team (ohcoach_team)
- Ohcoach Team ID (ohcoach_team_id) — NOT NULL — Primary key — NOT NULL
- Ohcoach Team Name (ohcoach_team_name) — NOT NULL
Player Mapper (CopyOfCopyOfUntitled3)
- Key — Primary key — NOT NULL
- Field
Team (Untitled)
- Mapping Team ID (mapping_team_id) — NOT NULL — Primary key — NOT NULL
- Ohcoach Team ID (ohcoach_team_id) — NULL — Foreign key → Ohcoach Team.Ohcoach Team ID — NOT NULL
- Ohcoach Team Name (Field)
- API Team ID (api_team_id) — NULL — Foreign key → API Team.API Team ID — NOT NULL
- API Team Name (Field2)
Video(Pair) (video)
- Video Data ID (video_data_id) — Primary key — NOT NULL
- API Activity ID (api_activity_id)
- Activity Date (actvitiy_date)
- API Fixture ID (match_id) — Foreign key → API Match(Pair).API Fixture ID — NOT NULL