Simply, The best Hockey Simulator!

Try It, Buy It!

STHS Logo

This page contains all the tables and table fields in the SQLite Database output by the version 3 of the STHS.

Table Direct Link

Players, Goalies & Coach: PlayerInfo - PlayerProStat - PlayerFarmStat - PlayerProStatMultipleTeam - PlayerFarmStatMultipleTeam - GoalerInfo - GoalerProStat - GoalerFarmStat - GoalerProStatMultipleTeam - GoalerFarmStatMultipleTeam - CoachInfo
Pro Team/League: TeamProInfo - TeamProFinance - TeamProStat - TeamProStatVS - TeamProLines - TeamProLinesNumberOnly - ProRivalryInfo - SchedulePro - PowerRankingPro - PlayoffPro - PlayoffProNumber - TeamLog
Farm Team/League: TeamFarmInfo - TeamFarmFinance - TeamFarmStat - TeamFarmStatVS - TeamFarmLines - TeamFarmLinesNumberOnly - FarmRivalryInfo - ScheduleFarm - PowerRankingFarm - PlayoffFarm - PlayoffFarmNumber
League: LeagueGeneral - LeagueSimulation - LeagueFinance - LeagueOutputOption - LeagueWebClient - DraftPick - Prospects - RankingOrder - LeagueLog - TodayGame - Waiver - WaiverOrder - WaiverSendTo - WaiverInterest - EntryDraft - EntryDraftProspectAvailable - LeagueNews - NextYearFreeAgent - Trade

PlayerInfo

Field NameField Data TypeInformation
Numberinteger primary keyMultiple of other tables Refer to table this field to get players information.
UniqueIDintegerThis field is not used to refer anything inside the database.
Namestring
URLLinkstring
NHLIDstring
TeamintegerRefer to table TeamProInfo table number field.
TeamNamestringPro Team Name or Farm Team Name with Pro Abbre base on next game line up.
Countrystring
AgeDatetimestamp
Ageinteger
Weightinteger
Heightinteger
PosCboolean
PosLWboolean
PosRWboolean
PosDboolean
Contractinteger
Rookieboolean
PProtectedboolean
NoApplyRerateboolean
AvailableforTradeboolean
NoTradeboolean
CanPlayProboolean
CanPlayFarmboolean
ForceWaiverboolean
ExcludeSalaryCapboolean
ProSalaryinFarmboolean
StarPowerinteger
SalaryAveragecurrency
Salary1currency
Salary2currency
Salary3currency
Salary4currency
Salary5currency
Salary6currency
Salary7currency
Salary8currency
Salary9currency
Salary10currency
SalaryRemainingcurrency
SalaryAverageRemainingcurrency
SalaryCapcurrencyShow the Player Salary Cap for the Entire Season. Injuries or suspension doesn’t impact this value.
SalaryCapRemainingcurrencyShow the Player Salary Cap for the Rest of the season. Injuries or suspension doesn’t impact this value.
Injurystring
NumberOfInjuryintegerNumber of Condition Point loss during the season
Conditioninteger
ConditionDecimalfloat
Suspensioninteger
Status1integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status2integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status3integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status4integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status5integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status6integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status7integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status8integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status9integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status10integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
CKinteger
FGinteger
DIinteger
SKinteger
STinteger
ENinteger
DUinteger
PHinteger
FOinteger
PAinteger
SCinteger
DFinteger
PSinteger
EXinteger
LDinteger
POinteger
MOinteger
Overallinteger
GameInRowWithAGoalinteger
GameInRowWithAPointinteger
GameInRowWithOutAGoalinteger
GameInRowWithOutAPointinteger
WebClientModifyboolean
AutoRosterCanPlayProboolean
AutoRosterCanPlayFarmboolean
Jerseyinteger

PlayerProStat

This table has « sister » table call PlayerProSeasonStat who will be fill only when you are in playoff mode with the regular season stat.

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table PlayerInfo table number field.
UniqueIDintegerSame as table UniqueID field in PlayerInfo.
NamestringSame as table Name field in PlayerInfo.
GPinteger
Shotsinteger
Ginteger
Ainteger
Pinteger
PlusMinusinteger
Piminteger
Pim5integerMajor Penalty
ShotsBlockinteger
OwnShotsBlockinteger
OwnShotsMissGoalinteger
Hitsinteger
HitsTookinteger
GWintegerWinning Goal
GTintegerTying Goal
FaceOffWoninteger
FaceOffTotalinteger
PenalityShotsScoreinteger
PenalityShotsTotalinteger
EmptyNetGoalinteger
SecondPlayinteger
HatTrickinteger
PPGinteger
PPAinteger
PPPinteger
PPShotsinteger
PPSecondPlayinteger
PKGinteger
PKAinteger
PKPinteger
PKShotsinteger
PKSecondPlayinteger
GiveAwayinteger
TakeAwayinteger
PuckPossesionTimeinteger
FightWinteger
FightLinteger
FightTinteger
Star1integer
Star2integer
Star3integer
StarPower7Daysinteger
StarPower30Daysinteger
StarPowerYearinteger
StarPowerGoal7Daysinteger
StarPowerAssist7Daysinteger
StarPowerGoal30Daysinteger
StarPowerAssist30Daysinteger

PlayerFarmStat

This table has « sister » table call PlayerFarmSeasonStat who will be fill only when you are in playoff mode with the regular season stat.

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table PlayerInfo table number field.
UniqueIDintegerSame as table UniqueID field in PlayerInfo.
NamestringSame as table Name field in PlayerInfo.
GPinteger
Shotsinteger
Ginteger
Ainteger
Pinteger
PlusMinusinteger
Piminteger
Pim5integerMajor Penalty
ShotsBlockinteger
OwnShotsBlockinteger
OwnShotsMissGoalinteger
Hitsinteger
HitsTookinteger
GWintegerWinning Goal
GTintegerTying Goal
FaceOffWoninteger
FaceOffTotalinteger
PenalityShotsScoreinteger
PenalityShotsTotalinteger
EmptyNetGoalinteger
SecondPlayinteger
HatTrickinteger
PPGinteger
PPAinteger
PPPinteger
PPShotsinteger
PPSecondPlayinteger
PKGinteger
PKAinteger
PKPinteger
PKShotsinteger
PKSecondPlayinteger
GiveAwayinteger
TakeAwayinteger
PuckPossesionTimeinteger
FightWinteger
FightLinteger
FightTinteger
Star1integer
Star2integer
Star3integer
StarPower7Daysinteger
StarPower30Daysinteger
StarPowerYearinteger
StarPowerGoal7Daysinteger
StarPowerAssist7Daysinteger
StarPowerGoal30Daysinteger
StarPowerAssist30Daysinteger

PlayerProStatMultipleTeam

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table PlayerInfo table number field.
UniqueIDintegerSame as table UniqueID field in PlayerInfo.
NamestringSame as table Name field in PlayerInfo.
TeamintegerRefer to table TeamProInfo table number field.
TeamNamestringPro Team Name
GPinteger
Shotsinteger
Ginteger
Ainteger
Pinteger
PlusMinusinteger
Piminteger
Pim5integerMajor Penalty
ShotsBlockinteger
OwnShotsBlockinteger
OwnShotsMissGoalinteger
Hitsinteger
HitsTookinteger
GWintegerWinning Goal
GTintegerTying Goal
FaceOffWoninteger
FaceOffTotalinteger
PenalityShotsScoreinteger
PenalityShotsTotalinteger
EmptyNetGoalinteger
SecondPlayinteger
HatTrickinteger
PPGinteger
PPAinteger
PPPinteger
PPShotsinteger
PPSecondPlayinteger
PKGinteger
PKAinteger
PKPinteger
PKShotsinteger
PKSecondPlayinteger
GiveAwayinteger
TakeAwayinteger
PuckPossesionTimeinteger
FightWinteger
FightLinteger
FightTinteger

PlayerFarmStatMultipleTeam

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table PlayerInfo table number field.
UniqueIDintegerSame as table UniqueID field in PlayerInfo.
NamestringSame as table Name field in PlayerInfo.
TeamintegerRefer to table TeamProInfo table number field.
TeamNamestringFarm Team Name
GPinteger
Shotsinteger
Ginteger
Ainteger
Pinteger
PlusMinusinteger
Piminteger
Pim5integerMajor Penalty
ShotsBlockinteger
OwnShotsBlockinteger
OwnShotsMissGoalinteger
Hitsinteger
HitsTookinteger
GWintegerWinning Goal
GTintegerTying Goal
FaceOffWoninteger
FaceOffTotalinteger
PenalityShotsScoreinteger
PenalityShotsTotalinteger
EmptyNetGoalinteger
SecondPlayinteger
HatTrickinteger
PPGinteger
PPAinteger
PPPinteger
PPShotsinteger
PPSecondPlayinteger
PKGinteger
PKAinteger
PKPinteger
PKShotsinteger
PKSecondPlayinteger
GiveAwayinteger
TakeAwayinteger
PuckPossesionTimeinteger
FightWinteger
FightLinteger
FightTinteger
Star1integer
Star2integer
Star3integer

GoalerInfo

Field NameField Data TypeInformation
Numberinteger primary keyMultiple of other tables Refer to table this field to get goalies information.
UniqueIDintegerThis field is not used to refer anything inside the database.
Namestring
URLLinkstring
NHLIDstring
TeamintegerRefer to table TeamProInfo table number field.
TeamNamestringPro Team Name or Farm Team Name with Pro Abbre base on next game line up.
Countrystring
AgeDatetimestamp
Ageinteger
Weightinteger
Heightinteger
PosGbooleanAlways True
Contractinteger
Rookieboolean
PProtectedboolean
NoApplyRerateboolean
AvailableforTradeboolean
NoTradeboolean
CanPlayProboolean
CanPlayFarmboolean
ForceWaiverboolean
ExcludeSalaryCapboolean
ProSalaryinFarmboolean
StarPowerinteger
SalaryAveragecurrency
Salary1currency
Salary2currency
Salary3currency
Salary4currency
Salary5currency
Salary6currency
Salary7currency
Salary8currency
Salary9currency
Salary10currency
SalaryRemainingcurrency
SalaryAverageRemainingcurrency
SalaryCapcurrencyShow the Player Salary Cap for the Entire Season. Injuries or suspension doesn’t impact this value.
SalaryCapRemainingcurrencyShow the Player Salary Cap for the Rest of the season. Injuries or suspension doesn’t impact this value.
Injurystring
InjuryDurationintegerNumber of Condition Point loss during the season
Conditioninteger
ConditionDecimalfloat
Suspensioninteger
Status1integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status2integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status3integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status4integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status5integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status6integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status7integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status8integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status9integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status10integer3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
SKinteger
DUinteger
ENinteger
SZinteger
AGinteger
RBinteger
SCinteger
HSinteger
RTinteger
PHinteger
PSinteger
EXinteger
LDinteger
POinteger
MOinteger
Overallinteger
WebClientModifyboolean
AutoRosterCanPlayProboolean
AutoRosterCanPlayFarmboolean
Jerseyinteger

