1. Architecture
DATA SPORT
  • DATABASE-SPORT
    • Tổng quan
    • Logic
      • Logic tổng thể
    • Projects
      • Yêu cầu hệ thống
      • Architecture
        • Database
    • Public APi
      • Tổng quan
    • Cron Make File
      • Tổng quan
  • GOLANG-THESPORT
    • Tổng quan
    • Architecture
      • System
      • Database
      • Source Code
    • Development
      • Local
      • Production
  • GOLANG-KSPORT
    • Tổng quan
    • Architecture
      • System
      • Database
      • Source Code
    • Development
      • Production
  • CRONJOB-LARAVEL
    • Tổng quan
    • Logic
      • Logic tổng thể
    • Projects
      • Yêu cầu hệ thống
      • Architecture
        • System
        • Source code
        • Database
      • Development
        • Dev
        • Production
      • Public API
        • Common API
          • League & Cup Profile (Basic)
          • Schedule & Results (Basic)
          • Match Modify Record
          • List of Countries
          • List of Bookmakers
          • Configuration instructions
        • Live animation
          • Configuration instructions
          • Schedule & Results
        • Live Data
          • Livescores for Today
          • Livescores Changes
          • Schedule & Results
          • Schedule Changes
          • Events
          • Stats
          • Corner
          • Lineups
          • Injury
          • Match List of Live Text
          • Live Text
          • Transfer
        • Profile
          • League & Cup Profile
          • Subleague Profile
          • Cup Stage Profile
          • Team Profile
          • Team Profile Copy
          • Team Profile for Search
          • Player Profile
          • Player Profile for Search
          • Referee Profile
          • Teamlist with Player Profile
        • Stats
          • Matches Analysis
          • List of Player Stats (Match)
          • Player Stats (Match)
          • List of Player Stats (League & Cup)
          • Player Stats (League & Cup)
          • League Standing (Get Subleague)
          • League Standing
          • Cup Standing
          • Top Scorer
          • FIFA Ranking
        • Odds (18 bookmakers)
          • Pre-match and In-play Odds (Main)
          • Live Odds Changes (Main)
          • Historical Odds (Main)
          • Future Odds (Main)
          • Pre-match and In-play Odds (All)
          • Live Odds Changes (All)
          • Historical Odds (All)
          • Future Odds (All)
          • European Odds (Halftime)
          • In-play Odds
          • In-play Odds (Halftime)
          • Odd Modify Record
        • European Odds (200+ Bookmakers)
          • European Odds (200+ Bookmakers)
        • Other Odds
          • Outrights
          • First/Last Team To Score (pre-match)
          • Goals Odd/Even (pre-match)
          • Goals Odd/Even (In-play)
          • Number of Goals in Match (pre-match)
          • Number of Goals in Match (In-play)
          • Half Time/Full Time (pre-match)
          • Half Time/Full Time (In-play)
          • Correct Score (pre-match)
          • Correct Score (In-play)
          • Half Time Correct Score (pre-match)
          • Half Time Correct Score (In-play)
          • Handicap Corners (pre-match)
          • Handicap Corners (In-play)
          • Total Corners (pre-match) - Tổng phạt góc trước trận đấu: First Odds
          • Total Corners (In-play) - Tổng số quả phạt góc (Trong trận) - Run Odds
          • Double Chance(pre-match)
          • EuroHandicap(pre-match)
  • GOLANG-WEBSOCKET
    • Tổng Quan
    • Logic
      • Logic tổng thể
    • Projects
      • Yêu cầu hệ thống
      • Architecture
        • System
        • Source code
      • Development
        • Dev
        • Production
      • Public API
        • API
  • ADMIN-BANNER
    • Tổng quan
    • Logic
      • Logic tổng thể
    • Projects
      • Architecture
        • System
        • Source Code
      • Development
        • Develop
        • Production
      • Public API
        • API
      • Database
        • Cấu trúc Database
      • Admin FE
        • HƯỚNG DẪN CÀI ĐẶT MÔI TRƯỜNG DỰ ÁN SPORT ADMIN
        • Hướng dẫn Đăng nhập
        • QUẢN LÝ SITE (SITE MANAGEMENT)
        • QUẢN LÝ GIẢI ĐẤU (LEAGUE MANAGEMENT)
        • QUẢN LÝ NHÀ CUNG CẤP (SUPPLIER MANAGEMENT)
        • TIP & CHUYÊN GIA - TAB QUẢN LÝ TIPS (TIPS MANAGEMENT)
        • WHITELIST
        • QUẢN LÝ MINIGAME (MINIGAME MANAGEMENT)
        • TRAFFIC REPORT
        • TOOLS - RAPID DATA
        • TOOLS - LIVE SITES
        • TOOLS - SUPPLIERS
        • THEME / PLUGIN
        • NGƯỜI DÙNG - PHÂN QUYỀN VÀ HIỂN THỊ (PERMISSION & DISPLAY MANAGEMENT)
        • QUẢN LÝ NGƯỜI DÙNG (USER MANAGEMENT)
        • NGƯỜI DÙNG - QUẢN LÝ NHÓM QUYỀN (ROLE GROUP MANAGEMENT)
  1. Architecture

Database

1. Table structure for Company#

CompanyID smallint NOT NULL COMMENT 'Please ignore 37 to 40.',
Name_E varchar(50) DEFAULT NULL,
isLetgoal tinyint DEFAULT NULL COMMENT 'Does the company provide data on Asian handicap, 1: true',
isTotalScore tinyint DEFAULT NULL COMMENT 'Does the company provide data on Over/Under, 1: true',
IsStandard tinyint DEFAULT NULL COMMENT 'Does the company provide data on 1X2 (European odds), 1: true',
AsianOrder tinyint DEFAULT NULL COMMENT 'Order in companies in Asia handicap. For reference only, it can be ignored',
OverDownOrder tinyint DEFAULT NULL COMMENT 'Order in companies in Over/Under. For reference only, it can be ignored',
StandardOrder tinyint DEFAULT NULL COMMENT 'Order in companies in 1X2 (European odds). For reference only, it can be ignored',
isHalf tinyint DEFAULT NULL COMMENT 'Whether to provide halftime odds data, 1: true',
europeCompanyID int DEFAULT NULL COMMENT 'Company id corresponding to "22. EuropeCompany"',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (CompanyID),
KEY IX_europeCid (europeCompanyID)

2. Table structure for Configs#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
HomeCorner int DEFAULT '0',
AwayCorner int DEFAULT '0',
HomeHalfCorner int DEFAULT '0' COMMENT 'First half corner, home team',
AwayHalfCorner int DEFAULT '0' COMMENT 'First half corner, away team',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_Corner (ScheduleID),
KEY IX_Corner (ScheduleID)

3. Table structure for CornerEvents#

EventID bigint NOT NULL,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
TeamId bigint DEFAULT NULL,
Minute int DEFAULT '0' COMMENT 'eg: 25 When the match is the injury time for the first half, minutes=45 When the match is the injury time for the second half, minutes=90',
Overtime int DEFAULT '0' COMMENT 'Injury time. eg: 0 When the match is the injury time, overtime>0',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (EventID),
UNIQUE KEY Unique_CornerEvents (EventID,ScheduleID),
KEY IX_CornerEvents (EventID,ScheduleID,TeamId),
KEY IX_scheduleID_minute (ScheduleID,Minute)

4. Table structure for CornerEvents#

OddsID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstGoal decimal(8,3) DEFAULT NULL COMMENT 'TotalCorners',
FirstUpodds decimal(8,3) DEFAULT NULL COMMENT 'The initial over odds',
FirstDownodds decimal(8,3) DEFAULT NULL COMMENT 'The initial under odds',
Goal decimal(8,3) DEFAULT NULL COMMENT 'TotalCorners',
UpOdds decimal(8,3) DEFAULT NULL COMMENT 'The instant over odds of the last update when the database is exported.',
DownOdds decimal(8,3) DEFAULT NULL COMMENT 'The instant under odds of the last update when the database is exported.',
Goal_real decimal(8,3) DEFAULT NULL COMMENT 'TotalCorners',
UpOdds_real decimal(8,3) DEFAULT NULL COMMENT 'The over odds for the last update before the match',
DownOdds_real decimal(8,3) DEFAULT NULL COMMENT 'The under odds for the last update before the match',
ModifyTime datetime DEFAULT NULL,
isStopLive tinyint DEFAULT '0' COMMENT 'Is this bet closed?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY cornersou_oddsid_unique (OddsID),
UNIQUE KEY cornersou_scheduleid_companyid_unique (ScheduleID,CompanyID)

5. Table structure for CornersOUDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
UpOdds decimal(8,3) DEFAULT NULL COMMENT 'The instant over odds of the last update when the database is exported.',
Goal decimal(8,3) DEFAULT NULL COMMENT 'TotalCorners',
DownOdds decimal(8,3) DEFAULT NULL COMMENT 'The instant under odds of the last update when the database is exported.',
ModifyTime datetime DEFAULT NULL,
isStopLive tinyint DEFAULT '0' COMMENT 'Is this bet closed?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY IX_CornersDetail (OddsID,UpOdds,Goal,DownOdds,ModifyTime,isStopLive),
KEY CornersOUDetail (OddsID)

6. Table structure for CorrectScore#

OddsID bigint NOT NULL,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstOdds longtext ,
OddsReal longtext ,
Odds longtext ,
OtherScoresOdds double(8,2) DEFAULT NULL COMMENT 'OtherScoresOdds',
isStopLive tinyint DEFAULT '0' COMMENT 'Is this bet closed?',
ModifyTime datetime DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY Unique_CorrectScore (ScheduleID,CompanyID)

7. Table structure for CorrectScoreDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
Odds longtext ,
Hash varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL,
OtherScoresOdds double(8,2) DEFAULT NULL COMMENT 'OtherScoresOdds',
isStopLive tinyint DEFAULT '0' COMMENT 'Is this bet closed?',
ModifyTime datetime DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_CorrectScoreDetail (OddsID,Hash),
KEY IX_CorrectScoreDetail (OddsID)

8. Table structure for CupMatch#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
SclassID bigint DEFAULT NULL COMMENT 'The cup ID',
ApiSclassID bigint DEFAULT NULL,
CupMatch_Type bigint DEFAULT NULL COMMENT 'Related to "GroupID" in the table "27. CupMatch_Grouping"',
Grouping varchar(4) DEFAULT NULL COMMENT 'Related to "grouping2" in the table "7. Schedule"',
Area int DEFAULT NULL,
Content text COMMENT 'Please ignore it',
strContent text COMMENT 'Cup group standing information',
matchseason varchar(10) DEFAULT NULL,
LineCount int DEFAULT NULL,
isUpdate tinyint DEFAULT NULL COMMENT 'Deprecated. Please ignore it',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
KEY IX_CupMatch_SclassID (SclassID)

