Fields Main Data

[VCFL Commish]

Balls
ID------Auto Number
Name--------Text----Name to display in lists.
TextureFile--Text----Pointer to the texture.
Weight------Number---A non-realworld value that works with the QB's strength rating on pass plays.

ElasticityCoefficient--Number------how much does the ball bounce when it hits the turf. 1= The ball will bounce forever.

Data Constants All Numbers
BlockingBaseLine------------A baseline constant for blocking time.
BlockingPassBlockTime-----The base pass block hold time modified by player skills
BlockingPushBlockTime----The base push block hold time modified by player skills
BlockingPassBlockStrength----The base pass block strength modified by player skills
BlockingPushBlockStrength----The base push block strength modified by player skills
BlockPancakeThreshold----The point at which a basic block becomes a knock down of one of the players.
TackleThreshold--------The game processes various items and comes to a result, this result must be higher than this number for a tackle to occure
PhysicsBaseMoveSpeed------The speed constant player attributes are applied to to achive their speed in the world
PhysicsBaseAgility----------The agility constant player attributes are applied to to achive their agility in the world
PhysicsMaxChangeDirTime-----The maximum time a player will run in a single direction before looking for the new direction to run in. Modified by player attributes
DefenseBaseM2MCoverageArea------The M2M coverage area around a receiver that is modified by the defenders cover aggression

DataFatigue All Numbers
AddBlocking
AddTackling
AddBeingTackled
AddLongPasses
SubtractResting
SubtractWalking
SubtractStanding

[VCFL Commish]

DefaultValues_Draft20
DefaultValues_Draft40
DefaultValues_Draft45
DefaultValues_Draft65

ID-----------Auto Number
Round------- Number
PositionID-- Number
Criteria1--- Number
Criteria2--- Number


DefaultValues_TrainingCamp All Numbers
RowNumber
ColumnNumber
TCPointValue


Formations
ID
Name----------Text
PlayCategory-- Number
MaxPlayers----- Number


Formations_Data
ID--------------Auto Number
FormationID--Number
P_ID1---------Text---FX,FY = Coords separated by comma
P_ID2---------Text
P_ID3---------Text
P_ID4---------Text
P_ID5---------Text
P_ID6---------Text
P_ID7---------Text
P_ID8---------Text
P_ID9---------Text
P_ID10---------Text
P_ID11---------Text
P_ID12---------Text

[VCFL Commish]

LastSettings
LastLeagueID------------Number
LastHomeTeamID-------Number
LastHomeTeamFolder---Text
LastAwayTeamID--------Number
LastAwayTeamFolder---Text
PlayerDetailLevel-------Number
LastStadium-------------Text
LastVideoMode----------Number
LastItemID--------------Number
LastShadowDetail-------Number
LastSoundOn------------Yes/No
LastFatigueOn-----------Yes/No
LastInjuriesOn----------Yes/No
LastReplayOn-----------Yes/No
LastSidelineDetail------Number
UserUniqueID----------Text
LastQPRules------------Number
LastFieldSize-----------Number
LastLeaguePage-------Number

Leagues
ID---------------------------Number
LeagueName---------------Text
SmallNameSmallName----Text


LogicCommands
ID------------------------Auto Number
Name--------------------Text
Values-------------------Text
AppliesTo----------------Text
LastCommand-----------Yes/No

LookupInjury
ID---------------AutoNumber
InjuryName-----Text
InjuryLength----Number-----Number of Quarters this injury normally lasts
SA_Effected-----Number-----What Skill Attribute this injury will effect
Reduction-------Number------Percentage to reduce the effected SA's by.
Possiblity--------Number-----Percentage of Possiblity that this could happen to a player


LookupPosition
ID---------------Auto Number
Value-----------Number
Position---------Text-----Long description of player position.
Abbv------------Text-----2 or 3 character abbreviation.
SpecialTeams--Yes/No--Special Teams position

LookupSkillAttributes
ID----------------------------Auto Number
SA----------------------------Number
Name-------------------------Text
Abbv--------------------------Text
Description-------------------Memo
AppliesToPositionID----------Number

[VCFL Commish]

LookupStatus
ID--------Auto Number
Status---Number
Name----Text
Duration-Number---Number of Games

Names_First
ID--------------Auto Number
FirstNames----Text

Names_Last
ID--------------Auto Number
LastName------Text

Penalties
ID------------------Auto Number
Rules---------------Number----Canadian, US, or Indoor rules for penalties...
Lookup--------------Number---How the game code selects the penalty data
PenaltyName-------Text-------The name of the penalty
AutoFirstDown------Yes/No----Is this an automatic first down. (This allows for a 1st and 5 type penalty)
DistanceOfPenalty--Number---Yards the penalty is worth
PlaceBallAtPoint-----Yes/No----If this is true the ball is placed where the penalty took place, if false it's the DistanceOfPenalty Value
AutomaticPenalty----Yes/No---If yes, the Penalty is automatic with no chance to decline.
LossOfDown----------Yes/No---Does this penalty cause a loss of down.
HalfDistanceToGoal--Yes/No---Does the ball get placed half the distance to the goal line. If so, ignore DistanceOfPenalty
PreSnapPenalty------Yes/No---This penalty can only occur prior to the snap of the ball. These plays are ignored when looking for a penalty that happens during the course of a play.


RouteTemplates
ID-----------Auto Number
Name--------Text
Description--Text
AppliesTo----Text

SkillAttribute_Ranges
PositionAbbr----Text------The abbreviation of the position (mostly for human readablility)
PositionID-------Number--The positionID we're looking up
R1 TO R20------Text-------The ranges for the Skill Attribute (R1 to R20) Min/Max
Height-----------Text
Weight----------Text

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

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

UniqueID
ID-----AutoNumber