| Primary Key | Field Type |
|---|---|
 ID |
int |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 IsApproved |
bit | Default = 0 | ||
| ApprovedDate |
datetime |  |
||
| PublishDate |
datetime | |
||
| ModifiedDate |
datetime | |
||
| ExpireDate |
datetime | |
||
| DateLastChanged |
datetime | Default = getutcdate() | ||
| ClassNote |
ntext | |
||
| LastName |
nvarchar(200) | |
||
| FirstName |
nvarchar(100) | |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ClientClassYearsID |
int | ClientClassYears.ID | ||
| OwnerID |
int | ClientUsers.ID | ||
| ApprovedByID |
int | |
ClientUsers.ID | |
| BackOfficeSystemPeopleID |
int | |
BackOfficeSystemPeople.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_ClassYearNotes_ApprovedByID |
ApprovedByID | |||
| IX_ClassYearNotes_ClientClassYearsID |
ClientClassYearsID | |||
| IX_ClassYearNotes_OwnerID |
OwnerID | |||
| PK_ClassNotes |
ID | |
|
|