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

-- Date/Time    : 2018/10/23 8:09:34

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

--* BackupToTempTable

drop table if exists removerequest cascade;

--* RestoreFromTempTable

create table removerequest (

  RemoveNo decimal(10,0) not null comment '???No'

  , RemoveDate decimal(8,0) not null comment '?????????'

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

  , RemoveComment varchar(500) comment '??????e'

  , RequestNo decimal(9,0) not null comment '????No'

  , ReqConstructionCode decimal(10,0) not null comment '?????H?????'

  , ORDERNO decimal(2,0) not null comment '??t???'

  , RequestMonth decimal(6,0) not null comment '??????'

  , OrderersDivision decimal(5,0) not null comment '???????'

  , OrderersCode decimal(5,0) not null comment '??????R?[?h'

  , OrderersName varchar(120) not null comment '???????'

  , ReqConstructionName varchar(120) not null comment '?????H??????'

  , RequestTotalAmount decimal(10,0) not null comment '???????z???v'

  , RequestAmount decimal(10,0) not null comment '???????z'

  , TaxAmount decimal(10,0) not null comment '?????'

  , UnPaidAmount decimal(10,0) comment '??????'

  , Note varchar(120) comment '???l'

  , AssignedFlg decimal(1,0) comment '??????t???O'

  , InvoiceNo decimal(9,0) not null comment '??????no'

  , ENTRYDATE datetime not null comment '?o?^?N????'

  , UPDATEDATE datetime not null comment '?X?V?N????'

  , constraint removerequest_PKC primary key (RemoveNo,RemoveDate)

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

create index RemoveRequest_Index1

  on removerequest(RequestNo);

create index RemoveRequest_Index2

  on removerequest(ReqConstructionCode);

create index RemoveRequest_Index3

  on removerequest(ORDERNO);

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

--* BackupToTempTable

drop table if exists removerequestdetail cascade;

--* RestoreFromTempTable

create table removerequestdetail (

  RemoveNo decimal(10,0) not null comment '???No'

  , SeqNo decimal(9,0) not null comment '??tno'

  , RequestNo decimal(9,0) not null comment '????no'

  , MainConstructionCode decimal(10,0) not null comment '?{?H?????'

  , ConstructionCode decimal(10,0) not null comment '?H?????'

  , ConstructionKind decimal(1,0) not null comment '?H????'

  , RequestAmount decimal(10,0) not null comment '???????z'

  , TaxAmount decimal(10,0) not null comment '?????'

  , ENTRYDATE datetime not null comment '?o?^?N????'

  , UPDATEDATE datetime not null comment '?X?V?N????'

  , constraint removerequestdetail_PKC primary key (RemoveNo,SeqNo)

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