ClassYearNotes

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
IsApproved	bit		Default = 0
ApprovedDate	datetime	yes
PublishDate	datetime	yes
ModifiedDate	datetime	yes
ExpireDate	datetime	yes
DateLastChanged	datetime		Default = getutcdate()
ClassNote	ntext	yes
LastName	nvarchar(200)	yes
FirstName	nvarchar(100)	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ClientClassYearsID	int		ClientClassYears.ID
OwnerID	int		ClientUsers.ID
ApprovedByID	int	yes	ClientUsers.ID
BackOfficeSystemPeopleID	int	yes	BackOfficeSystemPeople.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_ClassYearNotes_ApprovedByID	ApprovedByID
IX_ClassYearNotes_ClientClassYearsID	ClientClassYearsID
IX_ClassYearNotes_OwnerID	OwnerID
PK_ClassNotes	ID	yes	yes	yes