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 - TradeLog - TodayGame - Waiver - WaiverOrder - WaiverSendTo - WaiverInterest - EntryDraft - EntryDraftProspectAvailable - NextYearFreeAgent - Trade - FreeAgentOffers - DraftSelection

PlayerInfo

Field Name	Field Data Type	Information
Number	integer primary key	Multiple of other tables Refer to table this field to get players information.
UniqueID	integer	This field is not used to refer anything inside the database.
Name	string
URLLink	string
NHLID	string
Team	integer	Refer to table TeamProInfo table number field.
TeamName	string	Pro Team Name or Farm Team Name with Pro Abbre base on next game line up.
ProTeamName	string	Always Pro Team Name
TeamThemeID	integer	Theme ID for Logo and Color on website
Country	string
AgeDate	timestamp
Age	integer
Weight	integer
Height	integer
PosC	boolean
PosLW	boolean
PosRW	boolean
PosD	boolean
Contract	integer
Rookie	boolean
PProtected	boolean
NoApplyRerate	boolean
AvailableforTrade	boolean
NoTrade	boolean	Permanent No Trade
NoTrade1	boolean
NoTrade2	boolean
NoTrade3	boolean
NoTrade4	boolean
NoTrade5	boolean
NoTrade6	boolean
NoTrade7	boolean
NoTrade8	boolean
NoTrade9	boolean
NoTrade10	boolean
CanPlayPro	boolean
CanPlayFarm	boolean
ForceWaiver	boolean	Show the calculation of the STHS if the player must go threw the waiver before being send to farm.
WaiverPossible	boolean
ExcludeSalaryCap	boolean
ProSalaryinFarm	boolean
ForceUFA	boolean
EmergencyRecall	boolean
PlayerRatingUpdateByRerateFunction	boolean	True when the Update Rating function was run and the players rating was updated
AcquiredType	string	0 = Not Available / 1 = Draft / 2 = Trade / 3 = Trade While Prospects / 4 = Free Agents / 5 = Waiver
ContractSignatureDate	timestamp	Show the Date the current contract enter
LastTradeDate	timestamp	Show the Date the last trade for this player
StarPower	integer
SalaryAverage	currency
Salary1	currency
Salary2	currency
Salary3	currency
Salary4	currency
Salary5	currency
Salary6	currency
Salary7	currency
Salary8	currency
Salary9	currency
Salary10	currency
SalaryCap1	currency
SalaryCap2	currency
SalaryCap3	currency
SalaryCap4	currency
SalaryCap5	currency
SalaryCap6	currency
SalaryCap7	currency
SalaryCap8	currency
SalaryCap9	currency
SalaryCap10	currency
SalaryRemaining	currency
SalaryAverageRemaining	currency
SalaryCap	currency	Show the Player Salary Cap for the Entire Season. Injuries or suspension doesn’t impact this value.
SalaryCapRemaining	currency	Show the Player Salary Cap for the Rest of the season. Injuries or suspension doesn’t impact this value.
FreeAgentSalaryRequest	currency	Show the Player Free Agent Salary Request if the player contrat is 0 or 1 AND the 'Allow GM to see Free Agent Salary Request' option is activate. If not, value is 0.
FreeAgentContratRequest	integer	Show the Player Free Agent Salary Request if the player contrat is 0 or 1 AND the 'Allow GM to see Free Agent Salary Request' option is activate. If not, value is 0.
FreeAgentContratBonus	integer	Show the Player Free Agent Bonus Request if the player contrat is 0 or 1 AND the 'Allow GM to see Free Agent Salary Request' option is activate. If not, value is 0.
Injury	string
NumberOfInjury	integer	Number of Condition Point loss during the season
Condition	integer
ConditionDecimal	float
Suspension	integer
Status1	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status2	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status3	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status4	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status5	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status6	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status7	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status8	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status9	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status10	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
CK	integer
FG	integer
DI	integer
SK	integer
ST	integer
EN	integer
DU	integer
PH	integer
FO	integer
PA	integer
SC	integer
DF	integer
PS	integer
EX	integer
LD	integer
PO	integer
MO	integer
Overall	integer
GameInRowWithAGoal	integer
GameInRowWithAPoint	integer
GameInRowWithOutAGoal	integer
GameInRowWithOutAPoint	integer
WebClientIP	string
WebClientModify	boolean
AutoRosterCanPlayPro	boolean
AutoRosterCanPlayFarm	boolean
DraftYear	integer
DraftOverallPick	integer
DraftOriginalTeam	string
Note	string
LastYearSalary	integer
LastYearSalaryAverage	integer
Jersey	integer

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 Name	Field Data Type	Information
Number	integer primary key	Refer to table PlayerInfo table number field.
UniqueID	integer	Same as table UniqueID field in PlayerInfo.
Name	string	Same as table Name field in PlayerInfo.
GP	integer
Shots	integer
G	integer
A	integer
P	integer
PlusMinus	integer
Pim	integer
Pim5	integer	Major Penalty
ShotsBlock	integer
OwnShotsBlock	integer
OwnShotsMissGoal	integer
Hits	integer
HitsTook	integer
GW	integer	Winning Goal
GT	integer	Tying Goal
FaceOffWon	integer
FaceOffTotal	integer
PenalityShotsScore	integer
PenalityShotsTotal	integer
EmptyNetGoal	integer
SecondPlay	integer
HatTrick	integer
PPG	integer
PPA	integer
PPP	integer
PPShots	integer
PPSecondPlay	integer
PKG	integer
PKA	integer
PKP	integer
PKShots	integer
PKSecondPlay	integer
GiveAway	integer
TakeAway	integer
PuckPossesionTime	integer
FightW	integer
FightL	integer
FightT	integer
Star1	integer
Star2	integer
Star3	integer
StarPower7Days	integer
StarPower30Days	integer
StarPowerYear	integer
StarPowerGoal7Days	integer
StarPowerAssist7Days	integer
StarPowerGoal30Days	integer
StarPowerAssist30Days	integer

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 Name	Field Data Type	Information
Number	integer primary key	Refer to table PlayerInfo table number field.
UniqueID	integer	Same as table UniqueID field in PlayerInfo.
Name	string	Same as table Name field in PlayerInfo.
GP	integer
Shots	integer
G	integer
A	integer
P	integer
PlusMinus	integer
Pim	integer
Pim5	integer	Major Penalty
ShotsBlock	integer
OwnShotsBlock	integer
OwnShotsMissGoal	integer
Hits	integer
HitsTook	integer
GW	integer	Winning Goal
GT	integer	Tying Goal
FaceOffWon	integer
FaceOffTotal	integer
PenalityShotsScore	integer
PenalityShotsTotal	integer
EmptyNetGoal	integer
SecondPlay	integer
HatTrick	integer
PPG	integer
PPA	integer
PPP	integer
PPShots	integer
PPSecondPlay	integer
PKG	integer
PKA	integer
PKP	integer
PKShots	integer
PKSecondPlay	integer
GiveAway	integer
TakeAway	integer
PuckPossesionTime	integer
FightW	integer
FightL	integer
FightT	integer
Star1	integer
Star2	integer
Star3	integer
StarPower7Days	integer
StarPower30Days	integer
StarPowerYear	integer
StarPowerGoal7Days	integer
StarPowerAssist7Days	integer
StarPowerGoal30Days	integer
StarPowerAssist30Days	integer

PlayerProStatMultipleTeam

Field Name	Field Data Type	Information
Number	integer primary key	Refer to table PlayerInfo table number field.
UniqueID	integer	Same as table UniqueID field in PlayerInfo.
Name	string	Same as table Name field in PlayerInfo.
Team	integer	Refer to table TeamProInfo table number field.
TeamName	string	Pro Team Name
TeamThemeID	integer	Theme ID for Logo and Color on website
GP	integer
Shots	integer
G	integer
A	integer
P	integer
PlusMinus	integer
Pim	integer
Pim5	integer	Major Penalty
ShotsBlock	integer
OwnShotsBlock	integer
OwnShotsMissGoal	integer
Hits	integer
HitsTook	integer
GW	integer	Winning Goal
GT	integer	Tying Goal
FaceOffWon	integer
FaceOffTotal	integer
PenalityShotsScore	integer
PenalityShotsTotal	integer
EmptyNetGoal	integer
SecondPlay	integer
HatTrick	integer
PPG	integer
PPA	integer
PPP	integer
PPShots	integer
PPSecondPlay	integer
PKG	integer
PKA	integer
PKP	integer
PKShots	integer
PKSecondPlay	integer
GiveAway	integer
TakeAway	integer
PuckPossesionTime	integer
FightW	integer
FightL	integer
FightT	integer

PlayerFarmStatMultipleTeam

Field Name	Field Data Type	Information
Number	integer primary key	Refer to table PlayerInfo table number field.
UniqueID	integer	Same as table UniqueID field in PlayerInfo.
Name	string	Same as table Name field in PlayerInfo.
Team	integer	Refer to table TeamProInfo table number field.
TeamName	string	Farm Team Name
TeamThemeID	integer	Theme ID for Logo and Color on website
GP	integer
Shots	integer
G	integer
A	integer
P	integer
PlusMinus	integer
Pim	integer
Pim5	integer	Major Penalty
ShotsBlock	integer
OwnShotsBlock	integer
OwnShotsMissGoal	integer
Hits	integer
HitsTook	integer
GW	integer	Winning Goal
GT	integer	Tying Goal
FaceOffWon	integer
FaceOffTotal	integer
PenalityShotsScore	integer
PenalityShotsTotal	integer
EmptyNetGoal	integer
SecondPlay	integer
HatTrick	integer
PPG	integer
PPA	integer
PPP	integer
PPShots	integer
PPSecondPlay	integer
PKG	integer
PKA	integer
PKP	integer
PKShots	integer
PKSecondPlay	integer
GiveAway	integer
TakeAway	integer
PuckPossesionTime	integer
FightW	integer
FightL	integer
FightT	integer
Star1	integer
Star2	integer
Star3	integer

GoalerInfo

