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

-- Project Name : noname

-- Author       : Horiuchi

-- RDBMS Type   : MySQL

-- Application  : A5:SQL Mk-2

  , BillingSplitFlg decimal(1,0) not null comment '??????t???O'

  , BillingSendDate date comment '???????X??/??n????'

  , LedgerComplateDate date not null comment '?H????????????????t'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionbaseinfo_PKC primary key (ConstructionCode)

create table constructionbaseinfodetail (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , DetailNo decimal(2,0) not null comment '??????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionbaseinfodetail_PKC primary key (ConstructionCode,DetailNo)

  , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)

) comment '?x??????f?[?^' ;

-- ?H??????????f?[?^

drop table if exists periodavoidance cascade;