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

• CL_SCHED
  Here is a complete listing of the data in the CL_SCHED table.

 

Parent topic:

DB2 Universal Database for iSeries sample tables