GoalerProStat

This table has « sister » table call GoalerProSeasonStat who will be fill only when you are in playoff mode with the regular season stat.

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table GoalerInfo table number field.
UniqueIDintegerSame as table UniqueID field in GoalerInfo.
NamestringSame as table Name field in GoalerInfo.
GPinteger
SecondPlayinteger
Winteger
Linteger
OTLinteger
Shootoutinteger
GAinteger
SAinteger
SAReboundintegerRebound allow after a shot
Piminteger
AintegerAssist
PenalityShotsShotsinteger
PenalityShotsGoalsinteger
StartGoalerintegerNumber of game start as starting goalie
BackupGoalerintegerNumber of game start as backup goalie
EmptyNetGoalintegerNumber of goal score when goalie has left is goal
Star1integer
Star2integer
Star3integer
StarPower7Daysinteger
StarPower30Daysinteger
StarPowerYearinteger
StarPowerSA7Daysinteger
StarPowerGA7Daysinteger
StarPowerSA30Daysinteger
StarPowerGA30Daysinteger

GoalerFarmStat

This table has « sister » table call GoalerFarmSeasonStat who will be fill only when you are in playoff mode with the regular season stat.

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table GoalerInfo table number field.
UniqueIDintegerSame as table UniqueID field in GoalerInfo.
NamestringSame as table Name field in GoalerInfo.
GPinteger
SecondPlayinteger
Winteger
Linteger
OTLinteger
Shootoutinteger
GAinteger
SAinteger
SAReboundintegerRebound allow after a shot
Piminteger
AintegerAssist
PenalityShotsShotsinteger
PenalityShotsGoalsinteger
StartGoalerintegerNumber of game start as starting goalie
BackupGoalerintegerNumber of game start as backup goalie
EmptyNetGoalintegerNumber of goal score when goalie has left is goal
Star1integer
Star2integer
Star3integer
StarPower7Daysinteger
StarPower30Daysinteger
StarPowerYearinteger
StarPowerSA7Daysinteger
StarPowerGA7Daysinteger
StarPowerSA30Daysinteger
StarPowerGA30Daysinteger

GoalerProStatMultipleTeam

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table GoalerInfo table number field.
UniqueIDintegerSame as table UniqueID field in GoalerInfo.
NamestringSame as table Name field in GoalerInfo.
TeamintegerRefer to table TeamProInfo table number field.
TeamNamestringPro Team Name
GPinteger
SecondPlayinteger
Winteger
Linteger
OTLinteger
Shootoutinteger
GAinteger
SAinteger
SAReboundintegerRebound allow after a shot
Piminteger
AintegerAssist
PenalityShotsShotsinteger
PenalityShotsGoalsinteger
StartGoalerintegerNumber of game start as starting goalie
BackupGoalerintegerNumber of game start as backup goalie
EmptyNetGoalintegerNumber of goal score when goalie has left is goal

GoalerFarmStatMultipleTeam

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table GoalerInfo table number field.
UniqueIDintegerSame as table UniqueID field in GoalerInfo.
NamestringSame as table Name field in GoalerInfo.
TeamintegerRefer to table TeamProInfo table number field.
TeamNamestringFarm Team Name
GPinteger
SecondPlayinteger
Winteger
Linteger
OTLinteger
Shootoutinteger
GAinteger
SAinteger
SAReboundintegerRebound allow after a shot
Piminteger
AintegerAssist
PenalityShotsShotsinteger
PenalityShotsGoalsinteger
StartGoalerintegerNumber of game start as starting goalie
BackupGoalerintegerNumber of game start as backup goalie
EmptyNetGoalintegerNumber of goal score when goalie has left is goal

CoachInfo

Field NameField Data TypeInformation
Numberinteger primary key
Namestring
TeamintegerRefer to table TeamProInfo table number field.
Countrystring
Ageinteger
Contractinteger
Salarycurrency
PHinteger
DFinteger
OFinteger
PDinteger
EXinteger
LDinteger
POinteger
MOinteger

TeamProInfo

Field NameField Data TypeInformation
Numberinteger primary keyMultiple of other tables refer to table this field to get pro team information.
UniqueIDintegerThis field is not used to refer anything inside the database.
Namestring
Abbrestring
Citystring
GMNamestring
Messengerstring
Emailstring
Arenastring
Divisionstring
Conferencestring
CaptainintegerRefer to table PlayerInfo table number field.
Assistant1integerRefer to table PlayerInfo table number field.
Assistant2integerRefer to table PlayerInfo table number field.
CoachIDintegerRefer to table CoachInfo table number field.
Moraleinteger
TeamOverallinteger
PlayOffEliminatedboolean
PowerRankingintegerOnly update when PowerRanking HTML is output.
PlayOffWinRoundinteger
DidNotMakePlayoffboolean
LinesLoadinteger# of Load Lines
FailAutoRosterinteger# of Fail Auto Roster
FailProAutoLineinteger# of Fail Pro Auto Line
FailFarmAutoLineinteger# of Fail Farm Auto Line
FailSimulationinteger# of Fail Simulation
LastLoadFileDatestringLast Lines Send Date
WebPasswordstringCurrent team password Hash + Salt
WebClientModifyboolean

TeamProFinance

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table TeamProInfo table number field.
NamestringSame as table TeamProInfo table name field.
ArenaCapacityL1integer
ArenaCapacityL2integer
ArenaCapacityL3integer
ArenaCapacityL4integer
ArenaCapacityLuxuryinteger
TicketPriceL1integer
TicketPriceL2integer
TicketPriceL3integer
TicketPriceL4integer
TicketPriceLuxuryinteger
AttendanceL1integer
AttendanceL2integer
AttendanceL3integer
AttendanceL4integer
AttendanceLuxuryinteger
ScheduleGameInAYearinteger
ScheduleHomeGameInAYearinteger
SalaryCapToDatecurrency
SalaryCapPerDaycurrency
TotalPlayersSalariescurrency
TotalPlayersSalariesAveragecurrency
ExpensePerDaycurrency
EstimatedRevenuecurrency
EstimatedSeasonExpensecurrency
TotalSalaryCapcurrency
TotalAttendancecurrency
TotalIncomecurrency
ExpenseThisSeasoncurrency
SeasonTicketPCTinteger
TeamPopularityinteger
CurrentBankAccountcurrency
ProjectedBankAccountcurrency
SpecialSalaryCapY1currency
SpecialSalaryCapY2currency
SpecialSalaryCapY3currency
SpecialSalaryCapY4currency
SpecialSalaryCapY5currency
SpecialSalaryCapY6currency
SpecialSalaryCapY7currency
SpecialSalaryCapY8currency
SpecialSalaryCapY9currency
SpecialSalaryCapY10currency
LuxuryTaxeTotalcurrency
PlayerInSalaryCapintegerShow the number of player in the salary cap.
PlayerOutofSalaryCapintegerShow the number of player out the salary cap.
WebClientModifyboolean

TeamProStat

This table has « sister » table call TeamProSeasonStat who will be fill only when you are in playoff mode with the regular season stat. Some fields (Last10*, Shots and Goals per Period, Puck Time *, FaceOff*, StandingPlayoffTitle, Steak) will be always empty and/or with 0 as value.

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table TeamProInfo table number field.
NamestringSame as table TeamProInfo table name field.
Last10Winteger
Last10Linteger
Last10Tinteger
Last10OTWinteger
Last10OTLinteger
Last10SOWinteger
Last10SOLinteger
GPinteger
Winteger
Linteger
Tinteger
OTWinteger
OTLinteger
SOWinteger
SOLinteger
Pointsinteger
GFinteger
GAinteger
HomeGPinteger
HomeWinteger
HomeLinteger
HomeTinteger
HomeOTWinteger
HomeOTLinteger
HomeSOWinteger
HomeSOLinteger
HomeGFinteger
HomeGAinteger
StandingPlayoffTitlestring
Streakstring
PPAttempinteger
PPGoalinteger
PKAttempinteger
PKGoalGAinteger
PKGoalGFinteger
ShotsForinteger
ShotsAgainteger
ShotsBlockinteger
ShotsPerPeriod1integer
ShotsPerPeriod2integer
ShotsPerPeriod3integer
ShotsPerPeriod4integer
GoalsPerPeriod1integer
GoalsPerPeriod2integer
GoalsPerPeriod3integer
GoalsPerPeriod4integer
PuckTimeInZoneDFintegerIn Second
PuckTimeInZoneOFintegerIn Second
PuckTimeInZoneNTintegerIn Second
PuckTimeControlinZoneDFintegerIn Second
PuckTimeControlinZoneOFintegerIn Second
PuckTimeControlinZoneNTintegerIn Second
Shutoutsinteger
TotalGoalinteger
TotalAssistinteger
TotalPointinteger
Piminteger
Hitsinteger
FaceOffWonDefensifZoneinteger
FaceOffTotalDefensifZoneinteger
FaceOffWonOffensifZoneinteger
FaceOffTotalOffensifZoneinteger
FaceOffWonNeutralZoneinteger
FaceOffTotalNeutralZoneinteger
EmptyNetGoalinteger

TeamProStatVS

Field NameField Data TypeInformation
TeamNumberintegerRefer to table TeamProInfo table number field.
TeamNamestringSame as table TeamProInfo table name field.
TeamVSNumberintegerRefer to table TeamProInfo table number field.
TeamVSNamestringSame as table TeamProInfo table name field except 101 = 'VS Division', 102 = 'VS Conference', 103 = 'Since Last GM Reset'.
GPinteger
Winteger
Linteger
Tinteger
OTWinteger
OTLinteger
SOWinteger
SOLinteger
Pointsinteger
GFinteger
GAinteger
HomeGPinteger
HomeWinteger
HomeLinteger
HomeTinteger
HomeOTWinteger
HomeOTLinteger
HomeSOWinteger
HomeSOLinteger
HomeGFinteger
HomeGAinteger
StandingPlayoffTitlestring
Streakstring
PPAttempinteger
PPGoalinteger
PKAttempinteger
PKGoalGAinteger
PKGoalGFinteger
ShotsForinteger
ShotsAgainteger
ShotsBlockinteger
ShotsPerPeriod1integer
ShotsPerPeriod2integer
ShotsPerPeriod3integer
ShotsPerPeriod4integer
GoalsPerPeriod1integer
GoalsPerPeriod2integer
GoalsPerPeriod3integer
GoalsPerPeriod4integer
PuckTimeInZoneDFintegerIn Second
PuckTimeInZoneOFintegerIn Second
PuckTimeInZoneNTintegerIn Second
PuckTimeControlinZoneDFintegerIn Second
PuckTimeControlinZoneOFintegerIn Second
PuckTimeControlinZoneNTintegerIn Second
Shutoutsinteger
TotalGoalinteger
TotalAssistinteger
TotalPointinteger
Piminteger
Hitsinteger
FaceOffWonDefensifZoneinteger
FaceOffTotalDefensifZoneinteger
FaceOffWonOffensifZoneinteger
FaceOffTotalOffensifZoneinteger
FaceOffWonNeutralZoneinteger
FaceOffTotalNeutralZoneinteger
EmptyNetGoalinteger

