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

DROP TABLE IF EXISTS PurchaseOrderDate;

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

CREATE TABLE PurchaseOrderDate

(

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

	SeqNo decimal(3) unsigned NOT NULL COMMENT '???????}??',

	CompanyCode decimal(8,0) NOT NULL COMMENT '??????R?[?h',

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

	ReturnDate date NOT NULL COMMENT '???????????',

	ReturnCheckDate date NOT NULL COMMENT '??????????m?F??',

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

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

	PRIMARY KEY (ConstructionCode, SeqNo)

) COMMENT = '?????????t?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'

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