Tables [dbo].[SCContractLeaseDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:13 AM Thursday, March 21, 2019
Last Modified1:14:57 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK__SCContra__192920E53615AC95: ContractLeaseDetailIDContractLeaseDetailIDint4
False
1 - 1
Foreign Keys FK_SCContractLeaseDetails_ContractLeaseID_SCContractLeases: [dbo].[SCContractLeases].ContractLeaseIDContractLeaseIDint4
False
Foreign Keys FK_SCContractLeaseDetails_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
FinancedAmountmoney8
False
PaymentAmountmoney8
False
LeaseEquipmentNumbervarchar(32)32
False
Foreign Keys FK_SCContractLeaseDetails_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
Foreign Keys FK_SCContractLeaseDetails_LocationID_ARCustomers: [dbo].[ARCustomers].LocationIDLocationIDint4
True
SCContractDetailInstancedecimal(18,6)9
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SCContra__192920E53615AC95: ContractLeaseDetailIDPK__SCContra__192920E53615AC95ContractLeaseDetailID
True
80
NameColumns
FK_SCContractLeaseDetails_ContractLeaseID_SCContractLeasesContractLeaseID->[dbo].[SCContractLeases].[ContractLeaseID]
FK_SCContractLeaseDetails_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCContractLeaseDetails_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SCContractLeaseDetails_LocationID_ARCustomersLocationID->[dbo].[ARCustomers].[CustomerID]
CREATE TABLE [dbo].[SCContractLeaseDetails]
(
[ContractLeaseDetailID] [int] NOT NULL IDENTITY(1, 1),
[ContractLeaseID] [int] NOT NULL,
[EquipmentID] [int] NULL,
[FinancedAmount] [money] NOT NULL,
[PaymentAmount] [money] NOT NULL,
[LeaseEquipmentNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ItemID] [int] NULL,
[LocationID] [int] NULL,
[SCContractDetailInstance] [decimal] (18, 6) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractLeaseDetails] ADD CONSTRAINT [PK__SCContra__192920E53615AC95] PRIMARY KEY CLUSTERED  ([ContractLeaseDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractLeaseDetails] ADD CONSTRAINT [FK_SCContractLeaseDetails_ContractLeaseID_SCContractLeases] FOREIGN KEY ([ContractLeaseID]) REFERENCES [dbo].[SCContractLeases] ([ContractLeaseID])
GO
ALTER TABLE [dbo].[SCContractLeaseDetails] ADD CONSTRAINT [FK_SCContractLeaseDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCContractLeaseDetails] ADD CONSTRAINT [FK_SCContractLeaseDetails_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCContractLeaseDetails] ADD CONSTRAINT [FK_SCContractLeaseDetails_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO