Fields Leagues

[VCFL Commish]

DepthCharts
ID------------Auto Number
LeagueID----Number
TeamID------Number
FormationID--Number
P1 to P12-----Text


GamePlayResults All Numbers except the first
ID----------------------AutoNumber
ScheduleGameID
DriveNumber
PlayNumber
PlayResult
PlayQuarter
PlayTime
PlayDown
PlayToGo
PlayPositionStart
PlayPositionEnd
TeamOffensiveID
TeamDefensiveID
OffensivePlayID
DefensivePlayID
PlayType
QBID
IntendedReceiverID
BallCarrierID
TackledByID
ScoreByID
ScoreAmount
InterceptionByID
FumbledByID
FumbleRecoverdByID
PenaltyByID
PenaltyID

[VCFL Commish]

League_DraftHistory All Numbers
SeasonNumber
DraftingTeamID
PlayerDraftedID
RoundDrafted

League_SeasonStatus
ID-----------------------------Auto Number
SeasonNumber---------------Number
RegularSeasonStarted-------Yes/No
CurrentDraftRound-----------Number
CurrentDraftSelectingTeam--Number
TrainingCampComplete------Yes/No
RegularSeasonComplete-----Yes/No
PostSeasonStarted------------Yes/No
PostSeasonComplete----------Yes/No
PlayerAdvanceComplete -----Yes/No

LeagueConference
ID-----------------------------Auto Number
LeagueID--------------------Number
Name------------------------Text

LeagueDivisions
ID-----------------------------Auto Number
LeagueID--------------------Number
ConferenceID---------------Number
Name------------------------Text

Leagues
ID-------------------------Number
LeagueName-------------Text
SmallName---------------Text
BallID----------------------Number
SeasonLength-------------Number
NameofChampionship----Text
Downs----------------------Number
FieldSize--------------------Number
LengthofPlayClock---------Number
MaxPlayers------------------Number
AllowFairCatch----------------Yes/No
MinuteWarning---------------Number
LengthofQuarter-------------Number
AllowUnlimitedMotion--------Yes/No
LiveFieldGoals----------------Yes/No
SalaryCap---------------------Currency
MaxPlayersOnRoster---------Number
MaxImports-------------------Number
PointsForWin------------------Number
PointsForLoss-----------------Number
PointsForTie-------------------Number
OTPeriod----------------------Number
RefereeStyle------------------Number
InjuriesOn---------------------Yes/No
FatigueOn----------------------Yes/No
PointsForTD-------------------Number
PointsForPAT------------------Number
PointsForFG-------------------Number
PointsForSaftey---------------Number
UseSinglePointRule-----------Yes/No
AllowTwoPointConvert-------Yes/No
KickOffFrom-------------------Number
KickPATFrom------------------Number
TwoPointConvertFro----------Number
GoalPostPosition--------------Number
SinglePointOTLoss------------Yes/No
PenaltyRules-------------------Number
CurrentSeason-----------------Number
UsesExpansionPack-----------Yes/No
TimeoutsInHalf-----------------Number
LeagueSkillLevel---------------Number
LastReset-----------------------Number

[VCFL Commish]

Players
ID--------Auto number
LeagueID--------------Number
TeamID--------------Number
LastName------Text
FirstName------Text
JerseyNumber--------------Number
JerseyName------Text
PositionID--------------Number
DepthChartPosition--------------Number
Import-----------Yes\No
Height--------------Number
Weight--------------Number
Age--------------Number
DOB------------Date/Time
JuniorFootball------Text
DraftRound--------------Number
YearsPro--------------Number
LengthOfCurrentContract--------------Number
CurrentYearOfContract--------------Number
IncludeOptionYear-----------Yes\No
Attitude--------------Number
LeaguesPlayed------Text
CurrentSalary------Currency
Bio--------------------Memo
SkinTone--------------Number
FaceImage--------------Number
FaceMaskImage--------------Number
GlovesImage--------------Number
Injury--------------Number
InjuryLen--------------Number
R1 to R20--------Number
Retired-----------Yes\No
Graphic-------------Text
Sound-------------Text
Status--------------Number

[VCFL Commish]

Players_PotentialSA All numbers
PlayerID
CreationModifier
MaximumSeasons
R1 to R20

Schedule
ID------------Auto-Number
SeasonNumber-------------Number
LeagueID-------------Number
WeekNumber-------------Number
HomeTeam-------------Number
VisitingTeam-------------Number
HScore-------------Number
VScore-------------Number
GamePlayed-------Yes/No


Schedule_Playoff
ID------------Auto-Number
SeasonNumber-------------Number
PlayoffRound-------------Number
GameNumber-------------Number
HomeTeamID-------------Number
HomeTeamScore-------------Number
AwayTeamNumber-------------Number
AwayTeamScore-------------Number
GamePlayed------Yes/no
Championship------Yes/no

Stats_GroupItems
GroupID---Number
GroupItemIndex---Number
Name---------------Text


Stats_Groups
ID---Number
GroupName---------------Text


Stats_League
PlayerID---Number
TeamID---Number
OpTeamID---Number
StatMode---Number
StatGroup---Number
StatValues--------Memo
ScheduleID---Number
SeasonNumber---Number

Team_Tendencies All numbers
TeamID
PlayID
PlayType
PlayCategory
PlayDirection
PlayDistance
FinalBallCarrierID
TimeAdded

Teams
ID----Auto Number
LeagueID----Number
DivisionID----Number
TeamName----Text
SmallName----Text
City----Text
GeographicLocation----Number
CanadianBasedTeam--------------Yes/No
StadiumName----Text
StadiumFile----Text
StadiumTurfType----Number
PlayBookFile----Text
OwnerName----Text
HeadCoachName----Text
OffensiveCoordName----Text
DefensiveCoordName----Text
HumanOperated--------------Yes/No
UseShoulderNumbers--------------Yes/No
FaceMaskColour----Text
StadiumCapacity----Number
AverageTicketPrice----Number
SeasonTicketNumber----Number
DateTimeCreated--------Date/Time
DefunctTeam--------------Yes/No

Teams_DraftProfile all numbers
TeamID
SeasonNumber
Round
Position
Criteria1
Criteria2

Teams_News
TeamID----Number
SeasonNumber----Number
News----------------Text

Teams_SeasonRecords all numbers
SeasonNumber
Wins
Losses
Ties
OTLosses
PointsFor
PointsAgainst


Teams_TrainingCampall numbers
TeamID
SeasonNumber
RowNumber
ColumnNumber
TCPointValue