工事管理システム製品化対応

-- ???????o?[?f?[?^

drop table if exists DepartmentCostData cascade; 

CREATE TABLE DepartmentCostData( 

  DepartmentCode DECIMAL (5, 0) UNSIGNED NOT NULL COMMENT '?????R?[?h'

  , DataYear SMALLINT (5) UNSIGNED NOT NULL COMMENT '?H???????E?H???N??'

  , DataCount DECIMAL (5, 0) UNSIGNED NOT NULL COMMENT '?f?[?^???'

  , EntryPersonCode DECIMAL (8, 0) UNSIGNED NOT NULL COMMENT '????S????R?[?h'

  , SuppliersCode DECIMAL (5, 0) UNSIGNED NOT NULL COMMENT '?x????R?[?h'

  , SuppliersName VARCHAR (120) COMMENT '?x??????'

  , PaymentContent VARCHAR (60) COMMENT '?x?????e'

  , DateOfBilling DATE NOT NULL COMMENT '??????'

  , DateOfPayment DATE NOT NULL COMMENT '?x????'

  , EntryPrice DECIMAL (12, 0) NOT NULL COMMENT '???z?i????j'

  , EntryPriceInTax DECIMAL (12, 0) NOT NULL COMMENT '???z?i????j'

  , SlipNumber VARCHAR (12) COMMENT '?`?[???'

  , ComplateFlg DECIMAL (1, 0) NOT NULL COMMENT '???????t???O'

  , ApprovalFlg DECIMAL (1, 0) NOT NULL COMMENT '???F?t???O'

  , EntryDate DATETIME NOT NULL COMMENT '?o?^???t'

  , UpdateDate DATETIME NOT NULL COMMENT '?X?V???t'

  , CONSTRAINT DepartmentCostData_PKC PRIMARY KEY (DepartmentCode, DataYear, DataCount)

) COMMENT '???????o?[?f?[?^';