Create Table Account_InterestRates (
                                    AIR_Sequence integer Identity(1,1) NOT NULL,
				    AIR_RepID varchar(20) NOT NULL,
				    AIR_Date  datetime NOT NULL,
                                    AIR_IntClass varchar(2) NOT NULL,
                                    AIR_CreditRate float Null,
                                    AIR_DebitRate float  Null,
                                    AIR_TempRecord bit null default 0,
                                    AIR_IsFrozen bit null default 0,
                                    AIR_ShortRate float Null,
                                    CONSTRAINT PK_Account_InterestRates PRIMARY KEY NONCLUSTERED (AIR_Sequence)
                                   );

ALTER TABLE [dbo].[Account_InterestRates] ADD
	CONSTRAINT [FK_Account_InterestRates_General_UserInfo] FOREIGN KEY
	(
		[AIR_RepId]
	) REFERENCES [dbo].[General_UserInfo] (
		[CUC_LoginName]
	) ON UPDATE CASCADE