9. Table structure for CupMatch_Grouping#

GroupID bigint NOT NULL,
SclassID bigint DEFAULT NULL COMMENT 'The cup ID',
ApiSclassID bigint DEFAULT NULL,
MatchSeason varchar(50) DEFAULT NULL,
IsGroup tinyint DEFAULT NULL COMMENT 'Are there groups? 1: True, 0: False',
GroupNameEn varchar(100) DEFAULT NULL,
GroupNameEnOld varchar(100) DEFAULT NULL,
GroupNum int DEFAULT NULL COMMENT 'Number of groups. If IsGroup=false, GroupNum=0',
IsCurrentGroup tinyint DEFAULT NULL COMMENT 'Is it the current group?',
taxis int DEFAULT NULL COMMENT 'Order in all groups',
LineCount int DEFAULT NULL COMMENT 'Number of qualified teams in this group',
IsZu tinyint DEFAULT NULL COMMENT 'Is it decided over two legs?',
ifMain tinyint DEFAULT NULL COMMENT 'Please ignore it',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (GroupID),
KEY IX_CupMatch_Grouping_sclassid (SclassID,MatchSeason)

10. Table structure for DetailResult#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID int DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
HappenTime smallint DEFAULT NULL,
TeamID bigint DEFAULT NULL,
PlayerID bigint DEFAULT NULL COMMENT 'Returns playerId of the scorer, substitution on or Yellow/Red card. Return null when the event has no player data.',
Kind smallint NOT NULL COMMENT '1: Goal, 2: Red card, 3: Yellow card, 7: Penalty scored, 8: Own goal, 9: Second yellow card, 11: Substitution, 13: Penalty missed',
playername_e varchar(255) DEFAULT NULL COMMENT 'Return null when the event has no player data. Returns 2 player when the event includes a goal assist or a substitution. e.g. Diego Tardelli Martins(Assists:Everton Sousa Soares) or Bruno Alves de Souza↑Cicero Dos Santos Bezerra,Didira↓',
PlayerID_in bigint DEFAULT NULL COMMENT 'Returns playerId of the assister or substitution off. Return null when the event has no player data.',
InjureTime varchar(10) DEFAULT NULL COMMENT 'Injury time',
ModifyTime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
KEY IX_DetailResult_ScheduleID (ScheduleID),
KEY detailresult_playerid_index (PlayerID),
KEY idx_teamid (TeamID)

11. Table structure for DoubleChance#

OddsID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstHomeDraw decimal(8,3) DEFAULT NULL COMMENT 'The initial First odds 1X',
FirstHomeAway decimal(8,3) DEFAULT NULL COMMENT 'The initial First odds 12',
FirstDrawAway decimal(8,3) DEFAULT NULL COMMENT 'The initial First odds X2',
HomeDraw decimal(8,3) DEFAULT NULL COMMENT 'First odds 1X for the last update before the match',
HomeAway decimal(8,3) DEFAULT NULL COMMENT 'First odds 12 for the last update before the match',
DrawAway decimal(8,3) DEFAULT NULL COMMENT 'First odds X2 for the last update before the match',
RealHomeDraw decimal(8,3) DEFAULT NULL COMMENT 'The instant First odds 1X',
RealHomeAway decimal(8,3) DEFAULT NULL COMMENT 'The instant First odds 12',
RealDrawAway decimal(8,3) DEFAULT NULL COMMENT 'The instant First odds X2',
ModifyTime datetime DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY doublechance_oddsid_unique (OddsID),
UNIQUE KEY Unique_DoubleChance (ScheduleID,CompanyID),
KEY ID_DoubleChance (OddsID)

12. Table structure for DoubleChanceDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
HomeDraw decimal(8,3) DEFAULT NULL,
HomeAway decimal(8,3) DEFAULT NULL,
DrawAway decimal(8,3) DEFAULT NULL,
ModifyTime datetime DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_DoubleChanceDetail (OddsID,HomeDraw,HomeAway,DrawAway,ModifyTime),
KEY ID_DoubleChanceDetail (OddsID)

13. Table structure for EuroHandicap#

OddsID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstHandicap bigint DEFAULT NULL COMMENT 'First Odds Handicap',
FirstHome double(8,2) DEFAULT NULL COMMENT 'First Odds Home',
FirstDraw double(8,2) DEFAULT NULL COMMENT 'First Odds Draw',
FirstAway double(8,2) DEFAULT NULL COMMENT 'First Odds Away',
HandicapReal bigint DEFAULT NULL COMMENT 'Handicap Real',
HomeReal double(8,2) DEFAULT NULL COMMENT 'Real Odds Home',
DrawReal double(8,2) DEFAULT NULL COMMENT 'Real Odds Draw',
AwayReal double(8,2) DEFAULT NULL COMMENT 'Real Odds Away',
Handicap bigint DEFAULT NULL COMMENT 'Live Odds Handicap',
Home double(8,2) DEFAULT NULL COMMENT 'Live Odds Home',
Draw double(8,2) DEFAULT NULL COMMENT 'Live Odds Draw',
Away double(8,2) DEFAULT NULL COMMENT 'Live Odds Away',
ModifyTime datetime DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY Unique_EuroHandicap (ScheduleID,CompanyID),
KEY IX_EuroHandicap (ScheduleID,CompanyID)

14. Table structure for EuroHandicapDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
Handicap bigint DEFAULT NULL,
Home double(8,2) DEFAULT NULL,
Draw double(8,2) DEFAULT NULL,
Away double(8,2) DEFAULT NULL,
ModifyTime datetime DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_EuroHandicapDetail (OddsID,Handicap,Home,Draw,Away,ModifyTime),
KEY ID_EuroHandicapDetail (OddsID)

15. Table structure for EuropeCompany#

CompanyID bigint NOT NULL COMMENT 'It is different from 8.Company',
Name_E varchar(100) NOT NULL COMMENT 'English name of the bookmaker',
isPrimary tinyint DEFAULT NULL COMMENT 'Is it a mainstream company of "9. Company"',
isExchange tinyint DEFAULT NULL COMMENT 'Is it an exchange',
Sort smallint DEFAULT NULL COMMENT 'Order in bookmakers. For reference only, it can be ignored',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (CompanyID)

16. Table structure for EuropeOdds#

OddsID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstHomeWin double(8,2) DEFAULT NULL COMMENT 'The initial home team win odds',
FirstStandoff double(8,2) DEFAULT NULL COMMENT 'The initial draw odds',
FirstGuestWin double(8,2) DEFAULT NULL COMMENT 'The initial away team win odds',
RealHomeWin double(8,2) DEFAULT NULL COMMENT 'The home team win odds for the last update before the match',
RealStandoff double(8,2) DEFAULT NULL COMMENT 'The draw odds for the last update before the match',
RealGuestWin double(8,2) DEFAULT NULL COMMENT 'The away team win odds for the last update before the match',
HomeWin_R double(8,2) DEFAULT NULL COMMENT 'The instant home team win odds of the last update when the database is exported.',
Standoff_R double(8,2) DEFAULT NULL COMMENT 'The instant away team win odds of the last update when the database is exported.',
GuestWin_R double(8,2) DEFAULT NULL COMMENT 'The instant draw odds of the last update when the database is exported.',
ModifyTime datetime DEFAULT NULL,
isStopLive tinyint DEFAULT NULL COMMENT 'Is there inplay odds?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY CompanySchedule_EuropeOdds (ScheduleID,CompanyID)

17. Table structure for EuropeOddsDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
HomeWin double(8,2) DEFAULT NULL COMMENT 'The home team win odds',
Standoff double(8,2) DEFAULT NULL COMMENT 'The draw odds',
GuestWin double(8,2) DEFAULT NULL COMMENT 'The away team win odds',
type tinyint DEFAULT NULL COMMENT '0: Unable to judge, 1: Early Odds, 2: Instant odds, 3: inplay odds',
ModifyTime timestamp NULL DEFAULT NULL,
UnixAddTime varchar(255) DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_EuropeOddsDetailNew (OddsID,UnixAddTime),
KEY IX_EuropeOddsDetailNew (OddsID)

18. Table structure for EuropeOddsTotal#

ScheduleID bigint NOT NULL,
ApiScheduleID bigint DEFAULT NULL,
FirstHomeWin decimal(8,3) DEFAULT NULL COMMENT 'The average of initial home team winning odds',
FirstStandoff decimal(8,3) DEFAULT NULL COMMENT 'The average of initial draw odds',
FirstGuestWin decimal(8,3) DEFAULT NULL COMMENT 'The average of initial away team winning odds',
RealHomeWin decimal(8,3) DEFAULT NULL COMMENT 'The average of home team winning odds for the lastest update before the match',
RealStandoff decimal(8,3) DEFAULT NULL COMMENT 'The average of drawn odds for the lastest update before the match',
RealGuestWin decimal(8,3) DEFAULT NULL COMMENT 'The average of away team winning odds for the lastest update before the match',
Num smallint DEFAULT NULL COMMENT 'Number of bookmakers opened',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ScheduleID),
UNIQUE KEY europeoddstotal_scheduleid_unique (ScheduleID)

19. Table structure for FifaRanking#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
TeamID bigint NOT NULL,
Name_E varchar(255) DEFAULT NULL COMMENT 'English name',
Type tinyint DEFAULT '0' COMMENT 'Return text directly, a total of 3 types: 1. MENS RANKING 2. WOMENS RANKING 3.Club',
TypeName varchar(50) DEFAULT NULL,
Continent varchar(50) DEFAULT NULL COMMENT 'Club ranking returns null.',
Rank smallint DEFAULT '0',
RankChange smallint DEFAULT '0',
Score smallint DEFAULT '0',
ScoreChange smallint DEFAULT '0',
UpdateDate varchar(50) DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Uniquy_FifaRanking (TeamID,Type,UpdateDate),
KEY IX_TeamID (TeamID),
KEY IX_Type (Type)

20. Table structure for HeadToHead#

ScheduleID bigint NOT NULL,
result_vn longtext ,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
result_th longtext ,
result_en longtext ,
PRIMARY KEY (ScheduleID),
UNIQUE KEY Unique_HeadToHead (ScheduleID)

21. Table structure for Honor#