TeamProLines

Field NameField Data TypeInformation
TeamNumberinteger Refer to table TeamProInfo table number field.
Dayinteger Number from 1 to 10
Line15vs5ForwardCenterstring
Line15vs5ForwardLeftWingstring
Line15vs5ForwardRightWingstring
Line15vs5ForwardTimeinteger
Line15vs5ForwardPhyinteger
Line15vs5ForwardDFinteger
Line15vs5ForwardOFinteger
Line15vs5DefenseDefense1string
Line15vs5DefenseDefense2string
Line15vs5DefenseTimeinteger
Line15vs5DefensePhyinteger
Line15vs5DefenseDFinteger
Line15vs5DefenseOFinteger
Line25vs5ForwardCenterstring
Line25vs5ForwardLeftWingstring
Line25vs5ForwardRightWingstring
Line25vs5ForwardTimeinteger
Line25vs5ForwardPhyinteger
Line25vs5ForwardDFinteger
Line25vs5ForwardOFinteger
Line25vs5DefenseDefense1string
Line25vs5DefenseDefense2string
Line25vs5DefenseTimeinteger
Line25vs5DefensePhyinteger
Line25vs5DefenseDFinteger
Line25vs5DefenseOFinteger
Line35vs5ForwardCenterstring
Line35vs5ForwardLeftWingstring
Line35vs5ForwardRightWingstring
Line35vs5ForwardTimeinteger
Line35vs5ForwardPhyinteger
Line35vs5ForwardDFinteger
Line35vs5ForwardOFinteger
Line35vs5DefenseDefense1string
Line35vs5DefenseDefense2string
Line35vs5DefenseTimeinteger
Line35vs5DefensePhyinteger
Line35vs5DefenseDFinteger
Line35vs5DefenseOFinteger
Line45vs5ForwardCenterstring
Line45vs5ForwardLeftWingstring
Line45vs5ForwardRightWingstring
Line45vs5ForwardTimeinteger
Line45vs5ForwardPhyinteger
Line45vs5ForwardDFinteger
Line45vs5ForwardOFinteger
Line45vs5DefenseDefense1string
Line45vs5DefenseDefense2string
Line45vs5DefenseTimeinteger
Line45vs5DefensePhyinteger
Line45vs5DefenseDFinteger
Line45vs5DefenseOFinteger
Line1PPForwardCenterstring
Line1PPForwardLeftWingstring
Line1PPForwardRightWingstring
Line1PPForwardTimeinteger
Line1PPForwardPhyinteger
Line1PPForwardDFinteger
Line1PPForwardOFinteger
Line1PPDefenseDefense1string
Line1PPDefenseDefense2string
Line1PPDefenseTimeinteger
Line1PPDefensePhyinteger
Line1PPDefenseDFinteger
Line1PPDefenseOFinteger
Line2PPForwardCenterstring
Line2PPForwardLeftWingstring
Line2PPForwardRightWingstring
Line2PPForwardTimeinteger
Line2PPForwardPhyinteger
Line2PPForwardDFinteger
Line2PPForwardOFinteger
Line2PPDefenseDefense1string
Line2PPDefenseDefense2string
Line2PPDefenseTimeinteger
Line2PPDefensePhyinteger
Line2PPDefenseDFinteger
Line2PPDefenseOFinteger
Line1PK4ForwardCenterstring
Line1PK4ForwardWingstring
Line1PK4ForwardTimeinteger
Line1PK4ForwardPhyinteger
Line1PK4ForwardDFinteger
Line1PK4ForwardOFinteger
Line1PK4DefenseDefense1string
Line1PK4DefenseDefense2string
Line1PK4DefenseTimeinteger
Line1PK4DefensePhyinteger
Line1PK4DefenseDFinteger
Line1PK4DefenseOFinteger
Line2PK4ForwardCenterstring
Line2PK4ForwardWingstring
Line2PK4ForwardTimeinteger
Line2PK4ForwardPhyinteger
Line2PK4ForwardDFinteger
Line2PK4ForwardOFinteger
Line2PK4DefenseDefense1string
Line2PK4DefenseDefense2string
Line2PK4DefenseTimeinteger
Line2PK4DefensePhyinteger
Line2PK4DefenseDFinteger
Line2PK4DefenseOFinteger
Line1PK3ForwardCenterstring
Line1PK3ForwardTimeinteger
Line1PK3ForwardPhyinteger
Line1PK3ForwardDFinteger
Line1PK3ForwardOFinteger
Line1PK3DefenseDefense1string
Line1PK3DefenseDefense2string
Line1PK3DefenseTimeinteger
Line1PK3DefensePhyinteger
Line1PK3DefenseDFinteger
Line1PK3DefenseOFinteger
Line2PK3ForwardCenterstring
Line2PK3ForwardTimeinteger
Line2PK3ForwardPhyinteger
Line2PK3ForwardDFinteger
Line2PK3ForwardOFinteger
Line2PK3DefenseDefense1string
Line2PK3DefenseDefense2string
Line2PK3DefenseTimeinteger
Line2PK3DefensePhyinteger
Line2PK3DefenseDFinteger
Line2PK3DefenseOFinteger
Line14VS4ForwardCenterstring
Line14VS4ForwardWingstring
Line14VS4ForwardTimeinteger
Line14VS4ForwardPhyinteger
Line14VS4ForwardDFinteger
Line14VS4ForwardOFinteger
Line14VS4DefenseDefense1string
Line14VS4DefenseDefense2string
Line14VS4DefenseTimeinteger
Line14VS4DefensePhyinteger
Line14VS4DefenseDFinteger
Line14VS4DefenseOFinteger
Line24VS4ForwardCenterstring
Line24VS4ForwardWingstring
Line24VS4ForwardTimeinteger
Line24VS4ForwardPhyinteger
Line24VS4ForwardDFinteger
Line24VS4ForwardOFinteger
Line24VS4DefenseDefense1string
Line24VS4DefenseDefense2string
Line24VS4DefenseTimeinteger
Line24VS4DefensePhyinteger
Line24VS4DefenseDFinteger
Line24VS4DefenseOFinteger
LastMinOffForwardCenterstring
LastMinOffForwardLeftWingstring
LastMinOffForwardRightWingstring
LastMinOffDefenseDefense1string
LastMinOffDefenseDefense2string
LastMinDefForwardCenterstring
LastMinDefForwardLeftWingstring
LastMinDefForwardRightWingstring
LastMinDefDefenseDefense1string
LastMinDefDefenseDefense2string
Goaler1string
Goaler2string
Goaler3string
ExtraForwardPKstring
ExtraForwardN1string
ExtraForwardN2string
ExtraForwardN3string
ExtraForwardPP1string
ExtraForwardPP2string
ExtraDefensePK2string
ExtraDefenseN1string
ExtraDefenseN2string
ExtraDefenseN3string
ExtraDefensePPstring
ExtraDefensePK1string
PenaltyShots1string
PenaltyShots2string
PenaltyShots3string
PenaltyShots4string
PenaltyShots5string
OTForward1string
OTForward2string
OTForward3string
OTForward4string
OTForward5string
OTForward6string
OTForward7string
OTForward8string
OTForward9string
OTForward10string
OTDefense1string
OTDefense2string
OTDefense3string
OTDefense4string
OTDefense5string
Strategy1GoalDiffintegerWinning by #1
Strategy1Phyinteger
Strategy1DFinteger
Strategy1OFinteger
Strategy2GoalDiffintegerWinning by #2
Strategy2Phyinteger
Strategy2DFinteger
Strategy2OFinteger
Strategy3PhyintegerScore is equal
Strategy3DFinteger
Strategy3OFinteger
Strategy4GoalDiffintegerLosing by #1
Strategy4Phyinteger
Strategy4DFinteger
Strategy4OFinteger
Strategy5GoalDiffintegerLosing by #1
Strategy5Phyinteger
Strategy5DFinteger
Strategy5OFinteger
PullGoalerMinPctinteger
PullGoalerMinGoalinteger
RemoveGoaliesSecondinteger

TeamProLinesNumberOnly

