Project
>
DEVSQL2016EA172
>
User databases
>
CoSample_17_2
>
Tables
> dbo.SCRateScheduleDetails
[dbo].[SCRateScheduleDetails]
Properties
Property
Value
Heap
True
Row Count (~)
0
Created
1:00:14 AM Thursday, March 21, 2019
Last Modified
1:15:27 AM Thursday, March 21, 2019
Columns
Key
Name
Data Type
Max Length (Bytes)
Allow Nulls
ScheduleID
int
4
False
DetailID
int
4
False
Method
int
4
False
RateIncreaseValue
decimal(16,6)
9
False
RoundNoDigits
int
4
True
BillingCycleNumber
int
4
False
Foreign Keys
Name
Columns
FK_SCRateScheduleDetails_ScheduleID_SCRateSchedules
ScheduleID->
[dbo].[SCRateSchedules].[ScheduleID]
SQL Script
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
Uses
[dbo].[SCRateSchedules]