ScheduleCourseRelationships, 78 (ver3.6.1)
Describes how certain courses are related to each other.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
BlockTeacher | 3.6.1 | Number(10,0) | Flag, which indicates whether the same teacher must also be blocked for this course relationship. Not currently used. |
BlockMakeDepSects | 5.0.0 | Number(10,0) | This will be used to support the "ExtraData" dbf field exported to the Engine. |
BuildID | 3.6.1 | Number(10,0) | The internal number for the ScheduleBuild with which this record is associated. |
CatalogID | 3.6.1 | Number(10,0) | The internal number for the ScheduleCatalog with which this record is associated. |
Course_Number1 | 3.6.1 | Varchar(20) | One of the two courses that are associated to each other by a type. |
Course_Number2 | 3.6.1 | Varchar(20) | One of the two courses that are associated to each other by a type. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ExtraData | 5.0.0 | Varchar(80) | Instructs the Engine to create Dependen Sections from the relationship instead of the Section Links. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
RelationshipCode | 3.6.1 | Varchar(15) | Type of relationship for these courses: This is required for RelationshipType of Blocks otherwise = NotBlock. Simultaneous: The blocked course must be scheduled at the same time as the current course. If the same teacher instructs both courses, they must also be concurrent. BeforeAfter: The blocked course must be scheduled either before or after the current course. Before: The blocked course must be scheduled before the current course. After: The blocked course must be scheduled after the current course. Term: Two courses occur on the same days and periods, but in different terms. Opposite Days: Two courses occur during the same period and term, but on alternate days. Section: The blocked course must have the same students in each section as the current course. |
RelationshipType | 3.6.1 | Varchar(15) | Type of relationship for these courses: Block:Courses that must be related to one another in the schedule, Concurrent-Courses that can meet at the same time, in the same place, and be taught by the same teacher, PreReq-A course that must be in a students schedule in a term before the related course, CoReq-Two courses that are scheduled during the same term of a students schedule or PostReq-A course that must be in a students schedule in a term after the related course. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
YearID | 3.6.1 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. |