DDL for the Project Table | Basic Teradata Query - DDL for the Project Table - Basic Teradata Query

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 )
;