DDL for the Project Table
CREATE SET TABLE workforce.project
, FALLBACK
, NO BEFORE JOURNAL
, NO AFTER JOURNAL
, CHECKSUM = DEFAULT
, DEFAULT MERGEBLOCKRATIO
(
Proj_Id CHAR(8)
CHARACTER SET LATIN NOT CASESPECIFIC
TITLE 'Project// Id'
NOT NULL
, Description VARCHAR(25)
CHARACTER SET LATIN NOT CASESPECIFIC
TITLE ' Project Description'
, RecDate DATE
FORMAT 'YY/MM/DD'
TITLE 'Received//Date'
, DueDate DATE
FORMAT 'YY/MM/DD'
TITLE 'Due //Date'
, ComDate DATE
FORMAT 'YY/MM/DD'
TITLE 'Compl//Date'
)
UNIQUE PRIMARY INDEX ( Proj_Id )
;