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

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

drop table if exists depositdatadetail cascade;

create table depositdatadetail (

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

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

  , TARGETDATE decimal(6,0) not null comment '???N??'

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

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

  , DEPOSITAMOUNT decimal(10,0) comment '???????z'

  , DISCOUNTAMOUNT decimal(10,0) comment '?l???????z'

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

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

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

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

  , CONFIRMATIONPERSONCODE decimal(8,0) comment '?m?F?S????R?[?h'

  , CONFIRMATIONDATE date comment '?S????m?F???t'

  , CONFIRMATIONENDFLG decimal(1,0) comment '?m?F?????t???O'

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

  , ENTRYDATE datetime comment '?o?^???t'

  , UPDATEDATE datetime comment '?X?V???t'

  , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,REQUESTNO)

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

DROP TABLE IF EXISTS RequestOrderDate;

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

CREATE TABLE RequestOrderDate

(

	ConstructionCode decimal(10,0) unsigned NOT NULL COMMENT '?H???R?[?h',

	InvoiceNo decimal(9,0) NOT NULL COMMENT '??????No',

	SendDate date NOT NULL COMMENT '???????????X????',

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

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

	PRIMARY KEY (ConstructionCode, InvoiceNo)

) COMMENT = '?????????t?f?[?^';