CoursePreReqEvaluated (ver6.0.0)
Stores course prerequisites that have been evaluated.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
CourseID | 6.0.0 | Number(10) | Foreign key to the Courses table ID column. Required. |
CourseNumber | 6.0.0 | Varchar2(40) | Copy of the course number from the Courses table. |
CoursePreReqRuleID | 6.0.0 | Number(10) | Foreign key to the CoursePreReqRule table ID column. |
ID | 6.0.0 | Number(10) | Row ID. Required. |
RuleName | 6.0.0 | Varchar2(20) | Name of rule, which was evaluated. |
Status | 6.0.0 | Varchar2(20) | Status of rule evaluation (SATISFIED or UNSATISFIED). |
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 invoked the rule evaluation. Defaults to user. |
WhoModified | 6.0.0 | Varchar2(100) | Name of person who last invoked the rule evaluation. Defaults to user. |