ID int unsigned NOT NULL AUTO_INCREMENT,
Name_E varchar(50) DEFAULT NULL COMMENT 'Honor Name',
AreaID bigint DEFAULT NULL,
SetupDate varchar(255) DEFAULT NULL,
IconPath varchar(255) DEFAULT NULL COMMENT 'Logo',
Alias1 varchar(255) DEFAULT NULL,
Alias2 varchar(255) DEFAULT NULL,
Alias3 varchar(255) DEFAULT NULL,
Alias4 varchar(255) DEFAULT NULL,
Alias5 varchar(255) DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_Honor (Name_E)

22. Table structure for Injury#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
TeamID bigint DEFAULT NULL,
PlayerId bigint DEFAULT NULL,
Name varchar(50) DEFAULT NULL,
ReasonType int DEFAULT NULL COMMENT 'The id of the Reason.There are many types, you can directly take the reason field.',
Reason varchar(50) DEFAULT NULL COMMENT 'Reason for injury or suspend.',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_Injury (ScheduleID,TeamID,PlayerId,ReasonType),
KEY IX_Injury (ScheduleID,TeamID,PlayerId)

23. Table structure for LiveScores#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
MatchID bigint DEFAULT NULL,
ApiMatchID bigint DEFAULT NULL,
LeagueID bigint DEFAULT NULL,
ApiLeagueID bigint DEFAULT NULL,
LeagueName varchar(50) DEFAULT NULL,
LeagueShortName varchar(50) DEFAULT NULL,
SubLeagueID bigint DEFAULT NULL,
SubLeagueName varchar(50) DEFAULT NULL,
MatchTime datetime DEFAULT NULL,
HalfStartTime datetime DEFAULT NULL,
HomeId bigint DEFAULT NULL,
HomeName varchar(50) DEFAULT NULL,
AwayId bigint DEFAULT NULL,
AwayName varchar(50) DEFAULT NULL,
Status int DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY unique_live_scores (MatchID)

24. Table structure for LiveText#

LiveId bigint NOT NULL,
ScheduleID bigint NOT NULL,
ApiScheduleID bigint DEFAULT NULL,
MatchTime datetime DEFAULT NULL COMMENT 'Data update time, unix timestamp',
UnixMatchTime bigint unsigned DEFAULT NULL COMMENT 'Data update time, unix timestamp',
Content longtext ,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (LiveId),
KEY livetext_matchtime_index (MatchTime),
KEY livetext_scheduleid_matchtime_index (ScheduleID,MatchTime),
KEY livetext_liveid_index (LiveId)

25. Table structure for LiveTextContent#

ScheduleID bigint NOT NULL,
ApiScheduleID bigint DEFAULT NULL,
MatchTime datetime DEFAULT NULL COMMENT 'Match scheduled time',
UnixMatchTime bigint unsigned DEFAULT NULL COMMENT 'Data update time, unix timestamp',
LeagueName varchar(50) DEFAULT NULL,
HomeName varchar(50) DEFAULT NULL,
AwayName varchar(50) DEFAULT NULL,
Content longtext ,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ScheduleID),
KEY livetextcontent_scheduleid_matchtime_index (ScheduleID,MatchTime)

26. Table structure for Lottery#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
Date date NOT NULL,
Province varchar(255) NOT NULL,
Code varchar(10) NOT NULL,
Region varchar(10) NOT NULL,
PrizeSpecial varchar(255) DEFAULT NULL,
Prize1 varchar(255) DEFAULT NULL,
Prize2 varchar(255) DEFAULT NULL,
Prize3 varchar(255) DEFAULT NULL,
Prize4 varchar(255) DEFAULT NULL,
Prize5 varchar(255) DEFAULT NULL,
Prize6 varchar(255) DEFAULT NULL,
Prize7 varchar(255) DEFAULT NULL,
Prize8 varchar(255) DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY uniq_lottery_date_province (Date,Province),
KEY idx_lottery_region_date (Region,Date),
KEY idx_lottery_code_date (Code,Date)

27. Table structure for MatchAnalysis#

ScheduleID bigint NOT NULL,
result_vn longtext ,
result_en longtext ,
result_th longtext ,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ScheduleID),
UNIQUE KEY Unique_MatchAnalysis (ScheduleID)

28. Table structure for MultiLetGoal#

OddsID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstGoal double(8,2) DEFAULT NULL COMMENT 'The initial handicap',
FirstUpodds double(8,2) DEFAULT NULL COMMENT 'The initial home team win odds',
FirstDownodds double(8,2) DEFAULT NULL COMMENT 'The initial away team win odds',
Goal double(8,2) DEFAULT NULL COMMENT 'The instant handicap of the last update when the database is exported.',
UpOdds double(8,2) DEFAULT NULL COMMENT 'The instant home team win odds of the last update when the database is exported.',
DownOdds double(8,2) DEFAULT NULL COMMENT 'The instant away team win odds of the last update when the database is exported.',
Goal_Real double(8,2) DEFAULT NULL COMMENT 'The handicap for the last update before the match',
UpOdds_Real double(8,2) DEFAULT NULL COMMENT 'The home team win odds for the last update before the match',
DownOdds_Real double(8,2) DEFAULT NULL COMMENT 'The away team win odds for the last update before the match',
ModifyTime datetime DEFAULT NULL,
ZouDi tinyint DEFAULT NULL COMMENT 'Will this match provide inplay odds',
Num smallint DEFAULT NULL COMMENT 'Used to distinguish the odds that a bookmaker has provided at the same time. Provide up to 4 kinds of markets.',
isStopLive tinyint DEFAULT '0' COMMENT 'Is this bet closed?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY IX_MultiLetGoal (ScheduleID,CompanyID,Num),
KEY IX_ScheduleID_CompanyID (ScheduleID,CompanyID)

29. Table structure for MultiLetGoalDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
upOdds double(8,2) DEFAULT NULL COMMENT 'The home team win odds',
Goal double(8,2) DEFAULT NULL COMMENT 'The handicap',
downOdds double(8,2) DEFAULT NULL COMMENT 'The away team win odds',
addTime timestamp NULL DEFAULT NULL,
UnixAddTime bigint unsigned DEFAULT NULL,
type smallint NOT NULL COMMENT '0: Unable to judge, 1: Early Odds, 2: Instant odds (after the early odds before the match), 3: inplay odds',
ZouDi tinyint DEFAULT '0' COMMENT 'Will this match provide inplay odds',
isStopLive tinyint DEFAULT '0' COMMENT 'Is this bet closed?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_MultiLetGoalDetailNew (OddsID,UnixAddTime),
KEY IX_MultiLetGoalDetailNew (OddsID,type)

30. Table structure for MultiLetGoalhalf#

OddsID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstGoal double(8,2) DEFAULT NULL COMMENT 'The initial handicap',
FirstUpodds double(8,2) DEFAULT NULL COMMENT 'The initial home team win odds',
FirstDownodds double(8,2) DEFAULT NULL COMMENT 'The initial away team win odds',
Goal double(8,2) DEFAULT NULL COMMENT 'The instant handicap of the last update when the database is exported.',
UpOdds double(8,2) DEFAULT NULL COMMENT 'The instant home team win odds of the last update when the database is exported.',
DownOdds double(8,2) DEFAULT NULL COMMENT 'The instant away team win odds of the last update when the database is exported.',
Goal_Real double(8,2) DEFAULT NULL COMMENT 'The handicap for the last update before the match',
UpOdds_Real double(8,2) DEFAULT NULL COMMENT 'The home team win odds for the last update before the match',
DownOdds_Real double(8,2) DEFAULT NULL COMMENT 'The away team win odds for the last update before the match',
ModifyTime datetime DEFAULT NULL,
ZouDi tinyint DEFAULT NULL COMMENT 'Will this match provide inplay odds',
Num smallint DEFAULT NULL COMMENT 'Used to distinguish the odds that a bookmaker has provided at the same time. Provide up to 4 kinds of markets.',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY IX_MultiLetGoalhalf (ScheduleID,CompanyID,Num),
KEY IX_ScheduleID_CompanyID (ScheduleID,CompanyID)

31. Table structure for MultiLetGoalhalfDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
upOdds double(8,2) DEFAULT NULL COMMENT 'The home team win odds',
Goal double(8,2) DEFAULT NULL COMMENT 'The handicap',
downOdds double(8,2) DEFAULT NULL COMMENT 'The away team win odds',
addTime timestamp NULL DEFAULT NULL,
UnixAddTime bigint unsigned DEFAULT NULL,
type smallint NOT NULL COMMENT '0: Unable to judge, 1: Early Odds, 2: Instant odds (after the early odds before the match), 3: inplay odds',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_MultiLetGoalhalfDetailNew (OddsID,UnixAddTime),
KEY IX_MultiLetGoalhalfDetailNew (OddsID,type)

31. Table structure for MultiTotalScore#

OddsID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstGoal double(8,2) DEFAULT NULL COMMENT 'The initial handicap',
FirstUpodds double(8,2) DEFAULT NULL COMMENT 'The initial over odds',
FirstDownodds double(8,2) DEFAULT NULL COMMENT 'The initial under odds',
Goal double(8,2) DEFAULT NULL COMMENT 'The instant handicap of the last update when the database is exported.',
UpOdds double(8,2) DEFAULT NULL COMMENT 'The instant over odds of the last update when the database is exported.',
DownOdds double(8,2) DEFAULT NULL COMMENT 'The instant under odds of the last update when the database is exported.',
Goal_real double(8,2) DEFAULT NULL COMMENT 'The handicap for the last update before the match',
UpOdds_real double(8,2) DEFAULT NULL COMMENT 'The over odds for the last update before the match',
DownOdds_real double(8,2) DEFAULT NULL COMMENT 'The under odds for the last update before the match',
ModifyTime datetime DEFAULT NULL,
Zoudi tinyint DEFAULT NULL COMMENT 'Will this match provide inplay odds',
Num smallint DEFAULT NULL COMMENT 'Used to distinguish the odds that a bookmaker has provided at the same time. Provide up to 4 kinds of markets.',
isStopLive tinyint DEFAULT '0' COMMENT 'Is this bet closed?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY multitotalscore_scheduleid_companyid_num_unique (ScheduleID,CompanyID,Num),
KEY IX_ScheduleID_CompanyID (ScheduleID,CompanyID)