Field NameField Data TypeInformation
TeamNumberintegerRefer to table TeamProInfo table number field.
DayintegerNumber from 1 to 10
Line15vs5ForwardCenterintegerRefer to table PlayerInfo table number field.
Line15vs5ForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line15vs5ForwardRightWingintegerRefer to table PlayerInfo table number field.
Line15vs5ForwardTimeinteger
Line15vs5ForwardPhyinteger
Line15vs5ForwardDFinteger
Line15vs5ForwardOFinteger
Line15vs5DefenseDefense1integerRefer to table PlayerInfo table number field.
Line15vs5DefenseDefense2integerRefer to table PlayerInfo table number field.
Line15vs5DefenseTimeinteger
Line15vs5DefensePhyinteger
Line15vs5DefenseDFinteger
Line15vs5DefenseOFinteger
Line25vs5ForwardCenterintegerRefer to table PlayerInfo table number field.
Line25vs5ForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line25vs5ForwardRightWingintegerRefer to table PlayerInfo table number field.
Line25vs5ForwardTimeinteger
Line25vs5ForwardPhyinteger
Line25vs5ForwardDFinteger
Line25vs5ForwardOFinteger
Line25vs5DefenseDefense1integerRefer to table PlayerInfo table number field.
Line25vs5DefenseDefense2integerRefer to table PlayerInfo table number field.
Line25vs5DefenseTimeinteger
Line25vs5DefensePhyinteger
Line25vs5DefenseDFinteger
Line25vs5DefenseOFinteger
Line35vs5ForwardCenterintegerRefer to table PlayerInfo table number field.
Line35vs5ForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line35vs5ForwardRightWingintegerRefer to table PlayerInfo table number field.
Line35vs5ForwardTimeinteger
Line35vs5ForwardPhyinteger
Line35vs5ForwardDFinteger
Line35vs5ForwardOFinteger
Line35vs5DefenseDefense1integerRefer to table PlayerInfo table number field.
Line35vs5DefenseDefense2integerRefer to table PlayerInfo table number field.
Line35vs5DefenseTimeinteger
Line35vs5DefensePhyinteger
Line35vs5DefenseDFinteger
Line35vs5DefenseOFinteger
Line45vs5ForwardCenterintegerRefer to table PlayerInfo table number field.
Line45vs5ForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line45vs5ForwardRightWingintegerRefer to table PlayerInfo table number field.
Line45vs5ForwardTimeinteger
Line45vs5ForwardPhyinteger
Line45vs5ForwardDFinteger
Line45vs5ForwardOFinteger
Line45vs5DefenseDefense1integerRefer to table PlayerInfo table number field.
Line45vs5DefenseDefense2integerRefer to table PlayerInfo table number field.
Line45vs5DefenseTimeinteger
Line45vs5DefensePhyinteger
Line45vs5DefenseDFinteger
Line45vs5DefenseOFinteger
Line1PPForwardCenterintegerRefer to table PlayerInfo table number field.
Line1PPForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line1PPForwardRightWingintegerRefer to table PlayerInfo table number field.
Line1PPForwardTimeinteger
Line1PPForwardPhyinteger
Line1PPForwardDFinteger
Line1PPForwardOFinteger
Line1PPDefenseDefense1integerRefer to table PlayerInfo table number field.
Line1PPDefenseDefense2integerRefer to table PlayerInfo table number field.
Line1PPDefenseTimeinteger
Line1PPDefensePhyinteger
Line1PPDefenseDFinteger
Line1PPDefenseOFinteger
Line2PPForwardCenterintegerRefer to table PlayerInfo table number field.
Line2PPForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line2PPForwardRightWingintegerRefer to table PlayerInfo table number field.
Line2PPForwardTimeinteger
Line2PPForwardPhyinteger
Line2PPForwardDFinteger
Line2PPForwardOFinteger
Line2PPDefenseDefense1integerRefer to table PlayerInfo table number field.
Line2PPDefenseDefense2integerRefer to table PlayerInfo table number field.
Line2PPDefenseTimeinteger
Line2PPDefensePhyinteger
Line2PPDefenseDFinteger
Line2PPDefenseOFinteger
Line1PK4ForwardCenterintegerRefer to table PlayerInfo table number field.
Line1PK4ForwardWingintegerRefer to table PlayerInfo table number field.
Line1PK4ForwardTimeinteger
Line1PK4ForwardPhyinteger
Line1PK4ForwardDFinteger
Line1PK4ForwardOFinteger
Line1PK4DefenseDefense1integerRefer to table PlayerInfo table number field.
Line1PK4DefenseDefense2integerRefer to table PlayerInfo table number field.
Line1PK4DefenseTimeinteger
Line1PK4DefensePhyinteger
Line1PK4DefenseDFinteger
Line1PK4DefenseOFinteger
Line2PK4ForwardCenterintegerRefer to table PlayerInfo table number field.
Line2PK4ForwardWingintegerRefer to table PlayerInfo table number field.
Line2PK4ForwardTimeinteger
Line2PK4ForwardPhyinteger
Line2PK4ForwardDFinteger
Line2PK4ForwardOFinteger
Line2PK4DefenseDefense1integerRefer to table PlayerInfo table number field.
Line2PK4DefenseDefense2integerRefer to table PlayerInfo table number field.
Line2PK4DefenseTimeinteger
Line2PK4DefensePhyinteger
Line2PK4DefenseDFinteger
Line2PK4DefenseOFinteger
Line1PK3ForwardCenterintegerRefer to table PlayerInfo table number field.
Line1PK3ForwardTimeinteger
Line1PK3ForwardPhyinteger
Line1PK3ForwardDFinteger
Line1PK3ForwardOFinteger
Line1PK3DefenseDefense1integerRefer to table PlayerInfo table number field.
Line1PK3DefenseDefense2integerRefer to table PlayerInfo table number field.
Line1PK3DefenseTimeinteger
Line1PK3DefensePhyinteger
Line1PK3DefenseDFinteger
Line1PK3DefenseOFinteger
Line2PK3ForwardCenterintegerRefer to table PlayerInfo table number field.
Line2PK3ForwardTimeinteger
Line2PK3ForwardPhyinteger
Line2PK3ForwardDFinteger
Line2PK3ForwardOFinteger
Line2PK3DefenseDefense1integerRefer to table PlayerInfo table number field.
Line2PK3DefenseDefense2integerRefer to table PlayerInfo table number field.
Line2PK3DefenseTimeinteger
Line2PK3DefensePhyinteger
Line2PK3DefenseDFinteger
Line2PK3DefenseOFinteger
Line14VS4ForwardCenterintegerRefer to table PlayerInfo table number field.
Line14VS4ForwardWingintegerRefer to table PlayerInfo table number field.
Line14VS4ForwardTimeinteger
Line14VS4ForwardPhyinteger
Line14VS4ForwardDFinteger
Line14VS4ForwardOFinteger
Line14VS4DefenseDefense1integerRefer to table PlayerInfo table number field.
Line14VS4DefenseDefense2integerRefer to table PlayerInfo table number field.
Line14VS4DefenseTimeinteger
Line14VS4DefensePhyinteger
Line14VS4DefenseDFinteger
Line14VS4DefenseOFinteger
Line24VS4ForwardCenterintegerRefer to table PlayerInfo table number field.
Line24VS4ForwardWingintegerRefer to table PlayerInfo table number field.
Line24VS4ForwardTimeinteger
Line24VS4ForwardPhyinteger
Line24VS4ForwardDFinteger
Line24VS4ForwardOFinteger
Line24VS4DefenseDefense1integerRefer to table PlayerInfo table number field.
Line24VS4DefenseDefense2integerRefer to table PlayerInfo table number field.
Line24VS4DefenseTimeinteger
Line24VS4DefensePhyinteger
Line24VS4DefenseDFinteger
Line24VS4DefenseOFinteger
LastMinOffForwardCenterintegerRefer to table PlayerInfo table number field.
LastMinOffForwardLeftWingintegerRefer to table PlayerInfo table number field.
LastMinOffForwardRightWingintegerRefer to table PlayerInfo table number field.
LastMinOffDefenseDefense1integerRefer to table PlayerInfo table number field.
LastMinOffDefenseDefense2integerRefer to table PlayerInfo table number field.
LastMinDefForwardCenterintegerRefer to table PlayerInfo table number field.
LastMinDefForwardLeftWingintegerRefer to table PlayerInfo table number field.
LastMinDefForwardRightWingintegerRefer to table PlayerInfo table number field.
LastMinDefDefenseDefense1integerRefer to table PlayerInfo table number field.
LastMinDefDefenseDefense2integerRefer to table PlayerInfo table number field.
Goaler1integerRefer to table GoalerInfo table number field.
Goaler2integerRefer to table GoalerInfo table number field.
Goaler3integerRefer to table GoalerInfo table number field.
ExtraForwardPKintegerRefer to table PlayerInfo table number field.
ExtraForwardN1integerRefer to table PlayerInfo table number field.
ExtraForwardN2integerRefer to table PlayerInfo table number field.
ExtraForwardN3integerRefer to table PlayerInfo table number field.
ExtraForwardPP1integerRefer to table PlayerInfo table number field.
ExtraForwardPP2integerRefer to table PlayerInfo table number field.
ExtraDefensePK2integerRefer to table PlayerInfo table number field.
ExtraDefenseN1integerRefer to table PlayerInfo table number field.
ExtraDefenseN2integerRefer to table PlayerInfo table number field.
ExtraDefenseN3integerRefer to table PlayerInfo table number field.
ExtraDefensePPintegerRefer to table PlayerInfo table number field.
ExtraDefensePK1integerRefer to table PlayerInfo table number field.
PenaltyShots1integerRefer to table PlayerInfo table number field.
PenaltyShots2integerRefer to table PlayerInfo table number field.
PenaltyShots3integerRefer to table PlayerInfo table number field.
PenaltyShots4integerRefer to table PlayerInfo table number field.
PenaltyShots5integerRefer to table PlayerInfo table number field.
OTForward1integerRefer to table PlayerInfo table number field.
OTForward2integerRefer to table PlayerInfo table number field.
OTForward3integerRefer to table PlayerInfo table number field.
OTForward4integerRefer to table PlayerInfo table number field.
OTForward5integerRefer to table PlayerInfo table number field.
OTForward6integerRefer to table PlayerInfo table number field.
OTForward7integerRefer to table PlayerInfo table number field.
OTForward8integerRefer to table PlayerInfo table number field.
OTForward9integerRefer to table PlayerInfo table number field.
OTForward10integerRefer to table PlayerInfo table number field.
OTDefense1integerRefer to table PlayerInfo table number field.
OTDefense2integerRefer to table PlayerInfo table number field.
OTDefense3integerRefer to table PlayerInfo table number field.
OTDefense4integerRefer to table PlayerInfo table number field.
OTDefense5integerRefer to table PlayerInfo table number field.
Strategy1GoalDiffintegerWinning by #1
Strategy1Phyinteger
Strategy1DFinteger
Strategy1OFinteger
Strategy2GoalDiffintegerWinning by #2
Strategy2Phyinteger
Strategy2DFinteger
Strategy2OFinteger
Strategy3PhyintegerScore is equal
Strategy3DFinteger
Strategy3OFinteger
Strategy4GoalDiffintegerLosing by #1
Strategy4Phyinteger
Strategy4DFinteger
Strategy4OFinteger
Strategy5GoalDiffintegerLosing by #1
Strategy5Phyinteger
Strategy5DFinteger
Strategy5OFinteger
PullGoalerMinPctinteger
PullGoalerMinGoalinteger
RemoveGoaliesSecondinteger
WebClientModifyboolean

TeamFarmInfo

Field NameField Data TypeInformation
Numberinteger primary keyMultiple of other tables Refer to table this field to get farm team information. The Farm Team Number is the always the same than the Pro Team Number.
UniqueIDintegerThis field is not used to refer anything inside the database.
NamestringSame as table TeamFarmInfo table name field.
Abbrestring
Citystring
Divisionstring
Conferencestring
CaptainintegerRefer to table PlayerInfo table number field.
Assistant1integerRefer to table PlayerInfo table number field.
Assistant2integerRefer to table PlayerInfo table number field.
CoachIDintegerRefer to table CoachInfo table number field.
Moraleinteger
TeamOverallinteger
PlayOffEliminatedboolean
PowerRankingintegerOnly update when PowerRanking HTML is output.
PlayOffWinRoundinteger
FullFarmboolean
DidNotMakePlayoffboolean
WebClientModifyboolean

TeamFarmFinance

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table TeamFarmInfo table number field.
NamestringSame as table TeamFarmInfo table name field.
ArenaCapacityL1integer
ArenaCapacityL2integer
TicketPriceL1integer
TicketPriceL2integer
AttendanceL1integer
AttendanceL2integer
ScheduleGameInAYearinteger
ScheduleHomeGameInAYearinteger
SalaryCapToDatecurrency
SalaryCapPerDaycurrency
TotalPlayersSalariescurrency
TotalPlayersSalariesAveragecurrency
ExpensePerDaycurrency
EstimatedRevenuecurrency
EstimatedSeasonExpensecurrency
TotalAttendancecurrency
TotalIncomecurrency
ExpenseThisSeasoncurrency
SeasonTicketPCTinteger
TeamPopularityinteger
PlayerInSalaryCapintegerShow the number of player in the salary cap.
PlayerOutofSalaryCapintegerShow the number of player out the salary cap.
WebClientModifyboolean

TeamFarmStat

