DDL for the Charges Table

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K
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 )
;