32. Table structure for MultiTotalScoreDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
UpOdds double(8,2) DEFAULT NULL COMMENT 'The over odds',
Goal double(8,2) DEFAULT NULL COMMENT 'The handicap',
DownOdds double(8,2) DEFAULT NULL COMMENT 'The under odds',
addTime timestamp NULL DEFAULT NULL,
UnixAddTime bigint unsigned DEFAULT NULL,
type smallint NOT NULL COMMENT '0: Unable to judge, 1: Early Odds, 2: Instant odds (after the early odds before the match), 3: inplay odds',
isStopLive tinyint DEFAULT '0' COMMENT 'Is this bet closed?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_MultiTotalScoreDetailNew (OddsID,UnixAddTime),
KEY IX_MultiTotalScoreDetailNew (OddsID,type)

33. Table structure for MultiTotalScorehalf#

OddsID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstGoal double(8,2) DEFAULT NULL COMMENT 'The initial handicap',
FirstUpodds double(8,2) DEFAULT NULL COMMENT 'The initial over odds',
FirstDownodds double(8,2) DEFAULT NULL COMMENT 'The initial under odds',
Goal double(8,2) DEFAULT NULL COMMENT 'The instant handicap of the last update when the database is exported.',
UpOdds double(8,2) DEFAULT NULL COMMENT 'The instant over odds of the last update when the database is exported.',
DownOdds double(8,2) DEFAULT NULL COMMENT 'The instant under odds of the last update when the database is exported.',
Goal_Real double(8,2) DEFAULT NULL COMMENT 'The handicap for the last update before the match',
UpOdds_Real double(8,2) DEFAULT NULL COMMENT 'The over odds for the last update before the match',
DownOdds_Real double(8,2) DEFAULT NULL COMMENT 'The under odds for the last update before the match',
ModifyTime datetime DEFAULT NULL,
Zoudi tinyint DEFAULT NULL COMMENT 'Will this match provide inplay odds',
Num smallint DEFAULT NULL COMMENT 'Used to distinguish the odds that a bookmaker has provided at the same time. Provide up to 4 kinds of markets.',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY multitotalscorehalf_scheduleid_companyid_num_unique (ScheduleID,CompanyID,Num),
KEY IX_ScheduleID_CompanyID (ScheduleID,CompanyID)

34. Table structure for MultiTotalScorehalfDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
UpOdds double(8,2) DEFAULT NULL COMMENT 'The over odds',
Goal double(8,2) DEFAULT NULL COMMENT 'The handicap',
DownOdds double(8,2) DEFAULT NULL COMMENT 'The under odds',
addTime timestamp NULL DEFAULT NULL,
UnixAddTime bigint unsigned DEFAULT NULL,
type smallint NOT NULL DEFAULT '1' COMMENT '0: Unable to judge, 1: Early Odds, 2: Instant odds (after the early odds before the match), 3: inplay odds',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_MultiTotalScorehalfDetailNew (OddsID,UnixAddTime),
KEY IX_MultiTotalScorehalfDetailNew (OddsID,type)

35. Table structure for Outrights#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
SclassID bigint DEFAULT NULL,
ApiSclassID bigint DEFAULT NULL,
Name_E varchar(50) DEFAULT NULL COMMENT 'League Short Name',
Season varchar(30) DEFAULT NULL COMMENT 'Current season, e.g. 2019-2020, 2020',
TypeID smallint DEFAULT NULL COMMENT '1 -> 21',
TypeName varchar(50) DEFAULT NULL,
ItemList longtext ,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_Outrights (SclassID,Season,TypeID),
KEY outrights_sclassid_index (SclassID),
KEY outrights_season_index (Season),
KEY outrights_typeid_index (TypeID)

36. Table structure for Player#

PlayerID bigint NOT NULL COMMENT 'Player ID as a bit integer',
Kind smallint DEFAULT NULL,
Name_E varchar(50) DEFAULT NULL COMMENT 'English full name',
Name_Es varchar(50) DEFAULT NULL COMMENT 'English short name',
Birthday datetime DEFAULT NULL,
Tallness smallint DEFAULT NULL COMMENT 'Height in cm, e.g. 192',
Weight smallint DEFAULT NULL COMMENT 'Weight in kg, e.g. 77',
CountryEn varchar(50) DEFAULT NULL COMMENT 'Player nationality',
Photo varchar(1024) DEFAULT NULL COMMENT 'URL of player photo',
IntroduceEn text COMMENT 'Player introduction',
IdiomaticFeet tinyint DEFAULT NULL COMMENT '0: Left-footed, 1: Right-footed, 2: Double-footed',
ExpectedValue float(8,2) DEFAULT NULL COMMENT 'Expected value in ten thousand pounds, e.g. 3150',
ModifyTime datetime DEFAULT NULL,
EndDateContract date DEFAULT NULL COMMENT 'Contract deadline',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (PlayerID),
UNIQUE KEY player_playerid_unique (PlayerID),
KEY IX_player_expectedvalue (ExpectedValue),
KEY idx_player_modifytime (ModifyTime)

37. Table structure for PlayerHonor#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
PlayerID bigint DEFAULT NULL,
Season varchar(100) DEFAULT NULL,
TeamID int DEFAULT NULL COMMENT 'League/Team ID | When kind=1, it is Team ID | When kind=2, it is League ID',
HonorID bigint DEFAULT NULL COMMENT 'Honor ID',
type bigint NOT NULL DEFAULT '1' COMMENT 'Champion or Runner-up Type | 1：Champion Team 2：Runner-up team Default 1',
kind tinyint(1) NOT NULL DEFAULT '1' COMMENT '1：Players honors on the team | 2：Players honors in the league | Default 1',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY playerhonor_id_unique (ID)

37. Table structure for PlayerInTeam#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
PlayerID bigint DEFAULT NULL,
TeamID bigint DEFAULT NULL,
Number varchar(3) DEFAULT NULL,
coachTypeID bigint DEFAULT NULL COMMENT 'ID in the table "3. PlayerTranslate", coach type id',
captainTypeID bigint DEFAULT NULL COMMENT 'ID in the table "3. PlayerTranslate", captain type id',
PlayerPositionID bigint DEFAULT NULL COMMENT 'ID in the table "3. PlayerTranslate", player type id',
PHY int NOT NULL DEFAULT '0',
DEF int NOT NULL DEFAULT '0',
DRI int NOT NULL DEFAULT '0',
PAS int NOT NULL DEFAULT '0',
SHO int NOT NULL DEFAULT '0',
PAC int NOT NULL DEFAULT '0',
startTime date DEFAULT NULL COMMENT 'When to start playing for this team',
endTime date DEFAULT NULL COMMENT 'When to end playing for this team',
ModifyTime datetime DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
KEY IX_PlayerInTeam (TeamID),
KEY IX_PlayerInTeam_PlayerID (PlayerID)

38. Table structure for PlayerTechLeagueCup#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
PlayerID bigint DEFAULT NULL,
TeamID bigint DEFAULT NULL,
SclassID bigint DEFAULT NULL,
ApiSclassID bigint DEFAULT NULL,
MatchSeason varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Season, e.g. 2019-2020, 2020',
AppearanceCount smallint DEFAULT '0',
SubstituteCount smallint DEFAULT '0',
PlayingTime smallint DEFAULT '0',
Goals smallint DEFAULT '0' COMMENT 'Penalty not included',
PenaltyGoals smallint DEFAULT '0' COMMENT 'Penalty goals',
ShotCount smallint DEFAULT '0',
ShotTargetCount smallint DEFAULT '0',
WasFouledCount smallint DEFAULT '0',
OffsideCount smallint DEFAULT '0',
BestCount smallint DEFAULT '0',
Rating double(8,2) DEFAULT NULL COMMENT 'Player rating',
PassCount smallint DEFAULT '0',
PassSuccessCount smallint DEFAULT '0',
KeyPassCount smallint DEFAULT '0',
AssistCount smallint DEFAULT '0',
LongPassCount smallint DEFAULT '0',
LongPassSuccessCount smallint DEFAULT '0',
ThroughPassCount smallint DEFAULT '0',
ThroughPassSuccessCount smallint DEFAULT '0',
DribblesSuccessCount smallint DEFAULT '0',
CrossPassCount smallint DEFAULT '0',
CrossPassSuccessCount smallint DEFAULT '0',
TackleCount smallint DEFAULT '0',
InterceptionCount smallint DEFAULT '0',
ClearanceCount smallint DEFAULT '0',
DispossessedCount smallint DEFAULT '0',
ShotBlockedCount smallint DEFAULT '0',
AerialSuccessCount smallint DEFAULT '0',
FoulsCount smallint DEFAULT '0',
RedCount smallint DEFAULT '0',
YellowCount smallint DEFAULT '0',
TurnOverCount smallint DEFAULT '0',
ModifyTime datetime DEFAULT NULL COMMENT 'Modify time, unix timestamp',
HomeTeam tinyint DEFAULT NULL COMMENT 'true: Home team, Is it home team player stats?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_PlayerTechLeagueCups (PlayerID,TeamID,SclassID,MatchSeason,HomeTeam),
KEY playertechleaguecup_playerid_index (PlayerID),
KEY playertechleaguecup_teamid_index (TeamID),
KEY index_sclassid_matchseason (SclassID,MatchSeason)