This table has « sister » table call TeamFarmSeasonStat who will be fill only when you are in playoff mode with the regular season stat. Some fields (Last10*, Shots and Goals per Period, Puck Time *, FaceOff*, StandingPlayoffTitle, Steak) will be always empty and/or with 0 as value.

Field NameField Data TypeInformation
Numberinteger primary keyRefer to table TeamFarmInfo table number field.
NamestringSame as table TeamFarmInfo table name field.
Last10Winteger
Last10Linteger
Last10Tinteger
Last10OTWinteger
Last10OTLinteger
Last10SOWinteger
Last10SOLinteger
GPinteger
Winteger
Linteger
Tinteger
OTWinteger
OTLinteger
SOWinteger
SOLinteger
Pointsinteger
GFinteger
GAinteger
HomeGPinteger
HomeWinteger
HomeLinteger
HomeTinteger
HomeOTWinteger
HomeOTLinteger
HomeSOWinteger
HomeSOLinteger
HomeGFinteger
HomeGAinteger
StandingPlayoffTitlestring
Streakstring
PPAttempinteger
PPGoalinteger
PKAttempinteger
PKGoalGAinteger
PKGoalGFinteger
ShotsForinteger
ShotsAgainteger
ShotsBlockinteger
ShotsPerPeriod1integer
ShotsPerPeriod2integer
ShotsPerPeriod3integer
ShotsPerPeriod4integer
GoalsPerPeriod1integer
GoalsPerPeriod2integer
GoalsPerPeriod3integer
GoalsPerPeriod4integer
PuckTimeInZoneDFintegerIn Second
PuckTimeInZoneOFintegerIn Second
PuckTimeInZoneNTintegerIn Second
PuckTimeControlinZoneDFintegerIn Second
PuckTimeControlinZoneOFintegerIn Second
PuckTimeControlinZoneNTintegerIn Second
Shutoutsinteger
TotalGoalinteger
TotalAssistinteger
TotalPointinteger
Piminteger
Hitsinteger
FaceOffWonDefensifZoneinteger
FaceOffTotalDefensifZoneinteger
FaceOffWonOffensifZoneinteger
FaceOffTotalOffensifZoneinteger
FaceOffWonNeutralZoneinteger
FaceOffTotalNeutralZoneinteger
EmptyNetGoalinteger

TeamFarmStatVS

Field NameField Data TypeInformation
TeamNumberintegerRefer to table TeamFarmInfo table number field.
TeamNamestringSame as table TeamFarmInfo table name field.
TeamVSNumberintegerRefer to table TeamFarmInfo table number field.
TeamVSNamestringSame as table TeamFarmInfo table name field except 101 = 'VS Division', 102 = 'VS Conference', 103 = 'Since Last GM Reset'.
GPinteger
Winteger
Linteger
Tinteger
OTWinteger
OTLinteger
SOWinteger
SOLinteger
Pointsinteger
GFinteger
GAinteger
HomeGPinteger
HomeWinteger
HomeLinteger
HomeTinteger
HomeOTWinteger
HomeOTLinteger
HomeSOWinteger
HomeSOLinteger
HomeGFinteger
HomeGAinteger
StandingPlayoffTitlestring
Streakstring
PPAttempinteger
PPGoalinteger
PKAttempinteger
PKGoalGAinteger
PKGoalGFinteger
ShotsForinteger
ShotsAgainteger
ShotsBlockinteger
ShotsPerPeriod1integer
ShotsPerPeriod2integer
ShotsPerPeriod3integer
ShotsPerPeriod4integer
GoalsPerPeriod1integer
GoalsPerPeriod2integer
GoalsPerPeriod3integer
GoalsPerPeriod4integer
PuckTimeInZoneDFintegerIn Second
PuckTimeInZoneOFintegerIn Second
PuckTimeInZoneNTintegerIn Second
PuckTimeControlinZoneDFintegerIn Second
PuckTimeControlinZoneOFintegerIn Second
PuckTimeControlinZoneNTintegerIn Second
Shutoutsinteger
TotalGoalinteger
TotalAssistinteger
TotalPointinteger
Piminteger
Hitsinteger
FaceOffWonDefensifZoneinteger
FaceOffTotalDefensifZoneinteger
FaceOffWonOffensifZoneinteger
FaceOffTotalOffensifZoneinteger
FaceOffWonNeutralZoneinteger
FaceOffTotalNeutralZoneinteger
EmptyNetGoalinteger

TeamFarmLines

Field NameField Data TypeInformation
TeamNumberinteger Refer to table TeamFarmInfo table number field.
Dayinteger Number from 1 to 10
Line15vs5ForwardCenterstring
Line15vs5ForwardLeftWingstring
Line15vs5ForwardRightWingstring
Line15vs5ForwardTimeinteger
Line15vs5ForwardPhyinteger
Line15vs5ForwardDFinteger
Line15vs5ForwardOFinteger
Line15vs5DefenseDefense1string
Line15vs5DefenseDefense2string
Line15vs5DefenseTimeinteger
Line15vs5DefensePhyinteger
Line15vs5DefenseDFinteger
Line15vs5DefenseOFinteger
Line25vs5ForwardCenterstring
Line25vs5ForwardLeftWingstring
Line25vs5ForwardRightWingstring
Line25vs5ForwardTimeinteger
Line25vs5ForwardPhyinteger
Line25vs5ForwardDFinteger
Line25vs5ForwardOFinteger
Line25vs5DefenseDefense1string
Line25vs5DefenseDefense2string
Line25vs5DefenseTimeinteger
Line25vs5DefensePhyinteger
Line25vs5DefenseDFinteger
Line25vs5DefenseOFinteger
Line35vs5ForwardCenterstring
Line35vs5ForwardLeftWingstring
Line35vs5ForwardRightWingstring
Line35vs5ForwardTimeinteger
Line35vs5ForwardPhyinteger
Line35vs5ForwardDFinteger
Line35vs5ForwardOFinteger
Line35vs5DefenseDefense1string
Line35vs5DefenseDefense2string
Line35vs5DefenseTimeinteger
Line35vs5DefensePhyinteger
Line35vs5DefenseDFinteger
Line35vs5DefenseOFinteger
Line45vs5ForwardCenterstring
Line45vs5ForwardLeftWingstring
Line45vs5ForwardRightWingstring
Line45vs5ForwardTimeinteger
Line45vs5ForwardPhyinteger
Line45vs5ForwardDFinteger
Line45vs5ForwardOFinteger
Line45vs5DefenseDefense1string
Line45vs5DefenseDefense2string
Line45vs5DefenseTimeinteger
Line45vs5DefensePhyinteger
Line45vs5DefenseDFinteger
Line45vs5DefenseOFinteger
Line1PPForwardCenterstring
Line1PPForwardLeftWingstring
Line1PPForwardRightWingstring
Line1PPForwardTimeinteger
Line1PPForwardPhyinteger
Line1PPForwardDFinteger
Line1PPForwardOFinteger
Line1PPDefenseDefense1string
Line1PPDefenseDefense2string
Line1PPDefenseTimeinteger
Line1PPDefensePhyinteger
Line1PPDefenseDFinteger
Line1PPDefenseOFinteger
Line2PPForwardCenterstring
Line2PPForwardLeftWingstring
Line2PPForwardRightWingstring
Line2PPForwardTimeinteger
Line2PPForwardPhyinteger
Line2PPForwardDFinteger
Line2PPForwardOFinteger
Line2PPDefenseDefense1string
Line2PPDefenseDefense2string
Line2PPDefenseTimeinteger
Line2PPDefensePhyinteger
Line2PPDefenseDFinteger
Line2PPDefenseOFinteger
Line1PK4ForwardCenterstring
Line1PK4ForwardWingstring
Line1PK4ForwardTimeinteger
Line1PK4ForwardPhyinteger
Line1PK4ForwardDFinteger
Line1PK4ForwardOFinteger
Line1PK4DefenseDefense1string
Line1PK4DefenseDefense2string
Line1PK4DefenseTimeinteger
Line1PK4DefensePhyinteger
Line1PK4DefenseDFinteger
Line1PK4DefenseOFinteger
Line2PK4ForwardCenterstring
Line2PK4ForwardWingstring
Line2PK4ForwardTimeinteger
Line2PK4ForwardPhyinteger
Line2PK4ForwardDFinteger
Line2PK4ForwardOFinteger
Line2PK4DefenseDefense1string
Line2PK4DefenseDefense2string
Line2PK4DefenseTimeinteger
Line2PK4DefensePhyinteger
Line2PK4DefenseDFinteger
Line2PK4DefenseOFinteger
Line1PK3ForwardCenterstring
Line1PK3ForwardTimeinteger
Line1PK3ForwardPhyinteger
Line1PK3ForwardDFinteger
Line1PK3ForwardOFinteger
Line1PK3DefenseDefense1string
Line1PK3DefenseDefense2string
Line1PK3DefenseTimeinteger
Line1PK3DefensePhyinteger
Line1PK3DefenseDFinteger
Line1PK3DefenseOFinteger
Line2PK3ForwardCenterstring
Line2PK3ForwardTimeinteger
Line2PK3ForwardPhyinteger
Line2PK3ForwardDFinteger
Line2PK3ForwardOFinteger
Line2PK3DefenseDefense1string
Line2PK3DefenseDefense2string
Line2PK3DefenseTimeinteger
Line2PK3DefensePhyinteger
Line2PK3DefenseDFinteger
Line2PK3DefenseOFinteger
Line14VS4ForwardCenterstring
Line14VS4ForwardWingstring
Line14VS4ForwardTimeinteger
Line14VS4ForwardPhyinteger
Line14VS4ForwardDFinteger
Line14VS4ForwardOFinteger
Line14VS4DefenseDefense1string
Line14VS4DefenseDefense2string
Line14VS4DefenseTimeinteger
Line14VS4DefensePhyinteger
Line14VS4DefenseDFinteger
Line14VS4DefenseOFinteger
Line24VS4ForwardCenterstring
Line24VS4ForwardWingstring
Line24VS4ForwardTimeinteger
Line24VS4ForwardPhyinteger
Line24VS4ForwardDFinteger
Line24VS4ForwardOFinteger
Line24VS4DefenseDefense1string
Line24VS4DefenseDefense2string
Line24VS4DefenseTimeinteger
Line24VS4DefensePhyinteger
Line24VS4DefenseDFinteger
Line24VS4DefenseOFinteger
LastMinOffForwardCenterstring
LastMinOffForwardLeftWingstring
LastMinOffForwardRightWingstring
LastMinOffDefenseDefense1string
LastMinOffDefenseDefense2string
LastMinDefForwardCenterstring
LastMinDefForwardLeftWingstring
LastMinDefForwardRightWingstring
LastMinDefDefenseDefense1string
LastMinDefDefenseDefense2string
Goaler1string
Goaler2string
Goaler3string
ExtraForwardPKstring
ExtraForwardN1string
ExtraForwardN2string
ExtraForwardN3string
ExtraForwardPP1string
ExtraForwardPP2string
ExtraDefensePK2string
ExtraDefenseN1string
ExtraDefenseN2string
ExtraDefenseN3string
ExtraDefensePPstring
ExtraDefensePK1string
PenaltyShots1string
PenaltyShots2string
PenaltyShots3string
PenaltyShots4string
PenaltyShots5string
OTForward1string
OTForward2string
OTForward3string
OTForward4string
OTForward5string
OTForward6string
OTForward7string
OTForward8string
OTForward9string
OTForward10string
OTDefense1string
OTDefense2string
OTDefense3string
OTDefense4string
OTDefense5string
Strategy1GoalDiffintegerWinning by #1
Strategy1Phyinteger
Strategy1DFinteger
Strategy1OFinteger
Strategy2GoalDiffintegerWinning by #2
Strategy2Phyinteger
Strategy2DFinteger
Strategy2OFinteger
Strategy3PhyintegerScore is equal
Strategy3DFinteger
Strategy3OFinteger
Strategy4GoalDiffintegerLosing by #1
Strategy4Phyinteger
Strategy4DFinteger
Strategy4OFinteger
Strategy5GoalDiffintegerLosing by #1
Strategy5Phyinteger
Strategy5DFinteger
Strategy5OFinteger
PullGoalerMinPctinteger
PullGoalerMinGoalinteger
RemoveGoaliesSecondinteger