Field Name	Field Data Type	Information
Number	integer primary key	Multiple of other tables Refer to table this field to get goalies information.
UniqueID	integer	This field is not used to refer anything inside the database.
Name	string
URLLink	string
NHLID	string
Team	integer	Refer to table TeamProInfo table number field.
TeamName	string	Pro Team Name or Farm Team Name with Pro Abbre base on next game line up.
ProTeamName	string	Always Pro Team Name
TeamThemeID	integer	Theme ID for Logo and Color on website
Country	string
AgeDate	timestamp
Age	integer
Weight	integer
Height	integer
PosG	boolean	Always True
Contract	integer
Rookie	boolean
PProtected	boolean
NoApplyRerate	boolean
AvailableforTrade	boolean
NoTrade	boolean	Permanent No Trade
NoTrade1	boolean
NoTrade2	boolean
NoTrade3	boolean
NoTrade4	boolean
NoTrade5	boolean
NoTrade6	boolean
NoTrade7	boolean
NoTrade8	boolean
NoTrade9	boolean
NoTrade10	boolean
CanPlayPro	boolean
CanPlayFarm	boolean
ForceWaiver	boolean
WaiverPossible	boolean
ExcludeSalaryCap	boolean
ProSalaryinFarm	boolean
ForceUFA	boolean
EmergencyRecall	boolean
AcquiredType	string	0 = Not Available / 1 = Draft / 2 = Trade / 3 = Trade While Prospects / 4 = Free Agents / 5 = Waiver
ContractSignatureDate	timestamp	Show the Date the current contract enter
LastTradeDate	timestamp	Show the Date the last trade for this player
StarPower	integer
SalaryAverage	currency
Salary1	currency
Salary2	currency
Salary3	currency
Salary4	currency
Salary5	currency
Salary6	currency
Salary7	currency
Salary8	currency
Salary9	currency
Salary10	currency
SalaryCap1	currency
SalaryCap2	currency
SalaryCap3	currency
SalaryCap4	currency
SalaryCap5	currency
SalaryCap6	currency
SalaryCap7	currency
SalaryCap8	currency
SalaryCap9	currency
SalaryCap10	currency
SalaryRemaining	currency
SalaryAverageRemaining	currency
SalaryCap	currency	Show the Player Salary Cap for the Entire Season. Injuries or suspension doesn’t impact this value.
SalaryCapRemaining	currency	Show the Player Salary Cap for the Rest of the season. Injuries or suspension doesn’t impact this value.
FreeAgentSalaryRequest	currency	Show the Player Free Agent Salary Request if the player contrat is 0 or 1 AND the 'Allow GM to see Free Agent Salary Request' option is activate. If not, value is 0.
FreeAgentContratRequest	integer	Show the Player Free Agent Salary Request if the player contrat is 0 or 1 AND the 'Allow GM to see Free Agent Salary Request' option is activate. If not, value is 0.
FreeAgentContratBonus	integer	Show the Player Free Agent Bonus Request if the player contrat is 0 or 1 AND the 'Allow GM to see Free Agent Salary Request' option is activate. If not, value is 0.
Injury	string
InjuryDuration	integer	Number of Condition Point loss during the season
Condition	integer
ConditionDecimal	float
Suspension	integer
Status1	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status2	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status3	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status4	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status5	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status6	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status7	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status8	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status9	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
Status10	integer	3 = Pro / 2 = Pro Scratches / 1 = Farm / 0 = Farm Scratches
SK	integer
DU	integer
EN	integer
SZ	integer
AG	integer
RB	integer
SC	integer
HS	integer
RT	integer
PH	integer
PS	integer
EX	integer
LD	integer
PO	integer
MO	integer
Overall	integer
WebClientIP	string
WebClientModify	boolean
AutoRosterCanPlayPro	boolean
AutoRosterCanPlayFarm	boolean
DraftYear	integer
DraftOverallPick	integer
DraftOriginalTeam	string
Note	string
LastYearSalary	integer
LastYearSalaryAverage	integer
Jersey	integer

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 Name	Field Data Type	Information
Number	integer primary key	Refer to table GoalerInfo table number field.
UniqueID	integer	Same as table UniqueID field in GoalerInfo.
Name	string	Same as table Name field in GoalerInfo.
GP	integer
SecondPlay	integer
W	integer
L	integer
OTL	integer
Shootout	integer
GA	integer
SA	integer
SARebound	integer	Rebound allow after a shot
Pim	integer
A	integer	Assist
PenalityShotsShots	integer
PenalityShotsGoals	integer
StartGoaler	integer	Number of game start as starting goalie
BackupGoaler	integer	Number of game start as backup goalie
EmptyNetGoal	integer	Number of goal score when goalie has left is goal
Star1	integer
Star2	integer
Star3	integer
StarPower7Days	integer
StarPower30Days	integer
StarPowerYear	integer
StarPowerSA7Days	integer
StarPowerGA7Days	integer
StarPowerSA30Days	integer
StarPowerGA30Days	integer

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 Name	Field Data Type	Information
Number	integer primary key	Refer to table GoalerInfo table number field.
UniqueID	integer	Same as table UniqueID field in GoalerInfo.
Name	string	Same as table Name field in GoalerInfo.
GP	integer
SecondPlay	integer
W	integer
L	integer
OTL	integer
Shootout	integer
GA	integer
SA	integer
SARebound	integer	Rebound allow after a shot
Pim	integer
A	integer	Assist
PenalityShotsShots	integer
PenalityShotsGoals	integer
StartGoaler	integer	Number of game start as starting goalie
BackupGoaler	integer	Number of game start as backup goalie
EmptyNetGoal	integer	Number of goal score when goalie has left is goal
Star1	integer
Star2	integer
Star3	integer
StarPower7Days	integer
StarPower30Days	integer
StarPowerYear	integer
StarPowerSA7Days	integer
StarPowerGA7Days	integer
StarPowerSA30Days	integer
StarPowerGA30Days	integer

GoalerProStatMultipleTeam

Field Name	Field Data Type	Information
Number	integer primary key	Refer to table GoalerInfo table number field.
UniqueID	integer	Same as table UniqueID field in GoalerInfo.
Name	string	Same as table Name field in GoalerInfo.
Team	integer	Refer to table TeamProInfo table number field.
TeamName	string	Pro Team Name
TeamThemeID	integer	Theme ID for Logo and Color on website
GP	integer
SecondPlay	integer
W	integer
L	integer
OTL	integer
Shootout	integer
GA	integer
SA	integer
SARebound	integer	Rebound allow after a shot
Pim	integer
A	integer	Assist
PenalityShotsShots	integer
PenalityShotsGoals	integer
StartGoaler	integer	Number of game start as starting goalie
BackupGoaler	integer	Number of game start as backup goalie
EmptyNetGoal	integer	Number of goal score when goalie has left is goal

GoalerFarmStatMultipleTeam

Field Name	Field Data Type	Information
Number	integer primary key	Refer to table GoalerInfo table number field.
UniqueID	integer	Same as table UniqueID field in GoalerInfo.
Name	string	Same as table Name field in GoalerInfo.
Team	integer	Refer to table TeamProInfo table number field.
TeamName	string	Farm Team Name
TeamThemeID	integer	Theme ID for Logo and Color on website
GP	integer
SecondPlay	integer
W	integer
L	integer
OTL	integer
Shootout	integer
GA	integer
SA	integer
SARebound	integer	Rebound allow after a shot
Pim	integer
A	integer	Assist
PenalityShotsShots	integer
PenalityShotsGoals	integer
StartGoaler	integer	Number of game start as starting goalie
BackupGoaler	integer	Number of game start as backup goalie
EmptyNetGoal	integer	Number of goal score when goalie has left is goal

CoachInfo

Field Name	Field Data Type	Information
Number	integer primary key
Name	string
Team	integer	Refer to table TeamProInfo table number field.
Country	string
Age	integer
Contract	integer
ContractSignatureDate	timestamp	Show the Date the current contract enter
Salary	currency
PH	integer
DF	integer
OF	integer
PD	integer
EX	integer
LD	integer
PO	integer
MO	integer

TeamProInfo

Field Name	Field Data Type	Information
Number	integer primary key	Multiple of other tables refer to table this field to get pro team information.
UniqueID	integer	This field is not used to refer anything inside the database.
Name	string
Abbre	string
City	string
GMName	string
Messenger	string
Email	string
Arena	string
DivisionNumber	Integer
Division	string
ConferenceNumber	Integer
Conference	string
Captain	integer	Refer to table PlayerInfo table number field.
Assistant1	integer	Refer to table PlayerInfo table number field.
Assistant2	integer	Refer to table PlayerInfo table number field.
CoachID	integer	Refer to table CoachInfo table number field.
Morale	integer
TeamOverall	integer
PlayOffEliminated	boolean
PowerRanking	integer	Only update when PowerRanking HTML is output.
PlayOffWinRound	integer	Only update in playoff. Show the number of win in current playoff round.
DidNotMakePlayoff	boolean
LinesLoad	integer	# of Load Lines
FailAutoRoster	integer	# of Fail Auto Roster
FailProAutoLine	integer	# of Fail Pro Auto Line
FailFarmAutoLine	integer	# of Fail Farm Auto Line
FailSimulation	integer	# of Fail Simulation
LastLoadFileDate	string	Last Lines Send Date
CurrentLineValid	boolean	The current lines are valid for next game?
TeamThemeID	integer	Theme ID for Logo and Color on website
WebPassword	string	Current team password Hash + Salt
WebMaxFreeAgentOffer	string
WebClientIP	string
WebClientModify	boolean

TeamProFinance

Field Name	Field Data Type	Information
Number	integer primary key	Refer to table TeamProInfo table number field.
UniqueID	integer	Same as table UniqueID field in TeamProInfo.
Name	string	Same as table TeamProInfo table name field.
ArenaCapacityL1	integer
ArenaCapacityL2	integer
ArenaCapacityL3	integer
ArenaCapacityL4	integer
ArenaCapacityLuxury	integer
TicketPriceL1	integer
TicketPriceL2	integer
TicketPriceL3	integer
TicketPriceL4	integer
TicketPriceLuxury	integer
AttendanceL1	integer
AttendanceL2	integer
AttendanceL3	integer
AttendanceL4	integer
AttendanceLuxury	integer
ScheduleGameInAYear	integer
ScheduleHomeGameInAYear	integer
SalaryCapToDate	currency
SalaryCapPerDay	currency
TotalPlayersSalaries	currency
TotalPlayersSalariesAverage	currency
ExpensePerDay	currency
EstimatedRevenue	currency
EstimatedSeasonExpense	currency
TotalSalaryCap	currency
TotalAttendance	currency
TotalIncome	currency
ExpenseThisSeason	currency
SeasonTicketPCT	integer
TeamPopularity	integer
CurrentBankAccount	currency
ProjectedBankAccount	currency
SpecialSalaryCapY1	currency
SpecialSalaryCapY2	currency
SpecialSalaryCapY3	currency
SpecialSalaryCapY4	currency
SpecialSalaryCapY5	currency
SpecialSalaryCapY6	currency
SpecialSalaryCapY7	currency
SpecialSalaryCapY8	currency
SpecialSalaryCapY9	currency
SpecialSalaryCapY10	currency
LuxuryTaxeTotal	currency
PlayerInSalaryCap	integer	Show the number of player in the salary cap.
PlayerOutofSalaryCap	integer	Show the number of player out the salary cap.
WebClientIP	string
WebClientModify	boolean

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 Name	Field Data Type	Information
Number	integer primary key	Refer to table TeamProInfo table number field.
UniqueID	integer	Same as table UniqueID field in TeamProInfo.
Name	string	Same as table TeamProInfo table name field.
TeamThemeID	integer	Theme ID for Logo and Color on website
Last10W	integer
Last10L	integer
Last10T	integer
Last10OTW	integer
Last10OTL	integer
Last10SOW	integer
Last10SOL	integer
GP	integer
W	integer
L	integer
T	integer
OTW	integer
OTL	integer
SOW	integer
SOL	integer
Points	integer
GF	integer
GA	integer
HomeGP	integer
HomeW	integer
HomeL	integer
HomeT	integer
HomeOTW	integer
HomeOTL	integer
HomeSOW	integer
HomeSOL	integer
HomeGF	integer
HomeGA	integer
StandingPlayoffTitle	string
Streak	string
PPAttemp	integer
PPGoal	integer
PKAttemp	integer
PKGoalGA	integer
PKGoalGF	integer
ShotsFor	integer
ShotsAga	integer
ShotsBlock	integer
ShotsPerPeriod1	integer
ShotsPerPeriod2	integer
ShotsPerPeriod3	integer
ShotsPerPeriod4	integer
GoalsPerPeriod1	integer
GoalsPerPeriod2	integer
GoalsPerPeriod3	integer
GoalsPerPeriod4	integer
PuckTimeInZoneDF	integer	In Second
PuckTimeInZoneOF	integer	In Second
PuckTimeInZoneNT	integer	In Second
PuckTimeControlinZoneDF	integer	In Second
PuckTimeControlinZoneOF	integer	In Second
PuckTimeControlinZoneNT	integer	In Second
Shutouts	integer
TotalGoal	integer
TotalAssist	integer
TotalPoint	integer
Pim	integer
Hits	integer
FaceOffWonDefensifZone	integer
FaceOffTotalDefensifZone	integer
FaceOffWonOffensifZone	integer
FaceOffTotalOffensifZone	integer
FaceOffWonNeutralZone	integer
FaceOffTotalNeutralZone	integer
EmptyNetGoal	integer

TeamProStatVS

Field Name	Field Data Type	Information
Number	integer primary key	Refer to table TeamProInfo table number field.
UniqueID	integer	Same as table UniqueID field in TeamProInfo.
TeamNumber	integer	Refer to table TeamProInfo table number field.
TeamName	string	Same as table TeamProInfo table name field.
TeamVSNumber	integer	Refer to table TeamProInfo table number field.
TeamVSName	string	Same as table TeamProInfo table name field except 101 = 'VS Division', 102 = 'VS Conference', 103 = 'Since Last GM Reset'.
TeamVSNumberThemeID	integer	Theme ID for Logo and Color on website
GP	integer
W	integer
L	integer
T	integer
OTW	integer
OTL	integer
SOW	integer
SOL	integer
Points	integer
GF	integer
GA	integer
HomeGP	integer
HomeW	integer
HomeL	integer
HomeT	integer
HomeOTW	integer
HomeOTL	integer
HomeSOW	integer
HomeSOL	integer
HomeGF	integer
HomeGA	integer
StandingPlayoffTitle	string
Streak	string
PPAttemp	integer
PPGoal	integer
PKAttemp	integer
PKGoalGA	integer
PKGoalGF	integer
ShotsFor	integer
ShotsAga	integer
ShotsBlock	integer
ShotsPerPeriod1	integer
ShotsPerPeriod2	integer
ShotsPerPeriod3	integer
ShotsPerPeriod4	integer
GoalsPerPeriod1	integer
GoalsPerPeriod2	integer
GoalsPerPeriod3	integer
GoalsPerPeriod4	integer
PuckTimeInZoneDF	integer	In Second
PuckTimeInZoneOF	integer	In Second
PuckTimeInZoneNT	integer	In Second
PuckTimeControlinZoneDF	integer	In Second
PuckTimeControlinZoneOF	integer	In Second
PuckTimeControlinZoneNT	integer	In Second
Shutouts	integer
TotalGoal	integer
TotalAssist	integer
TotalPoint	integer
Pim	integer
Hits	integer
FaceOffWonDefensifZone	integer
FaceOffTotalDefensifZone	integer
FaceOffWonOffensifZone	integer
FaceOffTotalOffensifZone	integer
FaceOffWonNeutralZone	integer
FaceOffTotalNeutralZone	integer
EmptyNetGoal	integer

TeamProLines

Field Name	Field Data Type	Information
TeamNumber	integer	Refer to table TeamProInfo table number field.
Day	integer	Number from 1 to 10
Line15vs5ForwardCenter	string
Line15vs5ForwardLeftWing	string
Line15vs5ForwardRightWing	string
Line15vs5ForwardTime	integer
Line15vs5ForwardPhy	integer
Line15vs5ForwardDF	integer
Line15vs5ForwardOF	integer
Line15vs5DefenseDefense1	string
Line15vs5DefenseDefense2	string
Line15vs5DefenseTime	integer
Line15vs5DefensePhy	integer
Line15vs5DefenseDF	integer
Line15vs5DefenseOF	integer
Line25vs5ForwardCenter	string
Line25vs5ForwardLeftWing	string
Line25vs5ForwardRightWing	string
Line25vs5ForwardTime	integer
Line25vs5ForwardPhy	integer
Line25vs5ForwardDF	integer
Line25vs5ForwardOF	integer
Line25vs5DefenseDefense1	string
Line25vs5DefenseDefense2	string
Line25vs5DefenseTime	integer
Line25vs5DefensePhy	integer
Line25vs5DefenseDF	integer
Line25vs5DefenseOF	integer
Line35vs5ForwardCenter	string
Line35vs5ForwardLeftWing	string
Line35vs5ForwardRightWing	string
Line35vs5ForwardTime	integer
Line35vs5ForwardPhy	integer
Line35vs5ForwardDF	integer
Line35vs5ForwardOF	integer
Line35vs5DefenseDefense1	string
Line35vs5DefenseDefense2	string
Line35vs5DefenseTime	integer
Line35vs5DefensePhy	integer
Line35vs5DefenseDF	integer
Line35vs5DefenseOF	integer
Line45vs5ForwardCenter	string
Line45vs5ForwardLeftWing	string
Line45vs5ForwardRightWing	string
Line45vs5ForwardTime	integer
Line45vs5ForwardPhy	integer
Line45vs5ForwardDF	integer
Line45vs5ForwardOF	integer
Line45vs5DefenseDefense1	string
Line45vs5DefenseDefense2	string
Line45vs5DefenseTime	integer
Line45vs5DefensePhy	integer
Line45vs5DefenseDF	integer
Line45vs5DefenseOF	integer
Line1PPForwardCenter	string
Line1PPForwardLeftWing	string
Line1PPForwardRightWing	string
Line1PPForwardTime	integer
Line1PPForwardPhy	integer
Line1PPForwardDF	integer
Line1PPForwardOF	integer
Line1PPDefenseDefense1	string
Line1PPDefenseDefense2	string
Line1PPDefenseTime	integer
Line1PPDefensePhy	integer
Line1PPDefenseDF	integer
Line1PPDefenseOF	integer
Line2PPForwardCenter	string
Line2PPForwardLeftWing	string
Line2PPForwardRightWing	string
Line2PPForwardTime	integer
Line2PPForwardPhy	integer
Line2PPForwardDF	integer
Line2PPForwardOF	integer
Line2PPDefenseDefense1	string
Line2PPDefenseDefense2	string
Line2PPDefenseTime	integer
Line2PPDefensePhy	integer
Line2PPDefenseDF	integer
Line2PPDefenseOF	integer
Line1PK4ForwardCenter	string
Line1PK4ForwardWing	string
Line1PK4ForwardTime	integer
Line1PK4ForwardPhy	integer
Line1PK4ForwardDF	integer
Line1PK4ForwardOF	integer
Line1PK4DefenseDefense1	string
Line1PK4DefenseDefense2	string
Line1PK4DefenseTime	integer
Line1PK4DefensePhy	integer
Line1PK4DefenseDF	integer
Line1PK4DefenseOF	integer
Line2PK4ForwardCenter	string
Line2PK4ForwardWing	string
Line2PK4ForwardTime	integer
Line2PK4ForwardPhy	integer
Line2PK4ForwardDF	integer
Line2PK4ForwardOF	integer
Line2PK4DefenseDefense1	string
Line2PK4DefenseDefense2	string
Line2PK4DefenseTime	integer
Line2PK4DefensePhy	integer
Line2PK4DefenseDF	integer
Line2PK4DefenseOF	integer
Line1PK3ForwardCenter	string
Line1PK3ForwardTime	integer
Line1PK3ForwardPhy	integer
Line1PK3ForwardDF	integer
Line1PK3ForwardOF	integer
Line1PK3DefenseDefense1	string
Line1PK3DefenseDefense2	string
Line1PK3DefenseTime	integer
Line1PK3DefensePhy	integer
Line1PK3DefenseDF	integer
Line1PK3DefenseOF	integer
Line2PK3ForwardCenter	string
Line2PK3ForwardTime	integer
Line2PK3ForwardPhy	integer
Line2PK3ForwardDF	integer
Line2PK3ForwardOF	integer
Line2PK3DefenseDefense1	string
Line2PK3DefenseDefense2	string
Line2PK3DefenseTime	integer
Line2PK3DefensePhy	integer
Line2PK3DefenseDF	integer
Line2PK3DefenseOF	integer
Line14VS4ForwardCenter	string
Line14VS4ForwardWing	string
Line14VS4ForwardTime	integer
Line14VS4ForwardPhy	integer
Line14VS4ForwardDF	integer
Line14VS4ForwardOF	integer
Line14VS4DefenseDefense1	string
Line14VS4DefenseDefense2	string
Line14VS4DefenseTime	integer
Line14VS4DefensePhy	integer
Line14VS4DefenseDF	integer
Line14VS4DefenseOF	integer
Line24VS4ForwardCenter	string
Line24VS4ForwardWing	string
Line24VS4ForwardTime	integer
Line24VS4ForwardPhy	integer
Line24VS4ForwardDF	integer
Line24VS4ForwardOF	integer
Line24VS4DefenseDefense1	string
Line24VS4DefenseDefense2	string
Line24VS4DefenseTime	integer
Line24VS4DefensePhy	integer
Line24VS4DefenseDF	integer
Line24VS4DefenseOF	integer
LastMinOffForwardCenter	string
LastMinOffForwardLeftWing	string
LastMinOffForwardRightWing	string
LastMinOffDefenseDefense1	string
LastMinOffDefenseDefense2	string
LastMinDefForwardCenter	string
LastMinDefForwardLeftWing	string
LastMinDefForwardRightWing	string
LastMinDefDefenseDefense1	string
LastMinDefDefenseDefense2	string
Goaler1	string
Goaler2	string
Goaler3	string
ExtraForwardPK	string
ExtraForwardN1	string
ExtraForwardN2	string
ExtraForwardN3	string
ExtraForwardPP1	string
ExtraForwardPP2	string
ExtraDefensePK2	string
ExtraDefenseN1	string
ExtraDefenseN2	string
ExtraDefenseN3	string
ExtraDefensePP	string
ExtraDefensePK1	string
PenaltyShots1	string
PenaltyShots2	string
PenaltyShots3	string
PenaltyShots4	string
PenaltyShots5	string
OTForward1	string
OTForward2	string
OTForward3	string
OTForward4	string
OTForward5	string
OTForward6	string
OTForward7	string
OTForward8	string
OTForward9	string
OTForward10	string
OTDefense1	string
OTDefense2	string
OTDefense3	string
OTDefense4	string
OTDefense5	string
Strategy1GoalDiff	integer	Winning by #1
Strategy1Phy	integer
Strategy1DF	integer
Strategy1OF	integer
Strategy2GoalDiff	integer	Winning by #2
Strategy2Phy	integer
Strategy2DF	integer
Strategy2OF	integer
Strategy3Phy	integer	Score is equal
Strategy3DF	integer
Strategy3OF	integer
Strategy4GoalDiff	integer	Losing by #1
Strategy4Phy	integer
Strategy4DF	integer
Strategy4OF	integer
Strategy5GoalDiff	integer	Losing by #1
Strategy5Phy	integer
Strategy5DF	integer
Strategy5OF	integer
PullGoalerMinPct	integer
PullGoalerMinGoal	integer
RemoveGoaliesSecond	integer