38. Table structure for PlayerTechStatistics#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
scheduleID bigint DEFAULT NULL COMMENT 'ID in the table "7. Schedule"',
ApiScheduleID bigint DEFAULT NULL,
teamID bigint DEFAULT NULL COMMENT 'Team identifier',
playerID bigint DEFAULT NULL COMMENT 'Player identifier',
playerName varchar(50) DEFAULT NULL COMMENT 'English name',
rating double(8,2) DEFAULT NULL COMMENT 'Player rating',
shots smallint DEFAULT NULL COMMENT 'Total shots',
shotsTarget smallint DEFAULT NULL COMMENT 'Shots on target',
keyPass smallint DEFAULT NULL COMMENT 'Total key passes',
totalPass smallint DEFAULT NULL COMMENT 'Total passes',
accuratePass smallint DEFAULT NULL COMMENT 'Accurate passes',
aerialWon smallint DEFAULT NULL COMMENT 'Aerial duels won',
touches smallint DEFAULT NULL COMMENT 'Total touches',
tackles smallint DEFAULT NULL COMMENT 'Total tackles',
interception smallint DEFAULT NULL COMMENT 'Total interceptions',
clearances smallint DEFAULT NULL COMMENT 'Total clearances',
clearanceWon smallint DEFAULT NULL COMMENT 'Clearances won',
shotsBlocked smallint DEFAULT NULL COMMENT 'Shots blocked',
OffsideProvoked smallint DEFAULT NULL COMMENT 'Offsides provoked',
fouls smallint DEFAULT NULL COMMENT 'Total fouls',
dribblesWon smallint DEFAULT NULL COMMENT 'Dribbles won',
wasFouled smallint DEFAULT NULL COMMENT 'Times fouled',
dispossessed smallint DEFAULT NULL COMMENT 'Times dispossessed',
turnOver smallint DEFAULT NULL COMMENT 'Turnovers',
Offsides smallint DEFAULT NULL COMMENT 'Total offsides',
CrossNum smallint DEFAULT NULL COMMENT 'Total crosses',
CrossWon smallint DEFAULT NULL COMMENT 'Successful crosses',
longBalls smallint DEFAULT NULL COMMENT 'Total long balls',
longBallsWon smallint DEFAULT NULL COMMENT 'Successful long balls',
throughBall smallint DEFAULT NULL COMMENT 'Total through balls',
throughBallWon smallint DEFAULT NULL COMMENT 'Successful through balls',
penaltyProvoked smallint DEFAULT NULL COMMENT 'Penalties provoked',
penaltyMaked smallint DEFAULT '0' COMMENT 'Penalties scored',
penaltyTotal smallint DEFAULT NULL COMMENT 'Total penalties',
penaltyGoals smallint DEFAULT NULL COMMENT 'Penalty goals',
notPenaltyGoals smallint DEFAULT NULL COMMENT 'Goals scored from open play',
assist smallint DEFAULT NULL COMMENT 'Total assists',
second_yellow smallint DEFAULT NULL COMMENT 'Second yellow cards',
yellow smallint DEFAULT NULL COMMENT 'Total yellow cards',
red smallint DEFAULT NULL COMMENT 'Total red cards',
shotOnPost smallint DEFAULT NULL COMMENT 'Shots hit the post',
ClearanceOffLine smallint DEFAULT NULL COMMENT 'Clearances off the line',
penaltySave smallint DEFAULT NULL COMMENT 'Penalty saves',
errorLeadToGoal smallint DEFAULT NULL COMMENT 'Errors leading to goals',
lastManTackle smallint DEFAULT NULL COMMENT 'Last man tackles',
lastManContest smallint DEFAULT NULL COMMENT 'Last man contests',
ownGoals smallint DEFAULT NULL COMMENT 'Own goals',
isBest tinyint DEFAULT NULL COMMENT 'Is the player MVP in this match?',
ShotsOffTarget smallint unsigned NOT NULL DEFAULT '0',
ShotsByBlocked smallint unsigned NOT NULL DEFAULT '0',
DribbleTotal smallint unsigned NOT NULL DEFAULT '0',
DuelWon smallint unsigned NOT NULL DEFAULT '0',
DuelTotal smallint unsigned NOT NULL DEFAULT '0',
AerialTotal smallint unsigned NOT NULL DEFAULT '0',
PossessionLost smallint unsigned NOT NULL DEFAULT '0',
DribbledPast smallint unsigned NOT NULL DEFAULT '0',
Saves smallint unsigned NOT NULL DEFAULT '0',
Punches smallint unsigned NOT NULL DEFAULT '0',
RunsOutWon smallint unsigned NOT NULL DEFAULT '0',
RunsOutTotal smallint unsigned NOT NULL DEFAULT '0',
HighClaims smallint unsigned NOT NULL DEFAULT '0',
ErrorLedToShot smallint unsigned NOT NULL DEFAULT '0',
BigChanceCreated smallint unsigned NOT NULL DEFAULT '0',
BigChanceMissed smallint unsigned NOT NULL DEFAULT '0',
SavesFromInsideBox smallint unsigned NOT NULL DEFAULT '0',
PositionName varchar(50) DEFAULT NULL COMMENT 'Position Player',
Number bigint DEFAULT NULL,
PassRate varchar(128) DEFAULT NULL,
PlayingTime bigint DEFAULT NULL,
FirstTeam tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is the player in the starting lineup? 1: TRUE, 0: FALSE',
modifyTime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY IX_PlayerTechStatistics_UniqueKey (scheduleID,teamID,playerID,playerName),
KEY playertechstatistics_scheduleid_index (scheduleID),
KEY playertechstatistics_playerid_index (playerID)

39. Table structure for PlayerTransfer#

recordId bigint DEFAULT NULL COMMENT 'The record id',
PlayerID bigint DEFAULT NULL COMMENT 'Player ID',
transferTime timestamp NULL DEFAULT NULL COMMENT 'Transfer time, unixtimestamp',
endTime timestamp NULL DEFAULT NULL COMMENT 'End time, unixtimestamp',
fromTeam varchar(255) DEFAULT NULL COMMENT 'From team name',
fromTeamId bigint DEFAULT NULL COMMENT 'From team ID',
toTeam varchar(255) DEFAULT NULL COMMENT 'To team name',
toTeamId bigint DEFAULT NULL COMMENT 'To team ID',
money longtext COMMENT 'Transfer price',
season varchar(255) DEFAULT NULL COMMENT 'Transfer season e.g. 2023-2024',
type varchar(255) DEFAULT NULL COMMENT 'Transfer type:\n 1. Owned Wholly\n 2 Loan\n 3 Free Transfer\n 4 End Loan\n 5. Owned jointly',
modifyTime timestamp NULL DEFAULT NULL COMMENT 'End time, unixtimestamp',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
UNIQUE KEY playertransfer_recordid_playerid_unique (recordId,PlayerID)

40. Table structure for PlayerTranslate#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
Kind smallint DEFAULT NULL COMMENT 'Position classification (1: Player positions, 2: Staff positions, 3: Please ignore it, 4: Type of injury, 5: Type of suspension)',
Name_E varchar(60) DEFAULT NULL COMMENT 'Player positions or staff positions, e.g., Centre Forward, Coach',
Name_E_Short varchar(10) DEFAULT NULL COMMENT 'Short name of the player''s position',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID)

41. Table structure for Player_ZH#

ZH_ID bigint NOT NULL COMMENT 'Transfer ID: Transfer record number',
PlayerID bigint DEFAULT NULL,
transferTime datetime DEFAULT NULL COMMENT 'Transfer Time',
endTime datetime DEFAULT NULL COMMENT 'End Time',
Money char(30) DEFAULT NULL COMMENT 'Transfer Price',
Place char(10) DEFAULT NULL COMMENT 'Position in the original team',
TeamID bigint DEFAULT NULL COMMENT 'From team ID',
TeamNowID bigint DEFAULT NULL COMMENT 'To team ID',
ZH_Season char(10) DEFAULT NULL COMMENT 'Transfer Season',
type bigint DEFAULT NULL COMMENT '1：Owned Wholly 2：Loan 3：Free Transfer 4：End Loan 5：Owned jointly',
ModifyTime datetime DEFAULT NULL COMMENT 'Returns the record time of "added, modified" in the last n days, unix timestamp',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
UNIQUE KEY IX_ZH_ID (ZH_ID,PlayerID),
KEY IX_PlayerID (PlayerID),
KEY IX_transferTime (transferTime),
KEY IX_TeamID (TeamID),
KEY IX_TeamNowID (TeamNowID),
KEY IX_ZH_Season (ZH_Season)

41. Table structure for QualifyColor#

ColorID bigint NOT NULL,
QuName_J varchar(50) NOT NULL DEFAULT '',
QuName_F varchar(50) NOT NULL DEFAULT '',
QuName_E varchar(50) NOT NULL DEFAULT '',
Color varchar(10) NOT NULL DEFAULT '',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ColorID)

42. Table structure for Referee#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
TypeId int DEFAULT '0' COMMENT '1: Referee 2: Assistant referee 3: Fourth official',
RefereeId bigint DEFAULT NULL,
Name varchar(50) DEFAULT NULL,
Birthday date DEFAULT NULL COMMENT 'Date of birth, e.g. 1987-02-02',
Country varchar(50) DEFAULT NULL,
Photo varchar(1024) DEFAULT NULL COMMENT 'Referee photo url',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_Referee (ScheduleID,RefereeId),
KEY IX_Referee (ScheduleID,RefereeId,Name)

43. Table structure for Schedule#

ScheduleID bigint NOT NULL,
KsportEventID bigint DEFAULT NULL,
RapidEventID varchar(50) DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
SclassID int DEFAULT NULL,
ApiSclassID bigint DEFAULT NULL,
MatchSeason varchar(50) DEFAULT NULL,
GroupID varchar(10) DEFAULT NULL COMMENT 'stageId',
round varchar(255) DEFAULT NULL COMMENT 'League round or cup stage, e.g. 10',
grouping varchar(50) DEFAULT NULL,
HomeTeamID bigint DEFAULT NULL,
GuestTeamID bigint DEFAULT NULL,
Neutrality tinyint(1) DEFAULT '0' COMMENT 'Is it a neutral venue?',
MatchTime datetime DEFAULT NULL COMMENT 'Start time of the match',
MatchTime2 datetime DEFAULT NULL COMMENT 'Start time of the second half',
Home_OrderEn varchar(255) DEFAULT NULL,
Guest_OrderEn varchar(255) DEFAULT NULL,
MatchState smallint DEFAULT '0' COMMENT 'Match status: 0: Not started, -1: Finished',
WeatherIcon smallint DEFAULT NULL COMMENT 'Weather conditions',
WeatherName varchar(128) DEFAULT NULL,
Temperature varchar(50) DEFAULT NULL,
Location varchar(255) DEFAULT NULL COMMENT 'Match address',
Visitor int DEFAULT NULL COMMENT 'Is there lineup data for the match? 1: true',
HomeScore smallint DEFAULT NULL,
GuestScore smallint DEFAULT NULL,
HomeHalfScore smallint DEFAULT NULL COMMENT 'Home score of the first half',
GuestHalfScore smallint DEFAULT NULL COMMENT 'Guest score of the first half',
Explain_en longtext COMMENT 'Special case description of the match, e.g. Match end up with [0-3], due to (Torpedo-MAZ Minsk) withdraw from the match',
Explainlist varchar(100) DEFAULT NULL COMMENT 'Return to Extra time, Penalty kicks, etc.',
Home_Red smallint DEFAULT NULL,
Guest_Red smallint DEFAULT NULL,
Home_Yellow smallint DEFAULT NULL,
Guest_Yellow smallint DEFAULT NULL,
bf_changetime datetime DEFAULT NULL COMMENT 'Please ignore it',
grouping2 varchar(50) DEFAULT NULL,
subSclassID bigint DEFAULT NULL COMMENT 'ID in the table "29. subsclass"',
ApiSubSclassID bigint DEFAULT NULL,
homeCorner tinyint DEFAULT NULL,
homeCornerHalf tinyint DEFAULT NULL COMMENT 'Home corner in the first half',
guestCorner tinyint DEFAULT NULL,
guestCornerHalf tinyint DEFAULT NULL COMMENT 'Guest corner in the first half',
InjuryTime int DEFAULT NULL COMMENT 'Length of injury time in the first and second half',
VarEvents varchar(100) DEFAULT NULL COMMENT 'VAR events',
IsLiveAnimation tinyint(1) DEFAULT '0',
IsLiveText tinyint(1) DEFAULT '0',
IsEvent tinyint(1) DEFAULT '0',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ScheduleID),
KEY schedule_matchtime_index (MatchTime),
KEY schedule_sclassid_matchseason_index (SclassID,MatchSeason),
KEY schedule_hometeamid_index (HomeTeamID),
KEY schedule_guestteamid_index (GuestTeamID),
KEY IX_MatchState (MatchState),
KEY IX_KsportEventID (KsportEventID),
KEY idx_rapid_event_id (RapidEventID)