TeamFarmLinesNumberOnly

Field NameField Data TypeInformation
TeamNumberinteger Refer to table TeamFarmInfo table number field.
Dayinteger Number from 1 to 10
Line15vs5ForwardCenterintegerRefer to table PlayerInfo table number field.
Line15vs5ForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line15vs5ForwardRightWingintegerRefer to table PlayerInfo table number field.
Line15vs5ForwardTimeinteger
Line15vs5ForwardPhyinteger
Line15vs5ForwardDFinteger
Line15vs5ForwardOFinteger
Line15vs5DefenseDefense1integerRefer to table PlayerInfo table number field.
Line15vs5DefenseDefense2integerRefer to table PlayerInfo table number field.
Line15vs5DefenseTimeinteger
Line15vs5DefensePhyinteger
Line15vs5DefenseDFinteger
Line15vs5DefenseOFinteger
Line25vs5ForwardCenterintegerRefer to table PlayerInfo table number field.
Line25vs5ForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line25vs5ForwardRightWingintegerRefer to table PlayerInfo table number field.
Line25vs5ForwardTimeinteger
Line25vs5ForwardPhyinteger
Line25vs5ForwardDFinteger
Line25vs5ForwardOFinteger
Line25vs5DefenseDefense1integerRefer to table PlayerInfo table number field.
Line25vs5DefenseDefense2integerRefer to table PlayerInfo table number field.
Line25vs5DefenseTimeinteger
Line25vs5DefensePhyinteger
Line25vs5DefenseDFinteger
Line25vs5DefenseOFinteger
Line35vs5ForwardCenterintegerRefer to table PlayerInfo table number field.
Line35vs5ForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line35vs5ForwardRightWingintegerRefer to table PlayerInfo table number field.
Line35vs5ForwardTimeinteger
Line35vs5ForwardPhyinteger
Line35vs5ForwardDFinteger
Line35vs5ForwardOFinteger
Line35vs5DefenseDefense1integerRefer to table PlayerInfo table number field.
Line35vs5DefenseDefense2integerRefer to table PlayerInfo table number field.
Line35vs5DefenseTimeinteger
Line35vs5DefensePhyinteger
Line35vs5DefenseDFinteger
Line35vs5DefenseOFinteger
Line45vs5ForwardCenterintegerRefer to table PlayerInfo table number field.
Line45vs5ForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line45vs5ForwardRightWingintegerRefer to table PlayerInfo table number field.
Line45vs5ForwardTimeinteger
Line45vs5ForwardPhyinteger
Line45vs5ForwardDFinteger
Line45vs5ForwardOFinteger
Line45vs5DefenseDefense1integerRefer to table PlayerInfo table number field.
Line45vs5DefenseDefense2integerRefer to table PlayerInfo table number field.
Line45vs5DefenseTimeinteger
Line45vs5DefensePhyinteger
Line45vs5DefenseDFinteger
Line45vs5DefenseOFinteger
Line1PPForwardCenterintegerRefer to table PlayerInfo table number field.
Line1PPForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line1PPForwardRightWingintegerRefer to table PlayerInfo table number field.
Line1PPForwardTimeinteger
Line1PPForwardPhyinteger
Line1PPForwardDFinteger
Line1PPForwardOFinteger
Line1PPDefenseDefense1integerRefer to table PlayerInfo table number field.
Line1PPDefenseDefense2integerRefer to table PlayerInfo table number field.
Line1PPDefenseTimeinteger
Line1PPDefensePhyinteger
Line1PPDefenseDFinteger
Line1PPDefenseOFinteger
Line2PPForwardCenterintegerRefer to table PlayerInfo table number field.
Line2PPForwardLeftWingintegerRefer to table PlayerInfo table number field.
Line2PPForwardRightWingintegerRefer to table PlayerInfo table number field.
Line2PPForwardTimeinteger
Line2PPForwardPhyinteger
Line2PPForwardDFinteger
Line2PPForwardOFinteger
Line2PPDefenseDefense1integerRefer to table PlayerInfo table number field.
Line2PPDefenseDefense2integerRefer to table PlayerInfo table number field.
Line2PPDefenseTimeinteger
Line2PPDefensePhyinteger
Line2PPDefenseDFinteger
Line2PPDefenseOFinteger
Line1PK4ForwardCenterintegerRefer to table PlayerInfo table number field.
Line1PK4ForwardWingintegerRefer to table PlayerInfo table number field.
Line1PK4ForwardTimeinteger
Line1PK4ForwardPhyinteger
Line1PK4ForwardDFinteger
Line1PK4ForwardOFinteger
Line1PK4DefenseDefense1integerRefer to table PlayerInfo table number field.
Line1PK4DefenseDefense2integerRefer to table PlayerInfo table number field.
Line1PK4DefenseTimeinteger
Line1PK4DefensePhyinteger
Line1PK4DefenseDFinteger
Line1PK4DefenseOFinteger
Line2PK4ForwardCenterintegerRefer to table PlayerInfo table number field.
Line2PK4ForwardWingintegerRefer to table PlayerInfo table number field.
Line2PK4ForwardTimeinteger
Line2PK4ForwardPhyinteger
Line2PK4ForwardDFinteger
Line2PK4ForwardOFinteger
Line2PK4DefenseDefense1integerRefer to table PlayerInfo table number field.
Line2PK4DefenseDefense2integerRefer to table PlayerInfo table number field.
Line2PK4DefenseTimeinteger
Line2PK4DefensePhyinteger
Line2PK4DefenseDFinteger
Line2PK4DefenseOFinteger
Line1PK3ForwardCenterintegerRefer to table PlayerInfo table number field.
Line1PK3ForwardTimeinteger
Line1PK3ForwardPhyinteger
Line1PK3ForwardDFinteger
Line1PK3ForwardOFinteger
Line1PK3DefenseDefense1integerRefer to table PlayerInfo table number field.
Line1PK3DefenseDefense2integerRefer to table PlayerInfo table number field.
Line1PK3DefenseTimeinteger
Line1PK3DefensePhyinteger
Line1PK3DefenseDFinteger
Line1PK3DefenseOFinteger
Line2PK3ForwardCenterintegerRefer to table PlayerInfo table number field.
Line2PK3ForwardTimeinteger
Line2PK3ForwardPhyinteger
Line2PK3ForwardDFinteger
Line2PK3ForwardOFinteger
Line2PK3DefenseDefense1integerRefer to table PlayerInfo table number field.
Line2PK3DefenseDefense2integerRefer to table PlayerInfo table number field.
Line2PK3DefenseTimeinteger
Line2PK3DefensePhyinteger
Line2PK3DefenseDFinteger
Line2PK3DefenseOFinteger
Line14VS4ForwardCenterintegerRefer to table PlayerInfo table number field.
Line14VS4ForwardWingintegerRefer to table PlayerInfo table number field.
Line14VS4ForwardTimeinteger
Line14VS4ForwardPhyinteger
Line14VS4ForwardDFinteger
Line14VS4ForwardOFinteger
Line14VS4DefenseDefense1integerRefer to table PlayerInfo table number field.
Line14VS4DefenseDefense2integerRefer to table PlayerInfo table number field.
Line14VS4DefenseTimeinteger
Line14VS4DefensePhyinteger
Line14VS4DefenseDFinteger
Line14VS4DefenseOFinteger
Line24VS4ForwardCenterintegerRefer to table PlayerInfo table number field.
Line24VS4ForwardWingintegerRefer to table PlayerInfo table number field.
Line24VS4ForwardTimeinteger
Line24VS4ForwardPhyinteger
Line24VS4ForwardDFinteger
Line24VS4ForwardOFinteger
Line24VS4DefenseDefense1integerRefer to table PlayerInfo table number field.
Line24VS4DefenseDefense2integerRefer to table PlayerInfo table number field.
Line24VS4DefenseTimeinteger
Line24VS4DefensePhyinteger
Line24VS4DefenseDFinteger
Line24VS4DefenseOFinteger
LastMinOffForwardCenterintegerRefer to table PlayerInfo table number field.
LastMinOffForwardLeftWingintegerRefer to table PlayerInfo table number field.
LastMinOffForwardRightWingintegerRefer to table PlayerInfo table number field.
LastMinOffDefenseDefense1integerRefer to table PlayerInfo table number field.
LastMinOffDefenseDefense2integerRefer to table PlayerInfo table number field.
LastMinDefForwardCenterintegerRefer to table PlayerInfo table number field.
LastMinDefForwardLeftWingintegerRefer to table PlayerInfo table number field.
LastMinDefForwardRightWingintegerRefer to table PlayerInfo table number field.
LastMinDefDefenseDefense1integerRefer to table PlayerInfo table number field.
LastMinDefDefenseDefense2integerRefer to table PlayerInfo table number field.
Goaler1integerRefer to table Goaler table number field.
Goaler2integerRefer to table Goaler table number field.
Goaler3integerRefer to table Goaler table number field.
ExtraForwardPKintegerRefer to table PlayerInfo table number field.
ExtraForwardN1integerRefer to table PlayerInfo table number field.
ExtraForwardN2integerRefer to table PlayerInfo table number field.
ExtraForwardN3integerRefer to table PlayerInfo table number field.
ExtraForwardPP1integerRefer to table PlayerInfo table number field.
ExtraForwardPP2integerRefer to table PlayerInfo table number field.
ExtraDefensePK2integerRefer to table PlayerInfo table number field.
ExtraDefenseN1integerRefer to table PlayerInfo table number field.
ExtraDefenseN2integerRefer to table PlayerInfo table number field.
ExtraDefenseN3integerRefer to table PlayerInfo table number field.
ExtraDefensePPintegerRefer to table PlayerInfo table number field.
ExtraDefensePK1integerRefer to table PlayerInfo table number field.
PenaltyShots1integerRefer to table PlayerInfo table number field.
PenaltyShots2integerRefer to table PlayerInfo table number field.
PenaltyShots3integerRefer to table PlayerInfo table number field.
PenaltyShots4integerRefer to table PlayerInfo table number field.
PenaltyShots5integerRefer to table PlayerInfo table number field.
OTForward1integerRefer to table PlayerInfo table number field.
OTForward2integerRefer to table PlayerInfo table number field.
OTForward3integerRefer to table PlayerInfo table number field.
OTForward4integerRefer to table PlayerInfo table number field.
OTForward5integerRefer to table PlayerInfo table number field.
OTForward6integerRefer to table PlayerInfo table number field.
OTForward7integerRefer to table PlayerInfo table number field.
OTForward8integerRefer to table PlayerInfo table number field.
OTForward9integerRefer to table PlayerInfo table number field.
OTForward10integerRefer to table PlayerInfo table number field.
OTDefense1integerRefer to table PlayerInfo table number field.
OTDefense2integerRefer to table PlayerInfo table number field.
OTDefense3integerRefer to table PlayerInfo table number field.
OTDefense4integerRefer to table PlayerInfo table number field.
OTDefense5integerRefer to table PlayerInfo table number field.
Strategy1GoalDiffintegerWinning by #1
Strategy1Phyinteger
Strategy1DFinteger
Strategy1OFinteger
Strategy2GoalDiffintegerWinning by #2
Strategy2Phyinteger
Strategy2DFinteger
Strategy2OFinteger
Strategy3PhyintegerScore is equal
Strategy3DFinteger
Strategy3OFinteger
Strategy4GoalDiffintegerLosing by #1
Strategy4Phyinteger
Strategy4DFinteger
Strategy4OFinteger
Strategy5GoalDiffintegerLosing by #1
Strategy5Phyinteger
Strategy5DFinteger
Strategy5OFinteger
PullGoalerMinPctinteger
PullGoalerMinGoalinteger
RemoveGoaliesSecondinteger
WebClientModifyboolean