TeamProLinesNumberOnly

Field Name	Field Data Type	Information
TeamNumber	integer	Refer to table TeamProInfo table number field.
Day	integer	Number from 1 to 10
Line15vs5ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line15vs5ForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line15vs5ForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line15vs5ForwardTime	integer
Line15vs5ForwardPhy	integer
Line15vs5ForwardDF	integer
Line15vs5ForwardOF	integer
Line15vs5DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line15vs5DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line15vs5DefenseTime	integer
Line15vs5DefensePhy	integer
Line15vs5DefenseDF	integer
Line15vs5DefenseOF	integer
Line25vs5ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line25vs5ForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line25vs5ForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line25vs5ForwardTime	integer
Line25vs5ForwardPhy	integer
Line25vs5ForwardDF	integer
Line25vs5ForwardOF	integer
Line25vs5DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line25vs5DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line25vs5DefenseTime	integer
Line25vs5DefensePhy	integer
Line25vs5DefenseDF	integer
Line25vs5DefenseOF	integer
Line35vs5ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line35vs5ForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line35vs5ForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line35vs5ForwardTime	integer
Line35vs5ForwardPhy	integer
Line35vs5ForwardDF	integer
Line35vs5ForwardOF	integer
Line35vs5DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line35vs5DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line35vs5DefenseTime	integer
Line35vs5DefensePhy	integer
Line35vs5DefenseDF	integer
Line35vs5DefenseOF	integer
Line45vs5ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line45vs5ForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line45vs5ForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line45vs5ForwardTime	integer
Line45vs5ForwardPhy	integer
Line45vs5ForwardDF	integer
Line45vs5ForwardOF	integer
Line45vs5DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line45vs5DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line45vs5DefenseTime	integer
Line45vs5DefensePhy	integer
Line45vs5DefenseDF	integer
Line45vs5DefenseOF	integer
Line1PPForwardCenter	integer	Refer to table PlayerInfo table number field.
Line1PPForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line1PPForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line1PPForwardTime	integer
Line1PPForwardPhy	integer
Line1PPForwardDF	integer
Line1PPForwardOF	integer
Line1PPDefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line1PPDefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line1PPDefenseTime	integer
Line1PPDefensePhy	integer
Line1PPDefenseDF	integer
Line1PPDefenseOF	integer
Line2PPForwardCenter	integer	Refer to table PlayerInfo table number field.
Line2PPForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line2PPForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line2PPForwardTime	integer
Line2PPForwardPhy	integer
Line2PPForwardDF	integer
Line2PPForwardOF	integer
Line2PPDefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line2PPDefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line2PPDefenseTime	integer
Line2PPDefensePhy	integer
Line2PPDefenseDF	integer
Line2PPDefenseOF	integer
Line1PK4ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line1PK4ForwardWing	integer	Refer to table PlayerInfo table number field.
Line1PK4ForwardTime	integer
Line1PK4ForwardPhy	integer
Line1PK4ForwardDF	integer
Line1PK4ForwardOF	integer
Line1PK4DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line1PK4DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line1PK4DefenseTime	integer
Line1PK4DefensePhy	integer
Line1PK4DefenseDF	integer
Line1PK4DefenseOF	integer
Line2PK4ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line2PK4ForwardWing	integer	Refer to table PlayerInfo table number field.
Line2PK4ForwardTime	integer
Line2PK4ForwardPhy	integer
Line2PK4ForwardDF	integer
Line2PK4ForwardOF	integer
Line2PK4DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line2PK4DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line2PK4DefenseTime	integer
Line2PK4DefensePhy	integer
Line2PK4DefenseDF	integer
Line2PK4DefenseOF	integer
Line1PK3ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line1PK3ForwardTime	integer
Line1PK3ForwardPhy	integer
Line1PK3ForwardDF	integer
Line1PK3ForwardOF	integer
Line1PK3DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line1PK3DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line1PK3DefenseTime	integer
Line1PK3DefensePhy	integer
Line1PK3DefenseDF	integer
Line1PK3DefenseOF	integer
Line2PK3ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line2PK3ForwardTime	integer
Line2PK3ForwardPhy	integer
Line2PK3ForwardDF	integer
Line2PK3ForwardOF	integer
Line2PK3DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line2PK3DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line2PK3DefenseTime	integer
Line2PK3DefensePhy	integer
Line2PK3DefenseDF	integer
Line2PK3DefenseOF	integer
Line14VS4ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line14VS4ForwardWing	integer	Refer to table PlayerInfo table number field.
Line14VS4ForwardTime	integer
Line14VS4ForwardPhy	integer
Line14VS4ForwardDF	integer
Line14VS4ForwardOF	integer
Line14VS4DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line14VS4DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line14VS4DefenseTime	integer
Line14VS4DefensePhy	integer
Line14VS4DefenseDF	integer
Line14VS4DefenseOF	integer
Line24VS4ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line24VS4ForwardWing	integer	Refer to table PlayerInfo table number field.
Line24VS4ForwardTime	integer
Line24VS4ForwardPhy	integer
Line24VS4ForwardDF	integer
Line24VS4ForwardOF	integer
Line24VS4DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line24VS4DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line24VS4DefenseTime	integer
Line24VS4DefensePhy	integer
Line24VS4DefenseDF	integer
Line24VS4DefenseOF	integer
LastMinOffForwardCenter	integer	Refer to table PlayerInfo table number field.
LastMinOffForwardLeftWing	integer	Refer to table PlayerInfo table number field.
LastMinOffForwardRightWing	integer	Refer to table PlayerInfo table number field.
LastMinOffDefenseDefense1	integer	Refer to table PlayerInfo table number field.
LastMinOffDefenseDefense2	integer	Refer to table PlayerInfo table number field.
LastMinDefForwardCenter	integer	Refer to table PlayerInfo table number field.
LastMinDefForwardLeftWing	integer	Refer to table PlayerInfo table number field.
LastMinDefForwardRightWing	integer	Refer to table PlayerInfo table number field.
LastMinDefDefenseDefense1	integer	Refer to table PlayerInfo table number field.
LastMinDefDefenseDefense2	integer	Refer to table PlayerInfo table number field.
Goaler1	integer	Refer to table GoalerInfo table number field.
Goaler2	integer	Refer to table GoalerInfo table number field.
Goaler3	integer	Refer to table GoalerInfo table number field.
ExtraForwardPK	integer	Refer to table PlayerInfo table number field.
ExtraForwardN1	integer	Refer to table PlayerInfo table number field.
ExtraForwardN2	integer	Refer to table PlayerInfo table number field.
ExtraForwardN3	integer	Refer to table PlayerInfo table number field.
ExtraForwardPP1	integer	Refer to table PlayerInfo table number field.
ExtraForwardPP2	integer	Refer to table PlayerInfo table number field.
ExtraDefensePK2	integer	Refer to table PlayerInfo table number field.
ExtraDefenseN1	integer	Refer to table PlayerInfo table number field.
ExtraDefenseN2	integer	Refer to table PlayerInfo table number field.
ExtraDefenseN3	integer	Refer to table PlayerInfo table number field.
ExtraDefensePP	integer	Refer to table PlayerInfo table number field.
ExtraDefensePK1	integer	Refer to table PlayerInfo table number field.
PenaltyShots1	integer	Refer to table PlayerInfo table number field.
PenaltyShots2	integer	Refer to table PlayerInfo table number field.
PenaltyShots3	integer	Refer to table PlayerInfo table number field.
PenaltyShots4	integer	Refer to table PlayerInfo table number field.
PenaltyShots5	integer	Refer to table PlayerInfo table number field.
OTForward1	integer	Refer to table PlayerInfo table number field.
OTForward2	integer	Refer to table PlayerInfo table number field.
OTForward3	integer	Refer to table PlayerInfo table number field.
OTForward4	integer	Refer to table PlayerInfo table number field.
OTForward5	integer	Refer to table PlayerInfo table number field.
OTForward6	integer	Refer to table PlayerInfo table number field.
OTForward7	integer	Refer to table PlayerInfo table number field.
OTForward8	integer	Refer to table PlayerInfo table number field.
OTForward9	integer	Refer to table PlayerInfo table number field.
OTForward10	integer	Refer to table PlayerInfo table number field.
OTDefense1	integer	Refer to table PlayerInfo table number field.
OTDefense2	integer	Refer to table PlayerInfo table number field.
OTDefense3	integer	Refer to table PlayerInfo table number field.
OTDefense4	integer	Refer to table PlayerInfo table number field.
OTDefense5	integer	Refer to table PlayerInfo table number field.
Strategy1GoalDiff	integer	Winning by #1
Strategy1Phy	integer
Strategy1DF	integer
Strategy1OF	integer
Strategy2GoalDiff	integer	Winning by #2
Strategy2Phy	integer
Strategy2DF	integer
Strategy2OF	integer
Strategy3Phy	integer	Score is equal
Strategy3DF	integer
Strategy3OF	integer
Strategy4GoalDiff	integer	Losing by #1
Strategy4Phy	integer
Strategy4DF	integer
Strategy4OF	integer
Strategy5GoalDiff	integer	Losing by #1
Strategy5Phy	integer
Strategy5DF	integer
Strategy5OF	integer
PullGoalerMinPct	integer
PullGoalerMinGoal	integer
RemoveGoaliesSecond	integer
WebClientIP	string
WebClientModify	boolean

TeamFarmInfo

