Charges(料金)テーブルのDDL - Basic Teradata Query

Basic Teradata Queryリファレンス

Product
Basic Teradata Query
Release Number
16.20
Published
2018年4月
Language
日本語
Last Update
2019-07-03
dita:mapPath
ja-JP/moy1512703123963.ditamap
dita:ditavalPath
ja-JP/moy1512703123963.ditaval
dita:id
B035-2414
Product Category
Teradata Tools and Utilities
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 )
;