DraftPick

Field NameField Data TypeInformation
InternalNumberinteger
TeamNumberintegerRefer to table TeamProInfo table number field.
FromTeamintegerRefer to table TeamProInfo table number field.
FromTeamAbbrestring
Yearinteger
Roundinteger
ConditionalTradestringShow the Team Pro Abbreviation of the Team who a condition is apply

Prospects

Field NameField Data TypeInformation
Numberinteger primary key
Namestring
TeamNumberintegerRefer to table TeamProInfo table number field.
Yearinteger
OverallPickinteger
Informationstring
URLLinkstring

SchedulePro

Field NameField Data TypeInformation
GameNumberinteger primary key
Dayinteger
Playboolean
VisitorTeamintegerRefer to table TeamProInfo table number field.
HomeTeamintegerRefer to table TeamProInfo table number field.
VisitorTeamNamestring
HomeTeamNamestring
VisitorTeamAbbrestring
HomeTeamAbbrestring
VisitorScoreinteger
HomeScoreinteger
Overtimeboolean
Shootoutboolean
Linkboolean

ScheduleFarm

Field NameField Data TypeInformation
GameNumberinteger primary key
Dayinteger
Playboolean
VisitorTeamintegerRefer to table TeamFarmInfo table number field.
HomeTeamintegerRefer to table TeamFarmInfo table number field.
VisitorTeamNamestring
HomeTeamNamestring
VisitorTeamAbbrestring
HomeTeamAbbrestring
VisitorScoreinteger
HomeScoreinteger
Overtimeboolean
Shootoutboolean
Linkboolean

LeagueGeneral

Field NameField Data TypeInformation
Name string
ProConferenceName1 string
ProConferenceName2 string
FarmConferenceName1 string
FarmConferenceName2 string
ProDivisionName1 string
ProDivisionName2 string
ProDivisionName3 string
ProDivisionName4 string
ProDivisionName5 string
ProDivisionName6 string
FarmDivisionName1 string
FarmDivisionName2 string
FarmDivisionName3 string
FarmDivisionName4 string
FarmDivisionName5 string
FarmDivisionName6 string
LeagueYearOutput integer
OutputName string
OutputNameFormat string
LeagueOwner string
NumbersOfTeam integer
Abbre string
LeagueYear integer
LeagueEngine integer0 = 2.0 / 1 = 1.1 / 2 = 2.1 / 3 = 1.5
FarmLeagueEngine integer0 = 2.0 / 1 = 1.1 / 2 = 2.1 / 3 = 1.5
TradeDeadLine integer
WaiverDeadLine integer
PointSystemW integer
PointSystemL integer
PointSystemT integer
PointSystemSOW integer
PointSystemSOL integer
PointSystemOTW integer
PointSystemOTL integer
PointSystemSO boolean
NoOvertime boolean
NewTieBreaker boolean'Tie Breaker Rule: SOW doesn’t count' option
ProStandingbyPCT boolean
FarmStandingbyPCT boolean
ProOT3vs3 boolean
FarmOT3vs3 boolean
ProOTLinesUp boolean
FarmOTLinesUp boolean
FarmNumberDivisionLeader integer
ProNumberDivisionLeader integer
PlayOffEndPro booleanPro Playoff Done
PlayOffEndFarm booleanFarm Playoff Done
PlayOffRound integer
ProPlayOffLength integer
ProHowManyPlayOffTeam integer
FarmPlayOffLength integer
FarmHowManyPlayOffTeam integer
PlayOffWinnerPro integerRefer to table TeamProInfo table number field.
PlayOffWinnerFarm integerRefer to table TeamFarmInfo table number field.
ProInjuryRecoverySpeed float
FarmInjuryRecoverySpeed float
RFAAge integer
UFAAge integer
ProScheduleDone boolean
FarmScheduleDone boolean
PreSeasonSchedule boolean
ProScheduleGamePerTeam integer
FarmScheduleGamePerTeam integer
ProScheduleTotalGame integer
FarmScheduleTotalGame integer
ProScheduleTotalDay integer
ScheduleNextDay integer
ProDivisionNewNHLPlayoff boolean
FarmDivisionNewNHLPlayoff boolean
DefaultSimulationPerDay integer
LastTransactionOutputinteger
DraftPickByYear integer
LeagueWebPassword string
LeagueWebGuestPassword string
SeasonStarted boolean
SeasonEnd boolean
OffSeason boolean
PlayOffStarted boolean
PlayOffEnd boolean
EntryDraftStart boolean
Today3StarPro1 stringFirst Star
Today3StarPro2 stringSecond Star
Today3StarPro3 stringThird Star
Today3StarPro stringThe three star in the same string
Today3StarFarm1 stringFirst Star
Today3StarFarm2 stringSecond Star
Today3StarFarm3 stringThird Star
Today3StarFarm stringThe three star in the same string
Days73StarPro1 stringFirst Star
Days73StarPro2 stringSecond Star
Days73StarPro3 stringThird Star
Days73StarPro stringThe three star in the same string
Days73StarFarm1 stringFirst Star
Days73StarFarm2 stringSecond Star
Days73StarFarm3 stringThird Star
Days73StarFarm stringThe three star in the same string
Days303StarPro1 stringFirst Star
Days303StarPro2 stringSecond Star
Days303StarPro3 stringThird Star
Days303StarPro stringThe three star in the same string
Days303StarFarm1 stringFirst Star
Days303StarFarm2 stringSecond Star
Days303StarFarm3 stringThird Star
Days303StarFarm stringThe three star in the same string
DatabaseCreationDatetimestampWhen the Database was create by the simulator

LeagueSimulation

Field NameField Data TypeInformation
WaiversEnableboolean
ProInjuryEnableboolean
FarmInjuryEnableboolean
FinanceEnableboolean
ProSuspensionEnableboolean
FarmSuspensionEnableboolean
FarmEnableboolean
FarmFinanceEnableboolean
FullFarmEnableboolean
ProForwardPlayAllPositionboolean
FarmForwardPlayAllPositionboolean
ProCoachDisabledboolean
FarmCoachDisabledboolean
ProMoraleDisabledboolean
FarmMoraleDisabledboolean
ProFightDisabledboolean
FarmFightDisabledboolean
ProPenaltyDisabledboolean
FarmPenaltyDisabledboolean
ProTeamPopularityboolean
FarmTeamPopularityboolean
ProFightinteger
ProCoachinteger
ProMoraleinteger
ProInjuryinteger
ProFinanceinteger
ProShotsinteger
ProGoalsinteger
ProPenaltyinteger
ProHitsinteger
ProPPinteger
FarmFightinteger
FarmCoachinteger
FarmMoraleinteger
FarmInjuryinteger
FarmFinanceinteger
FarmShotsinteger
FarmGoalsinteger
FarmPenaltyinteger
FarmHitsinteger
FarmPPinteger
ProTwoConferenceboolean
FarmTwoConferenceboolean

LeagueFinance

Field NameField Data TypeInformation
PlayerMinimumSalary integer
PlayerMaxSalary integer
PlayerFarmMaxSalary integer
CurrentFundMinimumWarning integer
FarmSalaryPct integer
MaxContractDuration integer
SuspensionPlayerRemoveSalaryCap boolean
RemoveSalaryCapWhenPlayerUnderCondition integer
FarmIncludeSalaryCap boolean
CoachIncludeSalaryCap boolean
BonusIncludeSalaryCap boolean
PaidFarmEvenIfDesactivate boolean
SalaryCapOption integer0 = None / 1 = Complexe Calculation Base on Year 1 Salary : Fixed Value / 2 = Complexe Calculation Base on Year 1 Salary : Fixed Value + Current Bank Account / 3 = Simple Calculation Base on Year 1 Salary : Fixed Value / 4 = Complexe Calculation Base on Salary Average : Fixed Value / 5 = Complexe Calculation Base on Salary Average : Fixed Value + Current Bank Account / 6 = Simple Calculation Base on Salary Average : Fixed Value
ProSalaryCapValue integer
FarmSalaryCapValue integer
ProMinimumSalaryCap integer
FarmPlayerPayAsProAfterXGame integer
OneWayContractSalaryCapPct integer
OneWayContractSalaryCapBuriedSalary integer
InjuryOutOfPayroll integer
LuxuryTaxPerDays integer
LuxuryTaxPCT integer

LeagueOutputOption

If you want to enforce league option select in the STHS, please use value from this table.

