Tables [dbo].[SuppliesHistory]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:03 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_SuppliesHistory: DeviceID\ConsumableHashCodeDeviceIDint4
False
Cluster Primary Key PK_SuppliesHistory: DeviceID\ConsumableHashCodeConsumableHashCodeint4
False
ParameterTypesmallint2
True
ConsumableTypeint4
True
ConsumableNamenvarchar(100)200
True
ConsumableColorantTypevarchar(50)50
True
ColorantIndexsmallint2
True
UpdateDatedatetime8
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_SuppliesHistory: DeviceID\ConsumableHashCodePK_SuppliesHistoryDeviceID, ConsumableHashCode
True
CREATE TABLE [dbo].[SuppliesHistory]
(
[DeviceID] [int] NOT NULL,
[ConsumableHashCode] [int] NOT NULL,
[ParameterType] [smallint] NULL,
[ConsumableType] [int] NULL,
[ConsumableName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConsumableColorantType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ColorantIndex] [smallint] NULL,
[UpdateDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SuppliesHistory] ADD CONSTRAINT [PK_SuppliesHistory] PRIMARY KEY CLUSTERED  ([DeviceID], [ConsumableHashCode]) ON [PRIMARY]
GO