ATHLETICS_EECOACHES

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
CoachEEID	int
FirstName	nvarchar(256)	yes
LastName	nvarchar(256)	yes
Type	uniqueidentifier
HideContactInfo	bit		Default = 0

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_ATHLETICS_EECOACHES_COACHEEID	CoachEEID
PK_ATHLETICS_EECOACHES	ID	yes	yes	yes
UX_ATHLETICS_EECOACHES_TEAMCOACH	TeamID, CoachEEID	yes