Tables [dbo].[TCOSupply]
PropertyValue
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:35 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDescription
Cluster Primary Key PK_TCOSupply_TCOValueSetID: TCOValueSetIDForeign Keys FK_TCOSupply_TCOValueSetID_TCOValueSet_ID: [dbo].[TCOValueSet].TCOValueSetIDTCOValueSetIDint4
False
SupplyCostTypesmallint2
False
CPC, PerCartridge
FilterTypesmallint2
False
First Found, Lowest Cost, Lowest CPC
UseMachineCoveragebit1
False
BlackCoveragedecimal(5,2)5
True
CyanCoveragedecimal(5,2)5
True
MagentaCoveragedecimal(5,2)5
True
YellowCoveragedecimal(5,2)5
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_TCOSupply_TCOValueSetID: TCOValueSetIDPK_TCOSupply_TCOValueSetIDTCOValueSetID
True
NameUpdateDeleteColumns
FK_TCOSupply_TCOValueSetID_TCOValueSet_IDCascadeCascadeTCOValueSetID->[dbo].[TCOValueSet].[ID]
CREATE TABLE [dbo].[TCOSupply]
(
[TCOValueSetID] [int] NOT NULL,
[SupplyCostType] [smallint] NOT NULL,
[FilterType] [smallint] NOT NULL,
[UseMachineCoverage] [bit] NOT NULL,
[BlackCoverage] [decimal] (5, 2) NULL,
[CyanCoverage] [decimal] (5, 2) NULL,
[MagentaCoverage] [decimal] (5, 2) NULL,
[YellowCoverage] [decimal] (5, 2) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOSupply] ADD CONSTRAINT [PK_TCOSupply_TCOValueSetID] PRIMARY KEY CLUSTERED  ([TCOValueSetID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOSupply] ADD CONSTRAINT [FK_TCOSupply_TCOValueSetID_TCOValueSet_ID] FOREIGN KEY ([TCOValueSetID]) REFERENCES [dbo].[TCOValueSet] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
EXEC sp_addextendedproperty N'MS_Description', N'First Found, Lowest Cost, Lowest CPC', 'SCHEMA', N'dbo', 'TABLE', N'TCOSupply', 'COLUMN', N'FilterType'
GO
EXEC sp_addextendedproperty N'MS_Description', N'CPC, PerCartridge', 'SCHEMA', N'dbo', 'TABLE', N'TCOSupply', 'COLUMN', N'SupplyCostType'
GO