CREATE TABLE [dbo].[TCOAcquisition]
(
[TCOValueSetID] [int] NOT NULL,
[UseDeviceValues] [bit] NOT NULL,
[AcquisitionType] [smallint] NOT NULL,
[LeasePoints] [int] NULL,
[LeaseRate] [decimal] (12, 5) NULL,
[LeaseStartDate] [datetime] NULL,
[PurchaseDate] [datetime] NULL,
[DepreciationTerm] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOAcquisition] ADD CONSTRAINT [PK_TCOAcquisition_TCOValueSetID] PRIMARY KEY CLUSTERED ([TCOValueSetID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOAcquisition] ADD CONSTRAINT [FK_TCOAcquisition_TCOValueSetID_TCOValueSet_ID] FOREIGN KEY ([TCOValueSetID]) REFERENCES [dbo].[TCOValueSet] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
EXEC sp_addextendedproperty N'MS_Description', N'Lease or Purchase', 'SCHEMA', N'dbo', 'TABLE', N'TCOAcquisition', 'COLUMN', N'AcquisitionType'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Depreciation Term (Months) for Lease or for Purchase', 'SCHEMA', N'dbo', 'TABLE', N'TCOAcquisition', 'COLUMN', N'DepreciationTerm'
GO