Description
not sure what this table is for...Table properties
| name | value |
|---|
| name | JESSE.CL_SCHED
|
| created | 3/16/2010 8:49:01 PM
|
| tablespace | USERSPACE1
|
| status | normal
|
| percent free | no statistics |
| rows | 5 |
| pages | 1 |
| average row length | 29 |
Columns
| column | datatype | default | nulls | PK | FK | UQ | comment |
|---|
| CLASS_CODE
| CHARACTER
(7)
|
| Y
|
|
|
| same goes for the column...
|
| DAY
| SMALLINT
(2)
|
| Y
|
|
|
| hi there
|
| STARTING
| TIME
(3)
|
| Y
|
|
|
| start of what?
|
| ENDING
| TIME
(3)
|
| Y
|
|
|
| end of what?
|
Sample rows
| CLASS_CODE | DAY | STARTING | ENDING |
|---|
| 042:BF
| 4
| 12:10:00
| 14:00:00
|
| 553:MJA
| 1
| 10:30:00
| 11:00:00
|
| 543:CWM
| 3
| 09:10:00
| 10:30:00
|
| 778:RES
| 2
| 12:10:00
| 14:00:00
|
| 044:HD
| 3
| 17:12:30
| 18:00:00
|
Code
CREATE TABLE "JESSE "."CL_SCHED" (
"CLASS_CODE" CHAR(7) ,
"DAY" SMALLINT ,
"STARTING" TIME ,
"ENDING" TIME )
IN "USERSPACE1" ;
COMMENT ON TABLE "JESSE "."CL_SCHED" IS 'not sure what this table is for...';
COMMENT ON COLUMN "JESSE "."CL_SCHED"."CLASS_CODE" IS 'same goes for the column...';
COMMENT ON COLUMN "JESSE "."CL_SCHED"."DAY" IS 'hi there';
COMMENT ON COLUMN "JESSE "."CL_SCHED"."ENDING" IS 'end of what?';
COMMENT ON COLUMN "JESSE "."CL_SCHED"."STARTING" IS 'start of what?';