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

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

drop table if exists PeriodAvoidance cascade;

create table PeriodAvoidance (

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

  , ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O'

  , FieldNo decimal(2,0) not null comment '?`?F?b?N???t?B?[???h???'

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

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

  , constraint PeriodAvoidance_PKC primary key (ConstructionCode,ConstructionStatusFlg,FieldNo)

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

create index PeriodAvoidance_Index1

  on PeriodAvoidance(ConstructionCode);

create index PeriodAvoidance_Index2

  on PeriodAvoidance(ConstructionStatusFlg);

create index PeriodAvoidance_Index3

  on PeriodAvoidance(FieldNo);