DB2 Server for VSE & VM: Database Services Utility

CL_SCHED Table

The CL_SCHED table describes a classroom schedule. The table contents are shown in Figure 111; a description of the columns is shown in Figure 112.

Figure 111. CL_SCHED Table Contents

CLASS_CODE DAY STARTING ENDING 101:KAR 2 14.10.00 16.10.00 202:LMM 3 14.40.00 16.40.00 303:RAR 4 09.00.00 09.40.00

Figure 112. Columns of the CL_SCHED Table

Column Name Description CLASS_CODE Class Code (room:teacher) DAY Day number of four day schedule STARTING Class start time ENDING Class end time

This table was created with:

CREATE TABLE CL_SCHED
     (CLASS_CODE      CHAR(7)  NOT NULL,
      DAY             SMALLINT NOT NULL,
      STARTING        TIME     NOT NULL,
      ENDING          TIME     NOT NULL)