Tables [dbo].[SCContractScheduleRates]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:59:18 AM Thursday, March 21, 2019
Last Modified1:15:03 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Foreign Keys FK_SCContractScheduleRates_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
False
DetailIDint4
False
ParentDetailIDint4
True
Methodint4
False
RateIncreaseValuedecimal(16,6)9
False
RoundNoDigitsint4
True
ScheduleTypeint4
False
BillingCycleNumberint4
False
UseRenewalDatebit1
False
BeginDatedatetime8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
CreatorIDvarchar(8)8
False
UpdatorIDvarchar(8)8
False
NameColumns
FK_SCContractScheduleRates_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
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