erd

Tables (8)

bet

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • bet_id (Field) — bigint(20)
  • bet_base_line (Field2) — varchar(255)
  • bet_line (Field3) — varchar(255)
  • bet_name (Field4) — varchar(255)
  • bet_participant_id (Field5) — bigint(20)
  • bet_player_id (Field6) — varchar(255)
  • bet_player_name (Field7) — varchar(255)
  • bet_settlement (Field8) — bigint(20)
  • bet_start_price (Field9) — varchar(255)
  • bet_status (Field10) — bigint(20)
  • bet_update_status (Field11) — varchar(255)
  • bet_last_update (Field12) — datetime(6)
  • fixture_id (Field13) — bigint(20)
  • market_id (Field14) — bigint(20)

fixture

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • fixture_id (Field) — bigint(20)
  • market_id (Field19) — bigint
  • created_at (Field2) — datetime(6)
  • update_at (Field3) — datetime(6)
  • home_participant_id (Field11) — bigint
  • home_participant_name (Field12) — varchar(255)
  • home_participant_position (Field13) — varchar(255)
  • away_participant_id (Field4) — bigint(20)
  • away_participant_name (Field5) — varchar(255)
  • away_participant_position (Field6) — varchar(255)
  • fixture_last_update (Field7) — datetime(6)
  • fixture_start_date (Field8) — datetime(6)
  • fixture_subscription_status (Field9) — bigint
  • fixture_subscription_type (Field10) — bigint
  • home_team (Field14) — varchar(255)
  • league (Field15) — bigint
  • league_name (Field16) — varchar(255)
  • location (Field17) — varchar(255)
  • location_name (Field18) — bigint
  • sport (Field20) — bigint
  • sport_name (Field21) — varchar(255)
  • start_date (Field22) — varchar(255)
  • start_time (Field23) — varchar(255)
  • status (Field24) — bigint

fixture_extra_data (extra)

  • id (Key) — bigint — Primary key — NOT NULL
  • fixtrue_extra_data_name (Field) — varchar(255)
  • fixture_extra_data_value (Field2) — varchar(255)
  • fixture_id (Field3) — bigint

incidents (incident)

  • id (Key) — bigint — Primary key — NOT NULL
  • incidents_home_results_position (Field) — varchar(255)
  • incidents_home_results_value (Field2) — varchar(255)
  • incidents_away_results_position (Field3) — varchar(255)
  • incidents_away_results_value (Field4) — varchar(255)
  • incidents_incident_type (Field5) — bigint
  • incidents_participant_position (Field6) — varchar(255)
  • incidents_period (Field7) — bigint
  • incidents_player_id (Field8) — bigint
  • incidents_player_name (Field9) — varchar(255)
  • incidents_seconds (Field10) — varchar(255)
  • fixture_id (Field11) — bigint

market

  • id (Key) — bigint — Primary key — NOT NULL
  • market_id (Field) — bigint
  • market_main_line (Field3) — varchar(255)
  • market_name (Field4) — varchar(255)
  • fixture_id (Field2) — bigint

period

  • id (Key) — bigint — Primary key — NOT NULL
  • period_home_result_position (Field) — varchar(255)
  • period_home_result_value (Field2) — varchar(255)
  • period_away_result_position (Field3) — varchar(255)
  • period_away_result_value (Field4) — varchar(255)
  • is_confirmed (Field5) — bit
  • is_finished (Field6) — bit
  • period_type (Field7) — bigint
  • sequence_number (Field8) — bigint
  • fixture_id (Field9) — bigint

scoreboard

  • id (Key) — bigint — Primary key — NOT NULL
  • scoreboard_home_result_position (Field) — varchar(255)
  • scoreboard_home_result_value (Field2) — varchar(255)
  • scoreboard_away_result_position (Field3) — varchar(255)
  • scoreboard_away_result_value (Field4) — varchar(255)
  • scoreboard_current_period (Field5) — bigint
  • scoreboard_status (Field6) — bigint
  • scoreboard_time (Field7) — varchar(255)
  • fixture_id (Field8) — bigint

statistics

  • id (Key) — bigint — Primary key — NOT NULL
  • statistics_home_results_position (Field) — varchar(255)
  • statistics_home_results_value (Field2) — varchar(255)
  • statistics_away_results_position (Field3) — varchar(255)
  • statistics_away_results_value (Field4) — varchar(255)
  • statistics_type (Field5) — bigint
  • fixture_id (Field6) — bigint