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