Field Name	Field Data Type	Information
Number	integer primary key	Multiple 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.
UniqueID	integer	This field is not used to refer anything inside the database.
Name	string	Same as table TeamFarmInfo table name field.
Abbre	string
City	string
DivisionNumber	Integer
Division	string
ConferenceNumber	Integer
Conference	string
Captain	integer	Refer to table PlayerInfo table number field.
Assistant1	integer	Refer to table PlayerInfo table number field.
Assistant2	integer	Refer to table PlayerInfo table number field.
CoachID	integer	Refer to table CoachInfo table number field.
Morale	integer
TeamOverall	integer
PlayOffEliminated	boolean
PowerRanking	integer	Only update when PowerRanking HTML is output.
PlayOffWinRound	integer	Only update in playoff. Show the number of win in current playoff round.
FullFarm	boolean
DidNotMakePlayoff	boolean
CurrentLineValid	boolean	The current lines are valid for next game?
TeamThemeID	integer	Theme ID for Logo and Color on website
WebClientIP	string
WebClientModify	boolean

TeamFarmFinance

Field Name	Field Data Type	Information
Number	integer primary key	Refer to table TeamFarmInfo table number field.
UniqueID	integer	This field is not used to refer anything inside the database.
Name	string	Same as table TeamFarmInfo table name field.
ArenaCapacityL1	integer
ArenaCapacityL2	integer
TicketPriceL1	integer
TicketPriceL2	integer
AttendanceL1	integer
AttendanceL2	integer
ScheduleGameInAYear	integer
ScheduleHomeGameInAYear	integer
SalaryCapToDate	currency
SalaryCapPerDay	currency
TotalPlayersSalaries	currency
TotalPlayersSalariesAverage	currency
ExpensePerDay	currency
EstimatedRevenue	currency
EstimatedSeasonExpense	currency
TotalAttendance	currency
TotalIncome	currency
ExpenseThisSeason	currency
SeasonTicketPCT	integer
TeamPopularity	integer
PlayerInSalaryCap	integer	Show the number of player in the salary cap.
PlayerOutofSalaryCap	integer	Show the number of player out the salary cap.
WebClientIP	string
WebClientModify	boolean

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 Name	Field Data Type	Information
Number	integer primary key	Refer to table TeamFarmInfo table number field.
UniqueID	integer	This field is not used to refer anything inside the database.
Name	string	Same as table TeamFarmInfo table name field.
TeamThemeID	integer	Theme ID for Logo and Color on website
Last10W	integer
Last10L	integer
Last10T	integer
Last10OTW	integer
Last10OTL	integer
Last10SOW	integer
Last10SOL	integer
GP	integer
W	integer
L	integer
T	integer
OTW	integer
OTL	integer
SOW	integer
SOL	integer
Points	integer
GF	integer
GA	integer
HomeGP	integer
HomeW	integer
HomeL	integer
HomeT	integer
HomeOTW	integer
HomeOTL	integer
HomeSOW	integer
HomeSOL	integer
HomeGF	integer
HomeGA	integer
StandingPlayoffTitle	string
Streak	string
PPAttemp	integer
PPGoal	integer
PKAttemp	integer
PKGoalGA	integer
PKGoalGF	integer
ShotsFor	integer
ShotsAga	integer
ShotsBlock	integer
ShotsPerPeriod1	integer
ShotsPerPeriod2	integer
ShotsPerPeriod3	integer
ShotsPerPeriod4	integer
GoalsPerPeriod1	integer
GoalsPerPeriod2	integer
GoalsPerPeriod3	integer
GoalsPerPeriod4	integer
PuckTimeInZoneDF	integer	In Second
PuckTimeInZoneOF	integer	In Second
PuckTimeInZoneNT	integer	In Second
PuckTimeControlinZoneDF	integer	In Second
PuckTimeControlinZoneOF	integer	In Second
PuckTimeControlinZoneNT	integer	In Second
Shutouts	integer
TotalGoal	integer
TotalAssist	integer
TotalPoint	integer
Pim	integer
Hits	integer
FaceOffWonDefensifZone	integer
FaceOffTotalDefensifZone	integer
FaceOffWonOffensifZone	integer
FaceOffTotalOffensifZone	integer
FaceOffWonNeutralZone	integer
FaceOffTotalNeutralZone	integer
EmptyNetGoal	integer

TeamFarmStatVS

Field Name	Field Data Type	Information
Number	integer primary key	Refer to table TeamFarmInfo table number field.
UniqueID	integer	This field is not used to refer anything inside the database.
TeamNumber	integer	Refer to table TeamFarmInfo table number field.
TeamName	string	Same as table TeamFarmInfo table name field.
TeamVSNumber	integer	Refer to table TeamFarmInfo table number field.
TeamVSName	string	Same as table TeamFarmInfo table name field except 101 = 'VS Division', 102 = 'VS Conference', 103 = 'Since Last GM Reset'.
TeamVSNumberThemeID	integer	Theme ID for Logo and Color on website
GP	integer
W	integer
L	integer
T	integer
OTW	integer
OTL	integer
SOW	integer
SOL	integer
Points	integer
GF	integer
GA	integer
HomeGP	integer
HomeW	integer
HomeL	integer
HomeT	integer
HomeOTW	integer
HomeOTL	integer
HomeSOW	integer
HomeSOL	integer
HomeGF	integer
HomeGA	integer
StandingPlayoffTitle	string
Streak	string
PPAttemp	integer
PPGoal	integer
PKAttemp	integer
PKGoalGA	integer
PKGoalGF	integer
ShotsFor	integer
ShotsAga	integer
ShotsBlock	integer
ShotsPerPeriod1	integer
ShotsPerPeriod2	integer
ShotsPerPeriod3	integer
ShotsPerPeriod4	integer
GoalsPerPeriod1	integer
GoalsPerPeriod2	integer
GoalsPerPeriod3	integer
GoalsPerPeriod4	integer
PuckTimeInZoneDF	integer	In Second
PuckTimeInZoneOF	integer	In Second
PuckTimeInZoneNT	integer	In Second
PuckTimeControlinZoneDF	integer	In Second
PuckTimeControlinZoneOF	integer	In Second
PuckTimeControlinZoneNT	integer	In Second
Shutouts	integer
TotalGoal	integer
TotalAssist	integer
TotalPoint	integer
Pim	integer
Hits	integer
FaceOffWonDefensifZone	integer
FaceOffTotalDefensifZone	integer
FaceOffWonOffensifZone	integer
FaceOffTotalOffensifZone	integer
FaceOffWonNeutralZone	integer
FaceOffTotalNeutralZone	integer
EmptyNetGoal	integer

TeamFarmLines

Field Name	Field Data Type	Information
TeamNumber	integer	Refer to table TeamFarmInfo table number field.
Day	integer	Number from 1 to 10
Line15vs5ForwardCenter	string
Line15vs5ForwardLeftWing	string
Line15vs5ForwardRightWing	string
Line15vs5ForwardTime	integer
Line15vs5ForwardPhy	integer
Line15vs5ForwardDF	integer
Line15vs5ForwardOF	integer
Line15vs5DefenseDefense1	string
Line15vs5DefenseDefense2	string
Line15vs5DefenseTime	integer
Line15vs5DefensePhy	integer
Line15vs5DefenseDF	integer
Line15vs5DefenseOF	integer
Line25vs5ForwardCenter	string
Line25vs5ForwardLeftWing	string
Line25vs5ForwardRightWing	string
Line25vs5ForwardTime	integer
Line25vs5ForwardPhy	integer
Line25vs5ForwardDF	integer
Line25vs5ForwardOF	integer
Line25vs5DefenseDefense1	string
Line25vs5DefenseDefense2	string
Line25vs5DefenseTime	integer
Line25vs5DefensePhy	integer
Line25vs5DefenseDF	integer
Line25vs5DefenseOF	integer
Line35vs5ForwardCenter	string
Line35vs5ForwardLeftWing	string
Line35vs5ForwardRightWing	string
Line35vs5ForwardTime	integer
Line35vs5ForwardPhy	integer
Line35vs5ForwardDF	integer
Line35vs5ForwardOF	integer
Line35vs5DefenseDefense1	string
Line35vs5DefenseDefense2	string
Line35vs5DefenseTime	integer
Line35vs5DefensePhy	integer
Line35vs5DefenseDF	integer
Line35vs5DefenseOF	integer
Line45vs5ForwardCenter	string
Line45vs5ForwardLeftWing	string
Line45vs5ForwardRightWing	string
Line45vs5ForwardTime	integer
Line45vs5ForwardPhy	integer
Line45vs5ForwardDF	integer
Line45vs5ForwardOF	integer
Line45vs5DefenseDefense1	string
Line45vs5DefenseDefense2	string
Line45vs5DefenseTime	integer
Line45vs5DefensePhy	integer
Line45vs5DefenseDF	integer
Line45vs5DefenseOF	integer
Line1PPForwardCenter	string
Line1PPForwardLeftWing	string
Line1PPForwardRightWing	string
Line1PPForwardTime	integer
Line1PPForwardPhy	integer
Line1PPForwardDF	integer
Line1PPForwardOF	integer
Line1PPDefenseDefense1	string
Line1PPDefenseDefense2	string
Line1PPDefenseTime	integer
Line1PPDefensePhy	integer
Line1PPDefenseDF	integer
Line1PPDefenseOF	integer
Line2PPForwardCenter	string
Line2PPForwardLeftWing	string
Line2PPForwardRightWing	string
Line2PPForwardTime	integer
Line2PPForwardPhy	integer
Line2PPForwardDF	integer
Line2PPForwardOF	integer
Line2PPDefenseDefense1	string
Line2PPDefenseDefense2	string
Line2PPDefenseTime	integer
Line2PPDefensePhy	integer
Line2PPDefenseDF	integer
Line2PPDefenseOF	integer
Line1PK4ForwardCenter	string
Line1PK4ForwardWing	string
Line1PK4ForwardTime	integer
Line1PK4ForwardPhy	integer
Line1PK4ForwardDF	integer
Line1PK4ForwardOF	integer
Line1PK4DefenseDefense1	string
Line1PK4DefenseDefense2	string
Line1PK4DefenseTime	integer
Line1PK4DefensePhy	integer
Line1PK4DefenseDF	integer
Line1PK4DefenseOF	integer
Line2PK4ForwardCenter	string
Line2PK4ForwardWing	string
Line2PK4ForwardTime	integer
Line2PK4ForwardPhy	integer
Line2PK4ForwardDF	integer
Line2PK4ForwardOF	integer
Line2PK4DefenseDefense1	string
Line2PK4DefenseDefense2	string
Line2PK4DefenseTime	integer
Line2PK4DefensePhy	integer
Line2PK4DefenseDF	integer
Line2PK4DefenseOF	integer
Line1PK3ForwardCenter	string
Line1PK3ForwardTime	integer
Line1PK3ForwardPhy	integer
Line1PK3ForwardDF	integer
Line1PK3ForwardOF	integer
Line1PK3DefenseDefense1	string
Line1PK3DefenseDefense2	string
Line1PK3DefenseTime	integer
Line1PK3DefensePhy	integer
Line1PK3DefenseDF	integer
Line1PK3DefenseOF	integer
Line2PK3ForwardCenter	string
Line2PK3ForwardTime	integer
Line2PK3ForwardPhy	integer
Line2PK3ForwardDF	integer
Line2PK3ForwardOF	integer
Line2PK3DefenseDefense1	string
Line2PK3DefenseDefense2	string
Line2PK3DefenseTime	integer
Line2PK3DefensePhy	integer
Line2PK3DefenseDF	integer
Line2PK3DefenseOF	integer
Line14VS4ForwardCenter	string
Line14VS4ForwardWing	string
Line14VS4ForwardTime	integer
Line14VS4ForwardPhy	integer
Line14VS4ForwardDF	integer
Line14VS4ForwardOF	integer
Line14VS4DefenseDefense1	string
Line14VS4DefenseDefense2	string
Line14VS4DefenseTime	integer
Line14VS4DefensePhy	integer
Line14VS4DefenseDF	integer
Line14VS4DefenseOF	integer
Line24VS4ForwardCenter	string
Line24VS4ForwardWing	string
Line24VS4ForwardTime	integer
Line24VS4ForwardPhy	integer
Line24VS4ForwardDF	integer
Line24VS4ForwardOF	integer
Line24VS4DefenseDefense1	string
Line24VS4DefenseDefense2	string
Line24VS4DefenseTime	integer
Line24VS4DefensePhy	integer
Line24VS4DefenseDF	integer
Line24VS4DefenseOF	integer
LastMinOffForwardCenter	string
LastMinOffForwardLeftWing	string
LastMinOffForwardRightWing	string
LastMinOffDefenseDefense1	string
LastMinOffDefenseDefense2	string
LastMinDefForwardCenter	string
LastMinDefForwardLeftWing	string
LastMinDefForwardRightWing	string
LastMinDefDefenseDefense1	string
LastMinDefDefenseDefense2	string
Goaler1	string
Goaler2	string
Goaler3	string
ExtraForwardPK	string
ExtraForwardN1	string
ExtraForwardN2	string
ExtraForwardN3	string
ExtraForwardPP1	string
ExtraForwardPP2	string
ExtraDefensePK2	string
ExtraDefenseN1	string
ExtraDefenseN2	string
ExtraDefenseN3	string
ExtraDefensePP	string
ExtraDefensePK1	string
PenaltyShots1	string
PenaltyShots2	string
PenaltyShots3	string
PenaltyShots4	string
PenaltyShots5	string
OTForward1	string
OTForward2	string
OTForward3	string
OTForward4	string
OTForward5	string
OTForward6	string
OTForward7	string
OTForward8	string
OTForward9	string
OTForward10	string
OTDefense1	string
OTDefense2	string
OTDefense3	string
OTDefense4	string
OTDefense5	string
Strategy1GoalDiff	integer	Winning by #1
Strategy1Phy	integer
Strategy1DF	integer
Strategy1OF	integer
Strategy2GoalDiff	integer	Winning by #2
Strategy2Phy	integer
Strategy2DF	integer
Strategy2OF	integer
Strategy3Phy	integer	Score is equal
Strategy3DF	integer
Strategy3OF	integer
Strategy4GoalDiff	integer	Losing by #1
Strategy4Phy	integer
Strategy4DF	integer
Strategy4OF	integer
Strategy5GoalDiff	integer	Losing by #1
Strategy5Phy	integer
Strategy5DF	integer
Strategy5OF	integer
PullGoalerMinPct	integer
PullGoalerMinGoal	integer
RemoveGoaliesSecond	integer