44. Table structure for ScheduleAnalysis#

ScheduleID bigint NOT NULL,
ApiScheduleID bigint DEFAULT NULL,
HeadToHead longtext ,
HomeLastMatches longtext ,
AwayLastMatches longtext ,
HomeSchedule longtext ,
AwaySchedule longtext ,
HomeOdds longtext ,
AwayOdds longtext ,
HomeGoals longtext ,
AwayGoals longtext ,
HomeHT longtext ,
AwayHT longtext ,
HomeShootTime longtext ,
AwayShootTime longtext ,
HomeSingleDouble longtext ,
AwaySingleDouble longtext ,
HomeDataVs longtext ,
AwayDataVs longtext ,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ScheduleID),
UNIQUE KEY Unique_ScheduleAnalysis (ScheduleID),
KEY scheduleanalysis_apischeduleid_index (ApiScheduleID)

45. Table structure for SchedulePrediction#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL COMMENT 'Schedule',
HomeName varchar(100) DEFAULT NULL,
HomeWinPercent double(8,2) DEFAULT NULL,
GuestName varchar(100) DEFAULT NULL,
GuestWinPercent double(8,2) DEFAULT NULL,
DrawPercent double(8,2) DEFAULT NULL,
Comment varchar(250) DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
rank tinyint DEFAULT NULL,
Detail longtext ,
Detail_en longtext ,
Summary longtext ,
Summary_en longtext ,
UserName varchar(255) DEFAULT NULL,
UserName_en varchar(255) DEFAULT NULL,
Detail_th longtext ,
Summary_th longtext ,
UserName_th varchar(255) DEFAULT NULL,
like int NOT NULL DEFAULT '0',
view int NOT NULL DEFAULT '0',
slug varchar(255) DEFAULT NULL,
slug_th varchar(255) DEFAULT NULL,
slug_en varchar(255) DEFAULT NULL,
ScoreHomePredict varchar(255) DEFAULT NULL,
ScoreGuestPredict varchar(255) DEFAULT NULL,
creator_id bigint unsigned DEFAULT NULL,
OverUnderPrediction enum('O','U') DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY scheduleprediction_id_unique (ID),
KEY scheduleprediction_scheduleid_index (ScheduleID),
KEY scheduleprediction_creator_id_index (creator_id),
KEY scheduleprediction_overunderprediction_index (OverUnderPrediction),
KEY scheduleprediction_slug_index (slug),
KEY scheduleprediction_slug_th_index (slug_th),
KEY scheduleprediction_slug_en_index (slug_en),
CONSTRAINT scheduleprediction_creator_id_foreign FOREIGN KEY (creator_id) REFERENCES content_creators (id) ON DELETE SET NULL

46. Table structure for ScheduleVoted#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL COMMENT 'Schedule',
IpAddress varchar(30) DEFAULT NULL,
UserID bigint DEFAULT '0',
TeamWinID bigint DEFAULT NULL COMMENT '0:draw, >0: winning team id',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY schedulevoted_id_unique (ID),
KEY schedulevoted_scheduleid_index (ScheduleID)

47. Table structure for Sclass#

sclassID bigint NOT NULL,
ApiSclassID bigint DEFAULT NULL,
Color varchar(7) DEFAULT NULL COMMENT 'RGB color code string for display',
Name_E varchar(50) DEFAULT NULL COMMENT 'English full name',
Name_ES varchar(255) DEFAULT NULL,
SubLeagueName varchar(50) DEFAULT NULL,
Kind smallint DEFAULT NULL COMMENT '1: League, 2: Cup',
Mode smallint DEFAULT NULL COMMENT '1: Round, 2: Group',
count_round smallint DEFAULT NULL COMMENT 'Number of rounds',
curr_round smallint DEFAULT NULL COMMENT 'The current round',
Curr_matchSeason varchar(10) DEFAULT NULL COMMENT 'Current season, e.g. 2019-2020, 2020',
Sclass_pic varchar(100) DEFAULT NULL,
ifstop tinyint DEFAULT NULL COMMENT '1: False, 2: True',
sclass_sequence smallint DEFAULT NULL COMMENT 'Order in leagues',
Bf_IfDisp tinyint DEFAULT NULL COMMENT 'Deprecated',
Bf_simply_disp tinyint DEFAULT NULL COMMENT '1: True, 0: False',
ifHaveSub tinyint(1) DEFAULT NULL COMMENT '1: True, 0: False',
BeginSeason varchar(9) DEFAULT NULL COMMENT 'The first season in history',
sclass_ruleEn varchar(4000) DEFAULT NULL COMMENT 'Rules',
InfoID smallint DEFAULT NULL COMMENT 'InfoID in the table "6. SclassInfo"',
ModifyTime datetime DEFAULT NULL,
IsHot tinyint DEFAULT '0' COMMENT 'League is hot?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (sclassID)

48. Table structure for SclassInfo#

InfoID bigint NOT NULL,
NameEN varchar(50) DEFAULT NULL,
FlagPic varchar(1000) DEFAULT NULL,
InfoOrder int DEFAULT NULL COMMENT 'Order in country or regions within each area',
Info_type int DEFAULT NULL COMMENT '1: Europe, 2: America, 3: Asia, 4: Oceania, 5: Africa',
ModifyTime datetime DEFAULT NULL,
allOrder smallint DEFAULT NULL COMMENT 'Order in all countries or regions',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (InfoID)

49. Table structure for SclassQualify#

QualifyID bigint NOT NULL,
SclassID bigint NOT NULL DEFAULT '-1',
ApiSclassID bigint DEFAULT NULL,
SubSclassID bigint DEFAULT NULL,
ApiSubSclassID bigint DEFAULT NULL,
BeginSeason varchar(30) NOT NULL DEFAULT '',
EndSeason varchar(30) NOT NULL DEFAULT '',
BeginRank int NOT NULL DEFAULT '-1',
EndRank int NOT NULL DEFAULT '-1',
ColorID int NOT NULL DEFAULT '0',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (QualifyID)

50. Table structure for Score#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
TeamID bigint DEFAULT NULL,
SclassID bigint DEFAULT NULL COMMENT 'The league ID',
ApiSclassID bigint DEFAULT NULL,
Win_Score int DEFAULT '0' COMMENT 'The number of wins',
Flat_Score int DEFAULT '0' COMMENT 'The number of draws',
Fail_Score int DEFAULT '0' COMMENT 'The number of losses',
Total_Homescore int DEFAULT '0' COMMENT 'Total goals',
Total_Guestscore int DEFAULT '0' COMMENT 'Goals conceded',
homeorguest tinyint DEFAULT NULL COMMENT '1: Home game, 0: Away game, 3: Deduction',
Matchseason char(10) DEFAULT NULL,
deduct int DEFAULT '0' COMMENT 'Deducted points',
causeEn varchar(255) NOT NULL,
Rank tinyint unsigned DEFAULT NULL,
addScore double(8,2) DEFAULT '0.00' COMMENT 'Extra points in the sub league',
subSclassID bigint DEFAULT NULL COMMENT 'ID in the table "29. SubSclass"',
ApiSubSclassID bigint DEFAULT NULL COMMENT 'ID in the table "29. SubSclass"',
WinRate double(8,2) DEFAULT '0.00',
DrawRate double(8,2) DEFAULT '0.00',
LoseRate double(8,2) DEFAULT '0.00',
WinAverage double(8,2) DEFAULT '0.00',
LoseAverage double(8,2) DEFAULT '0.00',
TotalCount int DEFAULT '0',
GoalDifference int DEFAULT '0',
ModifyTime datetime DEFAULT NULL COMMENT 'LastUpdateTime',
Integral int DEFAULT '0' COMMENT 'Without deduction.',
RedCard bigint DEFAULT NULL COMMENT 'Number of times received red card',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
ScoreCountType int DEFAULT '0' COMMENT 'Whether to show the additional points column, if the value is not 0 then show.',
Conference tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Does the team belong to eastern or western conference? 1: TRUE, 0: FALSE',
PRIMARY KEY (ID),
UNIQUE KEY Unique_Score (TeamID,SclassID,homeorguest,Matchseason,subSclassID)

51. Table structure for ScoreHalf#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
TeamID bigint DEFAULT NULL,
SclassID bigint DEFAULT NULL COMMENT 'The league ID',
ApiSclassID bigint DEFAULT NULL,
Win_Score int DEFAULT '0' COMMENT 'The number of wins',
Flat_Score int DEFAULT '0' COMMENT 'The number of draws',
Fail_Score int DEFAULT '0' COMMENT 'The number of losses',
Total_Homescore int DEFAULT '0' COMMENT 'Total goals',
Total_Guestscore int DEFAULT '0' COMMENT 'Goals conceded',
homeorguest tinyint DEFAULT NULL COMMENT '1: Home game, 0: Away game, 3: Deduction',
Matchseason char(10) DEFAULT NULL,
deduct int DEFAULT '0' COMMENT 'Deducted points',
causeEn varchar(100) DEFAULT NULL COMMENT 'Reason for deduction',
Rank tinyint DEFAULT NULL,
addScore double(8,2) DEFAULT '0.00' COMMENT 'Extra points in the sub league',
subSclassID bigint DEFAULT NULL COMMENT 'ID in the table "29. SubSclass"',
ApiSubSclassID bigint DEFAULT NULL COMMENT 'ID in the table "29. SubSclass"',
WinRate double(8,2) DEFAULT '0.00',
DrawRate double(8,2) DEFAULT '0.00',
LoseRate double(8,2) DEFAULT '0.00',
WinAverage double(8,2) DEFAULT '0.00',
LoseAverage double(8,2) DEFAULT '0.00',
TotalCount int DEFAULT '0',
GoalDifference int DEFAULT '0',
Integral int DEFAULT '0' COMMENT 'Without deduction.',
ScoreCountType int DEFAULT '0' COMMENT 'Whether to show the additional points column, if the value is not 0 then show.',
Conference tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Does the team belong to eastern or western conference? 1: TRUE, 0: FALSE',
ModifyTime datetime DEFAULT NULL COMMENT 'LastUpdateTime',
RedCard bigint DEFAULT NULL COMMENT 'Number of times received red card',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_ScoreHalf (TeamID,SclassID,homeorguest,Matchseason,subSclassID)

