CoursePreReqRule (ver6.0.0)
Stores course prerequisites rules.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CourseID | 6.0.0 | Number(10) | Foreign key to the Courses table ID column. |
CourseNumber | 6.0.0 | Varchar2(20) | Copy of the course number from the Courses table. |
ID | 6.0.0 | Number(10) | Row ID. Required. |
Note | 6.0.0 | Varchar2(512) | A description of the prerequisite rule. |
RuleExpression | ver... | CLOB | XML, which defines the rule. |
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 stored the rule. Defaults to user. |
WhoModified | 6.0.0 | Varchar2(100) | Name of person who last modified the rule. Defaults to user. |