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