52. Table structure for ScoreHalfTotal#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
TeamID bigint DEFAULT NULL,
SclassID bigint DEFAULT NULL COMMENT 'The league ID',
ApiSclassID bigint DEFAULT NULL COMMENT 'The league ID',
SubSclassID bigint DEFAULT NULL COMMENT 'ID in the table "29. SubSclass"',
ApiSubSclassID bigint DEFAULT NULL COMMENT 'ID in the table "29. SubSclass"',
Matchseason char(10) DEFAULT NULL,
Rank tinyint DEFAULT NULL,
WinRate double(8,2) DEFAULT '0.00',
DrawRate double(8,2) DEFAULT '0.00',
LoseRate double(8,2) DEFAULT '0.00',
WinAverage double(8,2) DEFAULT '0.00',
LoseAverage double(8,2) DEFAULT '0.00',
TotalCount int DEFAULT '0',
WinCount int DEFAULT '0',
DrawCount int DEFAULT '0',
LoseCount int DEFAULT '0',
GetScore int DEFAULT '0',
LoseScore int DEFAULT '0',
GoalDifference int DEFAULT '0',
Integral int DEFAULT '0' COMMENT 'Without deduction.',
ScoreCountType int DEFAULT '0' COMMENT 'Whether to show the additional points column, if the value is not 0 then show.',
Conference tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Does the team belong to eastern or western conference? 1: TRUE, 0: FALSE',
ModifyTime datetime DEFAULT NULL COMMENT 'LastUpdateTime',
UnixModifyTime bigint unsigned DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_ScoreHalfTotal (TeamID,SclassID,Matchseason,SubSclassID,Rank),
KEY IX_ScoreTotal (TeamID,SclassID,Matchseason,SubSclassID)

53. Table structure for ScoreTotal#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
TeamID bigint DEFAULT NULL,
SclassID bigint DEFAULT NULL COMMENT 'The league ID',
ApiSclassID bigint DEFAULT NULL COMMENT 'The league ID',
SubSclassID bigint DEFAULT NULL COMMENT 'ID in the table "29. SubSclass"',
ApiSubSclassID bigint DEFAULT NULL COMMENT 'ID in the table "29. SubSclass"',
Matchseason char(10) DEFAULT NULL,
Rank tinyint DEFAULT NULL,
WinRate double(8,2) DEFAULT '0.00',
DrawRate double(8,2) DEFAULT '0.00',
LoseRate double(8,2) DEFAULT '0.00',
WinAverage double(8,2) DEFAULT '0.00',
LoseAverage double(8,2) DEFAULT '0.00',
Deduction int DEFAULT '0' COMMENT 'Deducted points',
DeductionExplain varchar(100) DEFAULT NULL COMMENT 'Reason for deduction',
RecentFirstResult int DEFAULT '0' COMMENT 'Result of the recent first match 0: win 1: draw 2: lose 3: empty',
RecentSecondResult int DEFAULT '0' COMMENT 'Result of the recent second match 0: win 1: draw 2: lose 3: empty',
RecentThirdResult int DEFAULT '0' COMMENT 'Result of the recent third match 0: win 1: draw 2: lose 3: empty',
RecentFourthResult int DEFAULT '0' COMMENT 'Result of the recent fourth match 0: win 1: draw 2: lose 3: empty',
RecentFifthResult int DEFAULT '0' COMMENT 'Result of the recent fifth match 0: win 1: draw 2: lose 3: empty',
RecentSixthResult int DEFAULT '0' COMMENT 'Result of the recent sixth match 0: win 1: draw 2: lose 3: empty',
Color int DEFAULT '0' COMMENT 'Promotion and Relegation. The value represents the serial number in leagueColorInfo (starting from 0), -1 means no promotion or relegation.',
Red int DEFAULT '0',
TotalCount int DEFAULT '0',
WinCount int DEFAULT '0',
DrawCount int DEFAULT '0',
LoseCount int DEFAULT '0',
GetScore int DEFAULT '0',
LoseScore int DEFAULT '0',
GoalDifference int DEFAULT '0',
TotalAddScore int DEFAULT '0' COMMENT 'Additional points',
Integral int DEFAULT '0' COMMENT 'Without deduction.',
ScoreCountType int DEFAULT '0' COMMENT 'Whether to show the additional points column, if the value is not 0 then show.',
Conference tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Does the team belong to eastern or western conference? 1: TRUE, 0: FALSE',
ModifyTime datetime DEFAULT NULL COMMENT 'LastUpdateTime',
UnixModifyTime bigint unsigned DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_ScoreTotal (TeamID,SclassID,Matchseason,SubSclassID,Rank),
KEY IX_ScoreTotal (TeamID,SclassID,Matchseason,SubSclassID)

54. Table structure for Standard#

OddsID bigint unsigned NOT NULL AUTO_INCREMENT,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstHomeWin double(8,2) DEFAULT NULL COMMENT 'The initial home team win odds',
FirstStandoff double(8,2) DEFAULT NULL COMMENT 'The initial draw odds',
FirstGuestWin double(8,2) DEFAULT NULL COMMENT 'The initial away team win odds',
HomeWin double(8,2) DEFAULT NULL COMMENT 'The home team win odds for the last update before the match',
Standoff double(8,2) DEFAULT NULL COMMENT 'The draw odds for the last update before the match',
GuestWin double(8,2) DEFAULT NULL COMMENT 'The away team win odds for the last update before the match',
HomeWin_R double(8,2) DEFAULT NULL COMMENT 'The instant home team win odds of the last update when the database is exported.',
Standoff_R double(8,2) DEFAULT NULL COMMENT 'The instant away team win odds of the last update when the database is exported.',
GuestWin_R double(8,2) DEFAULT NULL COMMENT 'The instant draw odds of the last update when the database is exported.',
ModifyTime datetime DEFAULT NULL,
isStopLive tinyint DEFAULT '0' COMMENT 'Is this bet closed?',
type smallint NOT NULL DEFAULT '0' COMMENT '0: Unable to judge, 1: Early Odds, 2: Instant odds (after the early odds before the match), 3: inplay odds',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY standard_scheduleid_companyid_unique (ScheduleID,CompanyID)

55. Table structure for StandardDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
HomeWin double(8,2) DEFAULT NULL COMMENT 'The home team win odds',
Standoff double(8,2) DEFAULT NULL COMMENT 'The draw odds',
GuestWin double(8,2) DEFAULT NULL COMMENT 'The away team win odds',
ModifyTime datetime DEFAULT NULL COMMENT 'LastUpdateTime',
UnixModifyTime bigint unsigned DEFAULT NULL,
isEarly tinyint DEFAULT '0' COMMENT 'It is early odds?',
type smallint NOT NULL DEFAULT '0' COMMENT '0: Unable to judge, 1: Early Odds, 2: Instant odds (after the early odds before the match), 3: inplay odds',
isStopLive tinyint DEFAULT '0' COMMENT 'Is this bet closed?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_StandardDetailNew (OddsID,UnixModifyTime),
KEY IX_StandardDetailNew (OddsID,isEarly)

56. Table structure for StandardHalf#

OddsID bigint NOT NULL,
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
CompanyID bigint DEFAULT NULL,
FirstHomeWin double(8,2) DEFAULT NULL COMMENT 'The initial home team win odds',
FirstStandoff double(8,2) DEFAULT NULL COMMENT 'The initial draw odds',
FirstGuestWin double(8,2) DEFAULT NULL COMMENT 'The initial away team win odds',
HomeWin double(8,2) DEFAULT NULL COMMENT 'The home team win odds for the last update before the match',
Standoff double(8,2) DEFAULT NULL COMMENT 'The draw odds for the last update before the match',
GuestWin double(8,2) DEFAULT NULL COMMENT 'The away team win odds for the last update before the match',
HomeWin_R double(8,2) DEFAULT NULL COMMENT 'The instant home team win odds of the last update when the database is exported.',
Standoff_R double(8,2) DEFAULT NULL COMMENT 'The instant away team win odds of the last update when the database is exported.',
GuestWin_R double(8,2) DEFAULT NULL COMMENT 'The instant draw odds of the last update when the database is exported.',
ModifyTime datetime DEFAULT NULL,
isStopLive tinyint DEFAULT '1' COMMENT 'Is this bet closed?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (OddsID),
UNIQUE KEY IX_StandardHalf (ScheduleID,CompanyID)

57. Table structure for StandardHalfDetail#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
OddsID bigint DEFAULT NULL,
HomeWin double(8,2) DEFAULT NULL COMMENT 'The home team win odds',
Standoff double(8,2) DEFAULT NULL COMMENT 'The draw odds',
GuestWin double(8,2) DEFAULT NULL COMMENT 'The away team win odds',
ModifyTime timestamp NULL DEFAULT NULL,
UnixModifyTime bigint unsigned DEFAULT NULL,
isEarly tinyint DEFAULT NULL COMMENT 'It is early odds?',
type tinyint DEFAULT NULL COMMENT '0: Unable to judge, 1: Early Odds, 2: Instant odds (after the early odds before the match), 3: inplay odds',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
deleted_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_StandardHalfDetailNew (OddsID,UnixModifyTime),
KEY IX_StandardHalfDetailNew (OddsID,type)

58. Table structure for SubSclass#

subSclassID bigint NOT NULL COMMENT 'Unique identifier',
ApiSubSclassID bigint DEFAULT NULL,
sclassid bigint DEFAULT NULL COMMENT 'The league ID',
ApiSclassID bigint DEFAULT NULL,
IsHaveScore tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is there standing data? (1: true, 0: false)',
sortNumber int DEFAULT NULL COMMENT 'Order in subleagues',
curr_round int DEFAULT NULL COMMENT 'Current round',
count_round int DEFAULT NULL COMMENT 'Total rounds of the league',
IsCurrentSclass tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is this subleague in progress?',
subSclassNameEn varchar(50) DEFAULT NULL,
subName_Es varchar(50) DEFAULT NULL,
IncludeSeason varchar(300) DEFAULT NULL COMMENT 'e.g. 2010,2011',
IsZu tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is it decided over two legs?',
CurrentSeason varchar(10) DEFAULT NULL COMMENT 'e.g. 2020',
isPrimary tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is it primary?',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (subSclassID),
KEY subsclass_sclassid_index (sclassid),
KEY IX_sclassid_currentSclass (sclassid,IsCurrentSclass)

