Tables [dbo].[SCRateScheduleDetails]
PropertyValue
HeapTrue
Row Count (~)0
Created1:00:14 AM Thursday, March 21, 2019
Last Modified1:15:27 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Foreign Keys FK_SCRateScheduleDetails_ScheduleID_SCRateSchedules: [dbo].[SCRateSchedules].ScheduleIDScheduleIDint4
False
DetailIDint4
False
Methodint4
False
RateIncreaseValuedecimal(16,6)9
False
RoundNoDigitsint4
True
BillingCycleNumberint4
False
NameColumns
FK_SCRateScheduleDetails_ScheduleID_SCRateSchedulesScheduleID->[dbo].[SCRateSchedules].[ScheduleID]
CREATE TABLE [dbo].[SCRateScheduleDetails]
(
[ScheduleID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[Method] [int] NOT NULL,
[RateIncreaseValue] [decimal] (16, 6) NOT NULL,
[RoundNoDigits] [int] NULL,
[BillingCycleNumber] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCRateScheduleDetails] ADD CONSTRAINT [FK_SCRateScheduleDetails_ScheduleID_SCRateSchedules] FOREIGN KEY ([ScheduleID]) REFERENCES [dbo].[SCRateSchedules] ([ScheduleID])
GO