ATHLETICS_ROSTERS

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
PlayerEEID	int
Position	nvarchar(256)	yes
FirstName	nvarchar(256)	yes
LastName	nvarchar(256)	yes
Number	nvarchar(256)	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
TeamID	int		ATHLETICS_TEAMS.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_ATHLETICS_ROSTER_PLAYEREEID	PlayerEEID
PK_ATHLETICS_ROSTERS	ID	yes	yes	yes