CREATE TABLE VS4TFundRate
	(
	TFuRTFunAlias nvarchar(30) NOT NULL,
	TFuRFromBase float(53) NOT NULL,
	TFuRTEmTCode nvarchar(30) NOT NULL,
	TFuRRate real NULL,
	TFuRShareRate1 real NULL,
	TFuRShareRate2 real NULL,
	TFuRFlag1 smallint NULL,
	TFuRFlag2 smallint NULL,
	TFuRFlag3 datetime NULL
	)  ON [PRIMARY]
GO
ALTER TABLE VS4TFundRate ADD CONSTRAINT
	PK_VS4TFundRate PRIMARY KEY CLUSTERED 
	(
	TFuRTFunAlias,
	TFuRFromBase,
	TFuRTEmTCode
	) ON [PRIMARY]
GO
ALTER TABLE VS4TFundRate ADD CONSTRAINT
	VS4TFundVS4TFundRate FOREIGN KEY
	(
	TFuRTFunAlias
	) REFERENCES VS4TFund
	(
	TFunAlias
	) ON UPDATE  CASCADE 
	 ON DELETE  NO ACTION 
GO