TeamFarmLinesNumberOnly

Field Name	Field Data Type	Information
TeamNumber	integer	Refer to table TeamFarmInfo table number field.
Day	integer	Number from 1 to 10
Line15vs5ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line15vs5ForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line15vs5ForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line15vs5ForwardTime	integer
Line15vs5ForwardPhy	integer
Line15vs5ForwardDF	integer
Line15vs5ForwardOF	integer
Line15vs5DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line15vs5DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line15vs5DefenseTime	integer
Line15vs5DefensePhy	integer
Line15vs5DefenseDF	integer
Line15vs5DefenseOF	integer
Line25vs5ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line25vs5ForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line25vs5ForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line25vs5ForwardTime	integer
Line25vs5ForwardPhy	integer
Line25vs5ForwardDF	integer
Line25vs5ForwardOF	integer
Line25vs5DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line25vs5DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line25vs5DefenseTime	integer
Line25vs5DefensePhy	integer
Line25vs5DefenseDF	integer
Line25vs5DefenseOF	integer
Line35vs5ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line35vs5ForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line35vs5ForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line35vs5ForwardTime	integer
Line35vs5ForwardPhy	integer
Line35vs5ForwardDF	integer
Line35vs5ForwardOF	integer
Line35vs5DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line35vs5DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line35vs5DefenseTime	integer
Line35vs5DefensePhy	integer
Line35vs5DefenseDF	integer
Line35vs5DefenseOF	integer
Line45vs5ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line45vs5ForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line45vs5ForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line45vs5ForwardTime	integer
Line45vs5ForwardPhy	integer
Line45vs5ForwardDF	integer
Line45vs5ForwardOF	integer
Line45vs5DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line45vs5DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line45vs5DefenseTime	integer
Line45vs5DefensePhy	integer
Line45vs5DefenseDF	integer
Line45vs5DefenseOF	integer
Line1PPForwardCenter	integer	Refer to table PlayerInfo table number field.
Line1PPForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line1PPForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line1PPForwardTime	integer
Line1PPForwardPhy	integer
Line1PPForwardDF	integer
Line1PPForwardOF	integer
Line1PPDefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line1PPDefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line1PPDefenseTime	integer
Line1PPDefensePhy	integer
Line1PPDefenseDF	integer
Line1PPDefenseOF	integer
Line2PPForwardCenter	integer	Refer to table PlayerInfo table number field.
Line2PPForwardLeftWing	integer	Refer to table PlayerInfo table number field.
Line2PPForwardRightWing	integer	Refer to table PlayerInfo table number field.
Line2PPForwardTime	integer
Line2PPForwardPhy	integer
Line2PPForwardDF	integer
Line2PPForwardOF	integer
Line2PPDefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line2PPDefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line2PPDefenseTime	integer
Line2PPDefensePhy	integer
Line2PPDefenseDF	integer
Line2PPDefenseOF	integer
Line1PK4ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line1PK4ForwardWing	integer	Refer to table PlayerInfo table number field.
Line1PK4ForwardTime	integer
Line1PK4ForwardPhy	integer
Line1PK4ForwardDF	integer
Line1PK4ForwardOF	integer
Line1PK4DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line1PK4DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line1PK4DefenseTime	integer
Line1PK4DefensePhy	integer
Line1PK4DefenseDF	integer
Line1PK4DefenseOF	integer
Line2PK4ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line2PK4ForwardWing	integer	Refer to table PlayerInfo table number field.
Line2PK4ForwardTime	integer
Line2PK4ForwardPhy	integer
Line2PK4ForwardDF	integer
Line2PK4ForwardOF	integer
Line2PK4DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line2PK4DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line2PK4DefenseTime	integer
Line2PK4DefensePhy	integer
Line2PK4DefenseDF	integer
Line2PK4DefenseOF	integer
Line1PK3ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line1PK3ForwardTime	integer
Line1PK3ForwardPhy	integer
Line1PK3ForwardDF	integer
Line1PK3ForwardOF	integer
Line1PK3DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line1PK3DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line1PK3DefenseTime	integer
Line1PK3DefensePhy	integer
Line1PK3DefenseDF	integer
Line1PK3DefenseOF	integer
Line2PK3ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line2PK3ForwardTime	integer
Line2PK3ForwardPhy	integer
Line2PK3ForwardDF	integer
Line2PK3ForwardOF	integer
Line2PK3DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line2PK3DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line2PK3DefenseTime	integer
Line2PK3DefensePhy	integer
Line2PK3DefenseDF	integer
Line2PK3DefenseOF	integer
Line14VS4ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line14VS4ForwardWing	integer	Refer to table PlayerInfo table number field.
Line14VS4ForwardTime	integer
Line14VS4ForwardPhy	integer
Line14VS4ForwardDF	integer
Line14VS4ForwardOF	integer
Line14VS4DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line14VS4DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line14VS4DefenseTime	integer
Line14VS4DefensePhy	integer
Line14VS4DefenseDF	integer
Line14VS4DefenseOF	integer
Line24VS4ForwardCenter	integer	Refer to table PlayerInfo table number field.
Line24VS4ForwardWing	integer	Refer to table PlayerInfo table number field.
Line24VS4ForwardTime	integer
Line24VS4ForwardPhy	integer
Line24VS4ForwardDF	integer
Line24VS4ForwardOF	integer
Line24VS4DefenseDefense1	integer	Refer to table PlayerInfo table number field.
Line24VS4DefenseDefense2	integer	Refer to table PlayerInfo table number field.
Line24VS4DefenseTime	integer
Line24VS4DefensePhy	integer
Line24VS4DefenseDF	integer
Line24VS4DefenseOF	integer
LastMinOffForwardCenter	integer	Refer to table PlayerInfo table number field.
LastMinOffForwardLeftWing	integer	Refer to table PlayerInfo table number field.
LastMinOffForwardRightWing	integer	Refer to table PlayerInfo table number field.
LastMinOffDefenseDefense1	integer	Refer to table PlayerInfo table number field.
LastMinOffDefenseDefense2	integer	Refer to table PlayerInfo table number field.
LastMinDefForwardCenter	integer	Refer to table PlayerInfo table number field.
LastMinDefForwardLeftWing	integer	Refer to table PlayerInfo table number field.
LastMinDefForwardRightWing	integer	Refer to table PlayerInfo table number field.
LastMinDefDefenseDefense1	integer	Refer to table PlayerInfo table number field.
LastMinDefDefenseDefense2	integer	Refer to table PlayerInfo table number field.
Goaler1	integer	Refer to table Goaler table number field.
Goaler2	integer	Refer to table Goaler table number field.
Goaler3	integer	Refer to table Goaler table number field.
ExtraForwardPK	integer	Refer to table PlayerInfo table number field.
ExtraForwardN1	integer	Refer to table PlayerInfo table number field.
ExtraForwardN2	integer	Refer to table PlayerInfo table number field.
ExtraForwardN3	integer	Refer to table PlayerInfo table number field.
ExtraForwardPP1	integer	Refer to table PlayerInfo table number field.
ExtraForwardPP2	integer	Refer to table PlayerInfo table number field.
ExtraDefensePK2	integer	Refer to table PlayerInfo table number field.
ExtraDefenseN1	integer	Refer to table PlayerInfo table number field.
ExtraDefenseN2	integer	Refer to table PlayerInfo table number field.
ExtraDefenseN3	integer	Refer to table PlayerInfo table number field.
ExtraDefensePP	integer	Refer to table PlayerInfo table number field.
ExtraDefensePK1	integer	Refer to table PlayerInfo table number field.
PenaltyShots1	integer	Refer to table PlayerInfo table number field.
PenaltyShots2	integer	Refer to table PlayerInfo table number field.
PenaltyShots3	integer	Refer to table PlayerInfo table number field.
PenaltyShots4	integer	Refer to table PlayerInfo table number field.
PenaltyShots5	integer	Refer to table PlayerInfo table number field.
OTForward1	integer	Refer to table PlayerInfo table number field.
OTForward2	integer	Refer to table PlayerInfo table number field.
OTForward3	integer	Refer to table PlayerInfo table number field.
OTForward4	integer	Refer to table PlayerInfo table number field.
OTForward5	integer	Refer to table PlayerInfo table number field.
OTForward6	integer	Refer to table PlayerInfo table number field.
OTForward7	integer	Refer to table PlayerInfo table number field.
OTForward8	integer	Refer to table PlayerInfo table number field.
OTForward9	integer	Refer to table PlayerInfo table number field.
OTForward10	integer	Refer to table PlayerInfo table number field.
OTDefense1	integer	Refer to table PlayerInfo table number field.
OTDefense2	integer	Refer to table PlayerInfo table number field.
OTDefense3	integer	Refer to table PlayerInfo table number field.
OTDefense4	integer	Refer to table PlayerInfo table number field.
OTDefense5	integer	Refer to table PlayerInfo table number field.
Strategy1GoalDiff	integer	Winning by #1
Strategy1Phy	integer
Strategy1DF	integer
Strategy1OF	integer
Strategy2GoalDiff	integer	Winning by #2
Strategy2Phy	integer
Strategy2DF	integer
Strategy2OF	integer
Strategy3Phy	integer	Score is equal
Strategy3DF	integer
Strategy3OF	integer
Strategy4GoalDiff	integer	Losing by #1
Strategy4Phy	integer
Strategy4DF	integer
Strategy4OF	integer
Strategy5GoalDiff	integer	Losing by #1
Strategy5Phy	integer
Strategy5DF	integer
Strategy5OF	integer
PullGoalerMinPct	integer
PullGoalerMinGoal	integer
RemoveGoaliesSecond	integer
WebClientIP	string
WebClientModify	boolean

