Class schedule table (CL_SCHED)
The class schedule table describes each class, the start time for the class, the end time for the class, and the class code.
The class schedule table is created with the following CREATE TABLE statement:
CREATE TABLE CL_SCHED
(CLASS_CODE CHAR(7),
"DAY" SMALLINT,
STARTING TIME,
ENDING TIME)
The table below gives the contents of the columns.
Column name | Description |
---|---|
CLASS_CODE | Class code (room:teacher) |
DAY | Day number of 4 day schedule |
STARTING | Class start time |
ENDING | Class end time |