CoursePreReqRecommend (ver6.0.0)
Stores course prerequisites recommended.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Comments | 6.0.0 | Varchar2(4000) | Comments for the recommendation. |
CourseID | 6.0.0 | Number(10) | Foreign key to the Courses table ID column. |
CourseNumber | 6.0.0 | Varchar2(11) | Copy of the course number from the Courses table. |
CreatedByUserID | 6.0.0 | Number(10) | ID of the person who created the student recommendation from the Teachers table. |
ID | 6.0.0 | Number(10) | Row ID. Required. |
ModifiedByUserID | 6.0.0 | Number(10) | ID of the person who modified the student recommendation from the Teachers table. |
StudentID | 6.0.0 | Number(10) | Foreign key to the Students table ID column. |
WhenCreated | 6.0.0 | Timestamp(6) | Created Timestamp. Defaults to system date. |
WhenModified | 6.0.0 | Timestamp(6) | Modified Timestamp. Defaults to system date. |
WhoCreated | 6.0.0 | Varchar2(100) | Name of person who gave a student recommendation from the Teachers table. |
WhoModified | 6.0.0 | Varchar2(100) | Name of person who modified a student recommendation from the Teachers table. |
YearID | 6.0.0 | Number(10) | Retrieved from the Terms table. |