DraftPick

Field Name	Field Data Type	Information
InternalNumber	integer
TeamNumber	integer	Refer to table TeamProInfo table number field.
FromTeam	integer	Refer to table TeamProInfo table number field.
FromTeamAbbre	string
FromTeamThemeID	integer	Theme ID for Logo and Color on website
Year	integer
Round	integer
ConditionalTrade	string	Show the Team Pro Abbreviation of the Team who a condition is apply
ConditionalTradeExplication	string

Prospects

Field Name	Field Data Type	Information
Number	integer primary key
Name	string
TeamNumber	integer	Refer to table TeamProInfo table number field.
Year	integer
OverallPick	integer
OriginalTeam	integer	The team who originaly draft the player. Refer to table TeamProInfo table number field.
Information	string
URLLink	string
SignatureDate	timestamp	Show the Date as signed in team
LastTradeDate	timestamp	Show the Date the last trade for this prospect
WebClientModify	boolean

SchedulePro

Field Name	Field Data Type	Information
GameNumber	integer primary key
Day	integer
Play	boolean
VisitorTeam	integer	Refer to table TeamProInfo table number field.
HomeTeam	integer	Refer to table TeamProInfo table number field.
VisitorTeamName	string
HomeTeamName	string
VisitorTeamAbbre	string
HomeTeamAbbre	string
VisitorScore	integer
HomeScore	integer
VisitorTeamThemeID	integer	Theme ID for Logo and Color on website
HomeTeamThemeID	integer	Theme ID for Logo and Color on website
Overtime	boolean
Shootout	boolean
Link	boolean

ScheduleFarm

Field Name	Field Data Type	Information
GameNumber	integer primary key
Day	integer
Play	boolean
VisitorTeam	integer	Refer to table TeamFarmInfo table number field.
HomeTeam	integer	Refer to table TeamFarmInfo table number field.
VisitorTeamName	string
HomeTeamName	string
VisitorTeamAbbre	string
HomeTeamAbbre	string
VisitorScore	integer
VisitorTeamThemeID	integer	Theme ID for Logo and Color on website
HomeTeamThemeID	integer	Theme ID for Logo and Color on website
HomeScore	integer
Overtime	boolean
Shootout	boolean
Link	boolean

LeagueGeneral

Field Name	Field Data Type	Information
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
OutputFileFormat	string
LeagueOwner	string
NumbersOfTeam	integer
Abbre	string
LeagueYear	integer
LeagueEngine	integer	0 = 2.0 / 1 = 1.1 / 2 = 2.1 / 3 = 1.5
FarmLeagueEngine	integer	0 = 2.0 / 1 = 1.1 / 2 = 2.1 / 3 = 1.5
TradeDeadLine	Real
TradeDeadLinePass	boolean
WaiverDeadLine	integer
PointSystemW	integer
PointSystemL	integer
PointSystemT	integer
PointSystemSOW	integer
PointSystemSOL	integer
PointSystemOTW	integer
PointSystemOTL	integer
PointSystemSO	boolean
NoOvertime	boolean
TieBreaker2010	boolean
TieBreaker2019	boolean
ProStandingbyPCT	boolean
FarmStandingbyPCT	boolean
ProOT3vs3	boolean
FarmOT3vs3	boolean
ProOTLinesUp	boolean
FarmOTLinesUp	boolean
FarmNumberDivisionLeader	integer
ProNumberDivisionLeader	integer
PlayOffEndPro	boolean	Pro Playoff Done
PlayOffEndFarm	boolean	Farm Playoff Done
PlayOffRound	integer
ProPlayOffLength	integer
ProHowManyPlayOffTeam	integer
FarmPlayOffLength	integer
FarmHowManyPlayOffTeam	integer
PlayOffWinnerPro	integer	Refer to table TeamProInfo table number field.
PlayOffWinnerFarm	integer	Refer 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
FarmScheduleTotalDay	integer
ScheduleNextDay	integer
ProDivisionNewNHLPlayoff	boolean
FarmDivisionNewNHLPlayoff	boolean
DefaultSimulationPerDay	integer
LastTransactionOutput	integer
DraftPickByYear	integer
LeagueWebPassword	string
LeagueWebGuestPassword	string
SeasonStarted	boolean
SeasonEnd	boolean
OffSeason	boolean
PlayOffStarted	boolean
PlayOffEnd	boolean
FantasyDraftStart	boolean
EntryDraftStart	boolean
EntryDraftStop	boolean
Today3StarPro1	string	First Star
Today3StarPro2	string	Second Star
Today3StarPro3	string	Third Star
Today3StarPro	string	The three star in the same string
Today3StarFarm1	string	First Star
Today3StarFarm2	string	Second Star
Today3StarFarm3	string	Third Star
Today3StarFarm	string	The three star in the same string
Days73StarPro1	string	First Star
Days73StarPro2	string	Second Star
Days73StarPro3	string	Third Star
Days73StarPro	string	The three star in the same string
Days73StarFarm1	string	First Star
Days73StarFarm2	string	Second Star
Days73StarFarm3	string	Third Star
Days73StarFarm	string	The three star in the same string
Days303StarPro1	string	First Star
Days303StarPro2	string	Second Star
Days303StarPro3	string	Third Star
Days303StarPro	string	The three star in the same string
Days303StarFarm1	string	First Star
Days303StarFarm2	string	Second Star
Days303StarFarm3	string	Third Star
Days303StarFarm	string	The three star in the same string
ExpireWarningDateYear	integer
ExpireWarningDateMonth	integer
Version	integer	Version of the STHS use to create the database
DatabaseCreationDate	timestamp	When the Database was create by the simulator

LeagueSimulation

Field Name	Field Data Type	Information
WaiversEnable	boolean
ProInjuryEnable	boolean
FarmInjuryEnable	boolean
FinanceEnable	boolean
ProSuspensionEnable	boolean
FarmSuspensionEnable	boolean
FarmEnable	boolean
FarmFinanceEnable	boolean
FullFarmEnable	boolean
ProForwardPlayAllPosition	boolean
FarmForwardPlayAllPosition	boolean
ProCoachDisabled	boolean
FarmCoachDisabled	boolean
ProMoraleDisabled	boolean
FarmMoraleDisabled	boolean
ProFightDisabled	boolean
FarmFightDisabled	boolean
ProPenaltyDisabled	boolean
FarmPenaltyDisabled	boolean
ProTeamPopularity	boolean
FarmTeamPopularity	boolean
ProFight	integer
ProCoach	integer
ProMorale	integer
ProInjury	integer
ProFinance	integer
ProShots	integer
ProGoals	integer
ProPenalty	integer
ProHits	integer
ProPP	integer
FarmFight	integer
FarmCoach	integer
FarmMorale	integer
FarmInjury	integer
FarmFinance	integer
FarmShots	integer
FarmGoals	integer
FarmPenalty	integer
FarmHits	integer
FarmPP	integer
ProTwoConference	boolean
FarmTwoConference	boolean

LeagueFinance

Field Name	Field Data Type	Information
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	integer	0 = 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 Name	Field Data Type	Information
UnassignedasFreeAgent	boolean
OutputMergeAllWinStreak	boolean
InchInsteadofCM	boolean
LBSInsteadofKG	boolean
MergeProFarmRoster	boolean
MergeRosterPlayerInfo	boolean
OutputOrder	integer	0 = 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
ProMinimumGamePlayerLeader	integer
FarmMinimumGamePlayerLeader	integer
PlayersMugShotBaseURL	string
PlayersMugShotFileExtension	string
ShowExpansionDraftLinkinTopMenu	boolean
ShowFarmScoreinPHPHomePage	boolean
NumberofNewsinPHPHomePage	integer
NumberofLatestScoreinPHPHomePage	integer
NumberofHeadlinesDayinPHPHomePage	integer
ShowWebClientInDymanicWebsite	boolean
ShowRSSFeed	boolean
EmailServer	string
EmailServerReplyAddress	string
JerseyNumberInWebsite	string
OutputJSONGame	boolean
OutputGameHTMLToSQLiteDatabase	boolean
OutputGameJSONToSQLiteDatabase	boolean
DoNotOutputBoxscoreUniquePage	boolean
SeparateCareerStatFromTeamPage	boolean
HideEmailMessengerAddressOnWebsite	boolean
ShowBannerForTeam	boolean
WebsiteURL	string
OutputCustomURL1	string
OutputCustomURL1Name	string
OutputCustomURL2	string
OutputCustomURL2Name	string

LeagueWebClient

Field Name	Field Data Type	Information
BlockPlayerFromPlayingLines12	boolean
BlockPlayerFromPlayingLines123	boolean
BlockPlayerFromPlayingLines12inPPPK	boolean
EmergencyRecallLimitbyTeam	integer
DisableMultipleLinesinRow	boolean
MaximumPlayerPerTeam	integer
MinimumPlayerPerTeam	integer
BlockSenttoFarmAfterTradeDeadline	boolean
ProTeamEliminatedCannotSendPlayerstoFarm	boolean
ForceCorrectLinesupbeforeSaving	boolean
ForceCorrect10LinesupbeforeSaving	boolean
GMCanChangeTicketPrice	boolean
MaxFreeAgentOffer	integer
MinimumFreeAgentsOffer	integer
BlockAutoRosterFunctionForGM	boolean
BlockAutoProLineFunctionForGM	boolean
BlockAutoFarmLineFunctionForGM	boolean
BlockCoachChangeForGM	boolean
AllowTradefromWebsite	boolean
AllowDraftSelectionfromWebsite	boolean
AllowFreeAgentOfferfromWebsite	boolean
AllowProspectEditionFromWebsite	boolean
AllowPlayerEditionFromWebsite	boolean
AllowNextYearFreeAgentsInSTHSClient	boolean
AllowFreeAgentSalaryRequestInSTHSClient	boolean
ProForceGameStrategiesTo	integer
ProGoalerInGame	integer
ProMinC	integer
ProMinD	integer
ProMinForward	integer
ProMinLW	integer
ProMinRW	integer
ProPlayerInGame	integer
ProPlayerLimit	integer
ProCustomOTLines	boolean
ProForceGameStrategiesAt5	boolean
ProMaxTicketPrice1	integer
ProMaxTicketPrice2	integer
ProMaxTicketPrice3	integer
ProMaxTicketPrice4	integer
ProMaxTicketPrice5	integer
FarmForceGameStrategiesTo	integer
FarmGoalerInGame	integer
FarmMinC	integer
FarmMinD	integer
FarmMinForward	integer
FarmMinLW	integer
FarmMinRW	integer
FarmPlayerInGame	integer
FarmPlayerLimit	integer
FarmCustomOTLines	boolean
FarmForceGameStrategiesAt5	boolean
FarmMaxTicketPrice1	integer
FarmMaxTicketPrice2	integer
MaxFarmOv	integer
MaxFarmOvGoaler	integer
MaximumLinesPCT1	integer	Normal #1
MaximumLinesPCT2	integer	Normal #2
MaximumLinesPCT3	integer	Normal #3
MaximumLinesPCT4	integer	Normal #4
MaximumLinesPCT5	integer	PP/PK/PK3/4vs #1
MaximumLinesPCT6	integer	PP/PK/PK3/4vs #2
DefaultLinesPCT1	integer	Normal #1
DefaultLinesPCT2	integer	Normal #2
DefaultLinesPCT3	integer	Normal #3
DefaultLinesPCT4	integer	Normal #3
DefaultLinesPCT5	integer	PP/PK/PK3/4vs #1
DefaultLinesPCT6	integer	PP/PK/PK3/4vs #2
ProDefaultTicketPrice1	integer
ProDefaultTicketPrice2	integer
ProDefaultTicketPrice3	integer
ProDefaultTicketPrice4	integer
ProDefaultTicketPrice5	integer
FarmDefaultTicketPrice1	integer
FarmDefaultTicketPrice2	integer
PullGoalerMinGoal	integer
PullGoalerMinGoalEnforce	integer
PullGoalerMinPct	integer
PullGoalerRemoveGoaliesSecond	integer
PullGoalerMax	integer

RankingOrder

Field Name	Field Data Type	Information
Type	integer	0 = Overall, 1 = Conference
TeamOrder	integer
TeamProNumber	integer	Refer to table TeamProInfo table number field.
TeamProPoint	integer
TeamFarmNumber	integer	Refer to table TeamFarmInfo table number field.
TeamFarmPoint	integer

LeagueLog

Field Name	Field Data Type	Information
Number	integer primary key
Text	string	Original Text in the STHS with HTML formatting.
DateTime	timestamp	Extract DateTime from Text.
DateTxt	string	In Format YYYY-MMM-DD
TransactionType	integer	0 = Other, 1 = Trade, 2 = Injury, 3 = Waiver, 4 = SendToPro, 5 = SendToFarm, 6 = Suspension, 7 = RosterLineError, 8 = Information, 9 = Players, 10 = Team, 11 = OptionChange
Color	color	The color the transaction should show up in the color based on the option select in the simulator.

TradeLog

Field Name	Field Data Type	Information
Number	integer primary key
SendingTeamThemeID	integer
SendingTeamNumber	integer
SendingTeamName	integer
ReceivingTeamThemeID	integer
ReceivingTeamNumber	integer
ReceivingTeamName	integer
ReceivingTeamText	string
DateTxt	string	In Format YYYY-MMM-DD

TeamLog

Field Name	Field Data Type	Information
Number	integer primary key
TeamNumber	integer	Refer to table TeamProInfo table number field.
Text	string	Original Text in the STHS with HTML formatting.
DateTime	timestamp	Extract DateTime from Text.
DateTxt	string	In Format YYYY-MMM-DD.

TodayGame

Field Name	Field Data Type	Information
GameNumber	string	It'll always contain Pro or Farm and the game number.
Link	string	Link to the URL of game.
Note	string
VisitorTeamNumber	integer
VisitorTeam	string
VisitorTeamAbbre	string
VisitorTeamShots	integer
VisitorTeamShotsAttemp	integer
VisitorTeamScore	integer
VisitorTeamGoal	string
VisitorTeamGoaler	string
VisitorTeamThemeID	integer	Theme ID for Logo and Color on website
HomeTeamNumber	integer
HomeTeam	string
HomeTeamAbbre	string
HomeTeamShots	integer
HomeTeamShotsAttemp	integer
HomeTeamScore	integer
HomeTeamGoal	string
HomeTeamGoaler	string
HomeTeamThemeID	integer	Theme ID for Logo and Color on website
Star1	string	First Star
Star2	string	Second Star
Star3	string	Third Star

Waiver

Field Name	Field Data Type	Information
Player	integer	If 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.
PlayerNameOV	string	Player's Name with is overall inside ( ).
FromTeam	integer	Refer to table TeamProInfo table number field.
ToTeam	integer	Refer to table TeamProInfo table number field.
DayPutOnWaiver	integer
DayRemoveFromWaiver	integer

WaiverOrder

Field Name	Field Data Type	Information
Player	integer
TeamProNumber	integer	Refer to table TeamProInfo table number field.

WaiverSendTo

Field Name	Field Data Type	Information
Player	integer
TeamProNumber	integer	Refer to table TeamProInfo table number field.

WaiverInterest

Field Name	Field Data Type	Information
Player	integer	If 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.
TeamProNumber	integer	Refer to table TeamProInfo table number field.

EntryDraft

Field Name	Field Data Type	Information
PickNumber	integer
ProspectPick	string
OriginalTeam	integer	Refer to table TeamProInfo table number field.
CurrentTeam	integer	Refer to table TeamProInfo table number field.

EntryDraftProspectAvailable

Field Name	Field Data Type	Information
PickNumber	integer
ProspectName	string

ProRivalryInfo

Field Name	Field Data Type	Information
Team1	integer	Refer to table TeamProInfo table number field.
Team2	integer	Refer to table TeamProInfo table number field.
Rivalry	integer

FarmRivalryInfo

Field Name	Field Data Type	Information
Team1	integer	Refer to table TeamFarmInfo table number field.
Team2	integer	Refer to table TeamFarmInfo table number field.
Rivalry	integer

PlayoffPro

Field Name	Field Data Type	Information
Number	integer
Conference	integer
Division	integer
Round	integer
HomeTeam	integer	Refer to table TeamProInfo table number field.
HomeWin	integer
VisitorTeam	integer	Refer to table TeamProInfo table number field.
VisitorWin	integer
Rivalry	integer

PlayoffFarm

Field Name	Field Data Type	Information
Number	integer
Conference	integer
Division	integer
Round	integer
HomeTeam	integer	Refer to table TeamFarmInfo table number field.
HomeWin	integer
VisitorTeam	integer	Refer to table TeamFarmInfo table number field.
VisitorWin	integer
Rivalry	integer

PlayoffProNumber

Field Name	Field Data Type	Information
Round1	integer
Round2	integer
Round3	integer
Round4	integer
Round4	integer

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 Name	Field Data Type	Information
Round1	integer
Round2	integer
Round3	integer
Round4	integer
Round4	integer

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 Name	Field Data Type	Information
TodayRanking	integer
LastRanking	integer
Teams	integer	Refer to table TeamProInfo table number field.
Points	integer
W	integer
L	integer
T	integer
OTL	integer
SOL	integer
GF	integer
GA	integer

PowerRankingFarm

Field Name	Field Data Type	Information
TodayRanking	integer
LastRanking	integer
Teams	integer	Refer to table TeamFarmInfo table number field.
Points	integer
W	integer
L	integer
T	integer
OTL	integer
SOL	integer
GF	integer
GA	integer

NextYearFreeAgent

Field Name	Field Data Type	Information
InternalNumber	integer primary key	Higher the number = Most Recent Contract
PlayerType	boolean	If True, Number field refer to PlayerInfo table. If False, Number field refer to GoalieInfo table
Number	integer	Refer to table PlayerInfo or GoalerInfo depending on the PlayerType Field
PlayerName	string	Same as table Name field in PlayerInfo or GoalerInfo
Team	integer	Refer to table TeamProInfo table number field.
NoTrade	boolean
CanPlayPro	boolean
CanPlayFarm	boolean
ProSalaryinFarm	boolean
Contract	integer
Salary	currency
Bonus	currency

Trade

Field Name	Field Data Type	Information
FromTeam	integer	Refer to table TeamProInfo table number field.
ToTeam	integer	Refer to table TeamProInfo table number field.
Player	integer	If 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.
Prospect	integer	Refer to table Prospects table number field.
DraftPick	integer	An conditional pick is mark by having 10,000 add Draft Pick number.
Money	currency
SalaryCapY1	currency
SalaryCapY2	currency
ConfirmFrom	boolean
ConfirmTo	boolean
MessageWhy	string

FreeAgentOffers

Field Name	Field Data Type	Information
FromTeam	integer	Refer to table TeamProInfo table number field.
PlayerNumber	integer	If 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.
SalaryOffer	currency
DurationOffer	integer
BonusOffer	currency
OfferDate	timestamp
NoTradeOffer	boolean
CanPlayProOffer	boolean
CanPlayFarmOffer	boolean
ProSalaryinFarm1WayContractOffer	boolean
CommentOffer	string

DraftSelection

Field Name	Field Data Type	Information
FromTeam	integer	Refer to table TeamProInfo table number field.
SelectionNumber	integer	For EntryDraft, If 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. For EntryDraft, refer to EntryDraftProspectAvailable number field.
SelectionOrder	integer

Scroll