CREATE TABLE [dbo].[SCContractScheduleRates]
(
[ContractID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ParentDetailID] [int] NULL,
[Method] [int] NOT NULL,
[RateIncreaseValue] [decimal] (16, 6) NOT NULL,
[RoundNoDigits] [int] NULL,
[ScheduleType] [int] NOT NULL,
[BillingCycleNumber] [int] NOT NULL,
[UseRenewalDate] [bit] NOT NULL,
[BeginDate] [datetime] NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCContractScheduleRates_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCContractScheduleRates_LastUpdate] DEFAULT (getdate()),
[CreatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractScheduleRates] ADD CONSTRAINT [FK_SCContractScheduleRates_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO