Tables [dbo].[TCOAcquisition]
PropertyValue
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:32 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDescription
Cluster Primary Key PK_TCOAcquisition_TCOValueSetID: TCOValueSetIDForeign Keys FK_TCOAcquisition_TCOValueSetID_TCOValueSet_ID: [dbo].[TCOValueSet].TCOValueSetIDTCOValueSetIDint4
False
UseDeviceValuesbit1
False
AcquisitionTypesmallint2
False
Lease or Purchase
LeasePointsint4
True
LeaseRatedecimal(12,5)9
True
LeaseStartDatedatetime8
True
PurchaseDatedatetime8
True
DepreciationTermint4
True
Depreciation Term (Months) for Lease or for Purchase
KeyNameKey ColumnsUnique
Cluster Primary Key PK_TCOAcquisition_TCOValueSetID: TCOValueSetIDPK_TCOAcquisition_TCOValueSetIDTCOValueSetID
True
NameUpdateDeleteColumns
FK_TCOAcquisition_TCOValueSetID_TCOValueSet_IDCascadeCascadeTCOValueSetID->[dbo].[TCOValueSet].[ID]
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