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