CREATE SET TABLE workforce.charges
, FALLBACK
, NO BEFORE JOURNAL
, NO AFTER JOURNAL
, CHECKSUM = DEFAULT
, DEFAULT MERGEBLOCKRATIO
(
EmpNo SMALLINT
FORMAT '9(5)'
TITLE 'Employee//Id'
CHECK ( (EmpNo >= 10001 ) AND (EmpNo <= 32001 ) )
NOT NULL
, Proj_Id CHAR(8)
CHARACTER SET LATIN NOT CASESPECIFIC
TITLE 'Project// Id'
NOT NULL
, WkEnd DATE
FORMAT 'YY/MM/DD'
TITLE 'Week//Ending'
, Hours DECIMAL(4,1)
FORMAT 'ZZ9.9'
CHECK ( (Hours >= 0.5 ) AND (Hours <= 999.5 ) )
)
PRIMARY INDEX ( EmpNo ,Proj_Id )
INDEX ( Proj_Id )
;