Field NameField Data TypeInformation
UnassignedasFreeAgent boolean
OutputMergeAllWinStreak boolean
InchInsteadofCM boolean
LBSInsteadofKG boolean
MergeProFarmRoster boolean
MergeRosterPlayerInfo boolean
OutputOrder integer0 = Alphabetically / 1 = By Division then Alphabetically / 2= By Conference then Alphabetically
OutputAllPlayersInUnassigned boolean
OutputTeamLink boolean
OutputSetting boolean
NumberOfPlayerLeagueLeader integer
NumberOfGoalerLeagueLeader integer
NumberOfInvidualLeader integer
StandardStandingOutput boolean
SeparateTodayGameOutput boolean
SplitTodayGames boolean
PHPPackIntegration boolean
OutputSalariesRemaining boolean
OutputSalariesAverageTotal boolean
OutputSalariesAverageRemaining boolean
ScheduleUseDateInsteadofDay boolean
ScheduleRealDate timestamp
FreeAgentUseDateInsteadofDay boolean
FreeAgentRealDate timestamp
ProMinimumGamePlayerLeaderinteger
FarmMinimumGamePlayerLeaderinteger
PlayersMugShotBaseURL string
PlayersMugShotFileExtension string
ShowExpansionDraftLinkinTopMenu boolean
ShowFarmScoreinPHPHomePage boolean
NumberofNewsinPHPHomePage integer
NumberofLatestScoreinPHPHomePage integer
ShowWebClientInDymanicWebsite boolean
ShowRSSFeed boolean
EmailServerstring
EmailServerReplyAddressstring
JerseyNumberInWebsitestring
ProcessDatabaseTransactionboolean
WebsiteURLstring
OutputCustomURL1 string
OutputCustomURL1Name string
OutputCustomURL2 string
OutputCustomURL2Name string

LeagueWebClient

Field NameField Data TypeInformation
BlockPlayerFromPlayingLines12boolean
BlockPlayerFromPlayingLines123boolean
BlockPlayerFromPlayingLines12inPPPKboolean
DisableMultipleLinesinRowboolean
MaximumPlayerPerTeaminteger
MinimumPlayerPerTeaminteger
BlockSenttoFarmAfterTradeDeadlineboolean
ProTeamEliminatedCannotSendPlayerstoFarmboolean
ForceCorrect10LinesupbeforeSavingboolean
ProForceGameStrategiesTointeger
ProGoalerInGameinteger
ProMinCinteger
ProMinDinteger
ProMinForwardinteger
ProMinLWinteger
ProMinRWinteger
ProPlayerInGameinteger
ProPlayerLimitinteger
ProCustomOTLinesboolean
ProForceGameStrategiesAt5boolean
ProMaxTicketPrice1integer
ProMaxTicketPrice2integer
ProMaxTicketPrice3integer
ProMaxTicketPrice4integer
ProMaxTicketPrice5integer
FarmForceGameStrategiesTointeger
FarmGoalerInGameinteger
FarmMinCinteger
FarmMinDinteger
FarmMinForwardinteger
FarmMinLWinteger
FarmMinRWinteger
FarmPlayerInGameinteger
FarmPlayerLimitinteger
FarmCustomOTLinesboolean
FarmForceGameStrategiesAt5boolean
FarmMaxTicketPrice1integer
FarmMaxTicketPrice2integer
MaxFarmOvinteger
MaxFarmOvGoalerinteger
MaximumLinesPCT1integerNormal #1
MaximumLinesPCT2integerNormal #2
MaximumLinesPCT3integerNormal #3
MaximumLinesPCT4integerNormal #4
MaximumLinesPCT5integerPP/PK/PK3/4vs #1
MaximumLinesPCT6integerPP/PK/PK3/4vs #2
DefaultLinesPCT1integerNormal #1
DefaultLinesPCT2integerNormal #2
DefaultLinesPCT3integerNormal #3
DefaultLinesPCT4integerNormal #3
DefaultLinesPCT5integerPP/PK/PK3/4vs #1
DefaultLinesPCT6integerPP/PK/PK3/4vs #2
ProDefaultTicketPrice1integer
ProDefaultTicketPrice2integer
ProDefaultTicketPrice3integer
ProDefaultTicketPrice4integer
ProDefaultTicketPrice5integer
FarmDefaultTicketPrice1integer
FarmDefaultTicketPrice2integer
PullGoalerMinGoalinteger
PullGoalerMinGoalEnforceinteger
PullGoalerMinPctinteger
PullGoalerRemoveGoaliesSecondinteger
PullGoalerMaxinteger

RankingOrder

Field NameField Data TypeInformation
Typeinteger0 = Overall, 1 = Conference
TeamOrderinteger
TeamProNumberintegerRefer to table TeamProInfo table number field.
TeamProPointinteger
TeamFarmNumberintegerRefer to table TeamFarmInfo table number field.
TeamFarmPointinteger

LeagueLog

Field NameField Data TypeInformation
Numberinteger primary key
TextstringOriginal Text in the STHS with HTML formatting.
DateTimetimestampExtract DateTime from Text.
TransactionTypeinteger0 = Other, 1 = Trade, 2 = Injury, 3 = Waiver, 4 = SendToPro, 5 = SendToFarm, 6 = Suspension, 7 = RosterLineError, 8 = Information, 9 = Players, 10 = Team, 11 = OptionChange
ColorcolorThe color the transaction should show up in the color based on the option select in the simulator.

TeamLog

Field NameField Data TypeInformation
Numberinteger primary key
TeamNumberintegerRefer to table TeamProInfo table number field.
TextstringOriginal Text in the STHS with HTML formatting.
DateTimetimestampExtract DateTime from Text.

TodayGame

Field NameField Data TypeInformation
GameNumberstringIt'll always contain Pro or Farm and the game number.
LinkstringLink to the URL of game.
Notestring
VisitorTeamNumberinteger
VisitorTeamstring
VisitorTeamAbbrestring
VisitorTeamShotsinteger
VisitorTeamShotsAttempinteger
VisitorTeamScoreinteger
VisitorTeamGoalstring
VisitorTeamGoalerstring
HomeTeamNumberinteger
HomeTeamstring
HomeTeamAbbrestring
HomeTeamShotsinteger
HomeTeamShotsAttempinteger
HomeTeamScoreinteger
HomeTeamGoalstring
HomeTeamGoalerstring

Waiver

Field NameField Data TypeInformation
PlayerintegerIf under 10000, Refer to table PlayerInfo number field. If over 10,000, Refer to table GoalerInfo number field less 10000.
(Example : number 10101 refer to GoalerInfo Number 101 row.
PlayerNameOVstringPlayer's Name with is overall inside ( ).
FromTeamintegerRefer to table TeamProInfo table number field.
ToTeamintegerRefer to table TeamProInfo table number field.
DayPutOnWaiverinteger
DayRemoveFromWaiverinteger

WaiverOrder

Field NameField Data TypeInformation
Playerinteger
Goalieboolean
TeamProNumberintegerRefer to table TeamProInfo table number field.

WaiverSendTo

Field NameField Data TypeInformation
Playerinteger
Goalieboolean
TeamProNumberintegerRefer to table TeamProInfo table number field.

WaiverInterest

Field NameField Data TypeInformation
Playerinteger
Goalieboolean
TeamProNumberintegerRefer to table TeamProInfo table number field.

EntryDraft

Field NameField Data TypeInformation
PickNumberinteger
ProspectPickstring
OriginalTeamintegerRefer to table TeamProInfo table number field.
CurrentTeamintegerRefer to table TeamProInfo table number field.

EntryDraftProspectAvailable

Field NameField Data TypeInformation
ProspectNamestring

ProRivalryInfo

Field NameField Data TypeInformation
Team1integerRefer to table TeamProInfo table number field.
Team2integerRefer to table TeamProInfo table number field.
Rivalryinteger

FarmRivalryInfo

Field NameField Data TypeInformation
Team1integerRefer to table TeamFarmInfo table number field.
Team2integerRefer to table TeamFarmInfo table number field.
Rivalryinteger

LeagueNews

Since Version 3.0.8, this table was moved into separate SQLite Database.

Field NameField Data TypeInformation
Numberinteger AUTO_INCREMENTLowest Number = Most Recent
TimetimestampTime is save in UTC Format
TeamNumberinteger
TeamNewsNumberintegerDo not edit this field. This field map is the news number inside the STHS Data. If you change this, you'll overwrite data in the STHS once you load the database in the STHS. Keep for Legacy Reason in 3.0.8 or more.
Ownerstring
Titlestring
Messagestring
RemovebooleanRow with this value as True will be erased inside the STHS once you load the database in the STHS. Keep for Legacy Reason in 3.0.8 or more.
WebClientModifyboolean
AnswerNumberintegerIf the number is not 0, this row message is a comment to another row. The ‘another row’ can be find out by looking at this field number and finding the row where the number field equal this field number.

PlayoffPro

Field NameField Data TypeInformation
Numberinteger
Conferenceinteger
Divisioninteger
Roundinteger
HomeTeamintegerRefer to table TeamProInfo table number field.
HomeWininteger
VisitorTeamintegerRefer to table TeamProInfo table number field.
VisitorWininteger
Rivalryinteger

PlayoffFarm

Field NameField Data TypeInformation
Numberinteger
Conferenceinteger
Divisioninteger
Roundinteger
HomeTeamintegerRefer to table TeamFarmInfo table number field.
HomeWininteger
VisitorTeamintegerRefer to table TeamFarmInfo table number field.
VisitorWininteger
Rivalryinteger

PlayoffProNumber

Field NameField Data TypeInformation
Round1integer
Round2integer
Round3integer
Round4integer
Round4integer

Note: This table complexes information is used by the Standing.php webpage to create a valid HTML Table code to look like a playoff tree.

PlayoffFarmNumber

Field NameField Data TypeInformation
Round1integer
Round2integer
Round3integer
Round4integer
Round4integer

Note: This table complexes information is used by the Standing.php webpage to create a valid HTML Table code to look like a playoff tree.

PowerRankingPro

Field NameField Data TypeInformation
TodayRankinginteger
LastRankinginteger
TeamsintegerRefer to table TeamProInfo table number field.
Pointsinteger
Winteger
Linteger
Tinteger
OTLinteger
SOLinteger
GFinteger
GAinteger

PowerRankingFarm

Field NameField Data TypeInformation
TodayRankinginteger
LastRankinginteger
TeamsintegerRefer to table TeamFarmInfo table number field.
Pointsinteger
Winteger
Linteger
Tinteger
OTLinteger
SOLinteger
GFinteger
GAinteger

NextYearFreeAgent

Field NameField Data TypeInformation
InternalNumberinteger primary keyHigher the number = Most Recent Contract
PlayerTypebooleanIf True, Number field refer to PlayerInfo table. If False, Number field refer to GoalieInfo table
NumberintegerRefer to table PlayerInfo or GoalerInfo depending on the PlayerType Field
PlayerNamestringSame as table Name field in PlayerInfo or GoalerInfo
TeamintegerRefer to table TeamProInfo table number field.
NoTradeboolean
CanPlayProboolean
CanPlayFarmboolean
ProSalaryinFarmboolean
Contractinteger
Salarycurrency
Bonuscurrency

Trade

Field NameField Data TypeInformation
FromTeaminteger
ToTeaminteger
Playerinteger
Prospectinteger
DraftPickinteger
Moneycurrency
SalaryCapcurrency
Confirmboolean