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

-- Project Name : noname

-- Author       : Horiuchi

-- RDBMS Type   : MySQL

-- Application  : A5:SQL Mk-2

  , OrdersDecisionPriceInTax decimal(12,0) not null comment '??????????z'

  , SalesDepCode decimal(5,0) unsigned not null comment '?c??S????????R?[?h'

  , SalesPersonCode decimal(8,0) unsigned not null comment '?c??S????R?[?h'

  , ConstrDepCode decimal(5,0) unsigned not null comment '?H???S????????R?[?h'

  , ConstructionPersonCode decimal(8,0) not null comment '?H???S????R?[?h'

  , ConstrSubDepCode decimal(5,0) unsigned not null comment '?H?????S????????R?[?h'

  , constraint constructionledger_PKC primary key (ConstructionCode)

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

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

drop table if exists constructionledgerdetail cascade;

create index LedgerDetail_Index05

  on constructionledgerdetail(DetailCount);

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

drop table if exists constructionledgerexcute cascade;

create table daymaster (

  days smallint(6) not null comment '??'

) comment '???}?X?^' ;

-- ?????}?X?^

drop table if exists deadlinemaster cascade;

  , DepartmentString varchar(100) not null comment '??????'

  , ActionScheduleFlg decimal(1,0) not null comment '?s???\??\???t???O'

  , StaffAssignFlg decimal(1,0) not null comment '?l???z?u?\???t???O'

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

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

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

create table monthmaster (

  month smallint(6) not null comment '??'

) comment '???}?X?^' ;

-- ??????}?X?^

drop table if exists orderersmaster cascade;

create table yearmaster (

  years smallint(6) not null comment '?N'

) comment '?N?}?X?^' ;