59. Table structure for Team#

TeamID bigint NOT NULL,
TeamRapidID varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL,
Kind smallint DEFAULT NULL,
SClassID bigint NOT NULL DEFAULT '0' COMMENT 'The league or cup ID',
ApiSclassID bigint DEFAULT NULL,
Name_E varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'English name',
Found_date varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL,
AreaEn varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL,
GymnasiumEn varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Home court of the team',
Capacity int DEFAULT NULL COMMENT 'Capacity of the home court',
Flag varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'URL of team logo',
address varchar(150) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Team address',
URL varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Official website',
introduceEn text CHARACTER SET utf8mb4 COMMENT 'Introduction to the team',
Conference tinyint NOT NULL DEFAULT '0' COMMENT 'Division of the team in their league',
isNational tinyint(1) NOT NULL DEFAULT '0' COMMENT '1: yes, 0: no',
ModifyTime datetime DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (TeamID),
UNIQUE KEY team_teamid_unique (TeamID),
KEY team_sclassid_index (SClassID),
KEY team_name_e_index (Name_E),
KEY idx_team_modifytime (ModifyTime),
KEY idx_team_rapid_id (TeamRapidID)

60. Table structure for TeamHonor#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
TeamID bigint DEFAULT NULL,
Season varchar(400) DEFAULT NULL,
HonorID bigint DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_TeamHonor (TeamID,Season,HonorID),
KEY IX_TeamID (TeamID),
KEY IX_Season (Season),
KEY IX_HonorID (HonorID)

61. Table structure for TeamLineupNew#

ID int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Team lineup unique number',
ScheduleID bigint DEFAULT NULL,
ApiScheduleID bigint DEFAULT NULL,
HomeFormation bigint DEFAULT NULL,
AwayFormation bigint DEFAULT NULL,
IsPreview tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is it a predicted lineup? 0 Unpredicted lineup 1 Predicted lineup',
HomeLineup longtext ,
AwayLineup longtext ,
HomeBackup longtext ,
AwayBackup longtext ,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY teamlineupnew_id_unique (ID),
UNIQUE KEY Unique_TeamLineupNew (ScheduleID,IsPreview),
KEY teamlineupnew_scheduleid_index (ScheduleID)

62. Table structure for TeamTechStatistics#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
scheduleID bigint DEFAULT NULL COMMENT 'ID in the table "7. Schedule"',
ApiScheduleID bigint DEFAULT NULL,
teamID bigint DEFAULT NULL COMMENT 'Team identifier',
kickOffFirst tinyint NOT NULL DEFAULT '0' COMMENT 'Is the team playing the kick-off?',
firstCorner tinyint NOT NULL DEFAULT '0' COMMENT 'Is the team playing the first corner?',
lastCorner tinyint NOT NULL DEFAULT '0' COMMENT 'Is the team playing the last corner?',
firstYellow tinyint NOT NULL DEFAULT '0' COMMENT 'Is the team getting the first yellow card?',
lastYellow tinyint NOT NULL DEFAULT '0' COMMENT 'Is the team getting the last yellow card?',
firstSubst tinyint NOT NULL DEFAULT '0' COMMENT 'Whether the first substitution in this match belongs to our team?',
lastSubst tinyint NOT NULL DEFAULT '0' COMMENT 'Whether the last substitution in this match belongs to our team?',
firstOffside tinyint NOT NULL DEFAULT '0' COMMENT 'Whether the first offside in this match belongs to our team?',
lastOffside tinyint NOT NULL DEFAULT '0' COMMENT 'Whether the last offside in this match belongs to our team?',
shots tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total shots',
target tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Shots on target',
offTarget tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Shots off target',
hitWoodwork tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Shots that hit the woodwork',
fouls tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total fouls',
corner tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total corner kicks',
cornerHalf tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'First half corner kicks',
cornerOver tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Overtime corner kicks',
freeKick tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total free kicks',
offside tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total offside',
offsideOver tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Overtime offside',
ownGoal tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total own goals',
yellow tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total yellow cards',
yellowOver tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Overtime yellow cards',
red tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total red cards',
controlPercent tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Ball possession percentage',
controlPercentHalf tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Ball possession percentage in the first half',
header tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total headers',
headerSuc tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Successful headers',
save tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total saves',
GKPounced tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Goalkeeper come out',
lostBall tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total lost balls',
stealSuc tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Successful steals',
holdUp tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total hold-ups',
blocked tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total blocked shots',
tackle tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total tackles',
passBall int NOT NULL DEFAULT '0' COMMENT 'Total passes',
passBallSuc int NOT NULL DEFAULT '0' COMMENT 'Successful passes',
passBallSucTemp int NOT NULL DEFAULT '0',
longPass tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total long passes',
shortPass int NOT NULL DEFAULT '0' COMMENT 'Total short passes',
successCross tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total successful crosses',
successCrossTemp tinyint unsigned NOT NULL DEFAULT '0',
assists tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total assists',
subst tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total substitutions',
substOver tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Overtime substitutions',
dribbles tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total dribbles',
throwIns tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total throw-ins',
dangerousAtt tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Total dangerous attacks',
rating double(8,2) NOT NULL DEFAULT '0.00' COMMENT 'Team rating',
attack smallint NOT NULL DEFAULT '0' COMMENT 'Team attack rating',
clearances int NOT NULL DEFAULT '0',
aerialDuelsWon int NOT NULL DEFAULT '0',
groundDuelsWon int NOT NULL DEFAULT '0',
accurateCrosses int NOT NULL DEFAULT '0',
touchesInOppositionBox int NOT NULL DEFAULT '0',
xGOT int NOT NULL DEFAULT '0',
xGNonPenalty int NOT NULL DEFAULT '0',
xGSetPlay int NOT NULL DEFAULT '0',
xGOpenPlay int NOT NULL DEFAULT '0',
expectedGoals int NOT NULL DEFAULT '0',
duelsWon int NOT NULL DEFAULT '0',
shotsOutsideBox int NOT NULL DEFAULT '0',
shotsInsideBox int NOT NULL DEFAULT '0',
bigChancesMissed int NOT NULL DEFAULT '0',
bigChances int NOT NULL DEFAULT '0',
ModifyTime datetime DEFAULT NULL,
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY teamtechstatistics_scheduleid_teamid_unique (scheduleID,teamID)

63. Table structure for TopScorer#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
PlayerID bigint DEFAULT NULL,
PlayerName varchar(50) DEFAULT NULL,
TeamID bigint DEFAULT NULL,
TeamName varchar(50) DEFAULT NULL,
SclassID bigint DEFAULT NULL,
ApiSclassID bigint DEFAULT NULL,
MatchSeason varchar(50) DEFAULT NULL,
CountryName varchar(50) DEFAULT NULL,
GoalsCount int DEFAULT NULL COMMENT 'Total goals, including penalty',
HomeGoals int DEFAULT NULL COMMENT 'Goals in home matches, including penalty',
AwayGoals int DEFAULT NULL COMMENT 'Goals in away matches, including penalty',
HomePenalty int DEFAULT NULL COMMENT 'Penalty in home matches.',
AwayPenalty int DEFAULT NULL COMMENT 'Penalty in away matches.',
MatchNum int DEFAULT NULL COMMENT 'Number of appearances. Some cup matches do not have this field.',
SubNum int DEFAULT NULL COMMENT 'Number of substitute appearances. Some cups do not have this field.',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_TopScorer (PlayerID,TeamID,SclassID,MatchSeason),
KEY IX_TopScorer (PlayerID,TeamID,SclassID,MatchSeason)

64. Table structure for TopSoccerLeagueSimulate#

ID bigint unsigned NOT NULL AUTO_INCREMENT,
PlayerID bigint DEFAULT NULL,
TeamID bigint DEFAULT NULL,
SclassID bigint DEFAULT NULL,
ApiSclassID bigint DEFAULT NULL,
MatchSeason varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Season, e.g. 2019-2020, 2020',
AppearanceCount smallint DEFAULT '0',
SubstituteCount smallint DEFAULT '0',
PlayingTime smallint DEFAULT '0',
Goals smallint DEFAULT '0' COMMENT 'Penalty not included',
PenaltyGoals smallint DEFAULT '0' COMMENT 'Penalty goals',
ShotCount smallint DEFAULT '0',
ShotTargetCount smallint DEFAULT '0',
WasFouledCount smallint DEFAULT '0',
OffsideCount smallint DEFAULT '0',
BestCount smallint DEFAULT '0',
Rating double(8,2) DEFAULT NULL COMMENT 'Player rating',
PassCount smallint DEFAULT '0',
PassSuccessCount smallint DEFAULT '0',
KeyPassCount smallint DEFAULT '0',
AssistCount smallint DEFAULT '0',
LongPassCount smallint DEFAULT '0',
LongPassSuccessCount smallint DEFAULT '0',
ThroughPassCount smallint DEFAULT '0',
ThroughPassSuccessCount smallint DEFAULT '0',
DribblesSuccessCount smallint DEFAULT '0',
CrossPassCount smallint DEFAULT '0',
CrossPassSuccessCount smallint DEFAULT '0',
TackleCount smallint DEFAULT '0',
InterceptionCount smallint DEFAULT '0',
ClearanceCount smallint DEFAULT '0',
DispossessedCount smallint DEFAULT '0',
ShotBlockedCount smallint DEFAULT '0',
AerialSuccessCount smallint DEFAULT '0',
FoulsCount smallint DEFAULT '0',
RedCount smallint DEFAULT '0',
YellowCount smallint DEFAULT '0',
TurnOverCount smallint DEFAULT '0',
PlayerName varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Player full name',
PlayerPhoto varchar(500) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Player image URL',
PlayerDescription text CHARACTER SET utf8mb4 COMMENT 'Player introduction / bio',
TeamName varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Current team playing in the league',
created_at timestamp NULL DEFAULT NULL,
updated_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY Unique_TopSoccerLeagueSimulate (PlayerID,TeamID,SclassID,MatchSeason),
KEY topsoccerleaguesimulate_playerid_index (PlayerID),
KEY topsoccerleaguesimulate_teamid_index (TeamID),
KEY index_sclassid_matchseason (SclassID,MatchSeason)
Modified at 2026-03-25 09:49:46
Previous
Yêu cầu hệ thống
Next
Tổng quan
Built with