CREATE TABLE RT_MACHINE_VERIFICATION_DEINFO
(
	DERowID varchar (64) NOT NULL,
	SOPInstanceUID varchar (64) NOT NULL,
	VRType integer NOT NULL,
	GroupNumber integer NOT NULL,
	ElementNumber integer NOT NULL,
	IsSQ varchar (64) NOT NULL,
	ParentSQUID varchar (64) DEFAULT '',
	Value varchar (64) DEFAULT '',
	SQUUID varchar (64) DEFAULT '',
	ItemUUID varchar (64) DEFAULT ''
);

ALTER TABLE  RT_MACHINE_VERIFICATION_DEINFO ADD 
	CONSTRAINT  RT_MACHINE_VERIFICATION_DEINFO_PK PRIMARY KEY 
	(
		DERowID
	);

CREATE TABLE RT_PLAN_DEINFO
(
	DERowID varchar (64) NOT NULL,
	SOPInstanceUID varchar (64) NOT NULL,
	VRType integer NOT NULL,
	GroupNumber integer NOT NULL,
	ElementNumber integer NOT NULL,
	IsSQ varchar (64) NOT NULL,
	ParentSQUID varchar (64) DEFAULT '',
	Value varchar (64) DEFAULT '',
	SQUUID varchar (64) DEFAULT '',
	ItemUUID varchar (64) DEFAULT ''
);

ALTER TABLE  RT_PLAN_DEINFO ADD 
	CONSTRAINT  RT_PLAN_DEINFO_PK PRIMARY KEY 
	(
		DERowID
	);
