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