ScheduleDays, 75 (ver3.6.1)
The cycle days used for this build.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Abbr | 3.6.1 | Varchar(3) | A short 1 or 2 character version of the Name, such as A. |
BuildID | 5.0.0 | Number(10,0) | Identifier for the current build. |
DayID | 3.6.1 | Number(10,0) | Number assigned to this Day, such as 1. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | Varchar(30) | Name given for this day, such as A Day. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Letter | 3.6.1 | Varchar(2) | Similar to the abbreviation but just limited to a character. It is used in place of a missing abbreviation. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |