[dbo].[hardware_sd_server

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:08:11 AM Wednesday, March 07, 2007
Last Modified	6:12:43 PM Monday, May 04, 2009

Name	Data Type	Max Length (Bytes)
hardware_sd_server_matrix_id	binary(16)	16
is_evm_deleted	tinyint	1
dis_hw_uuid	binary(16)	16
software_delivery_server_id	binary(16)	16
creation_user	nvarchar(64)	128
creation_date	int	4

	Name	Columns	Unique
	XPKhardware_sd_server_matrix	hardware_sd_server_matrix_id
	xif1hardware_sd_server_matrix	dis_hw_uuid
	xif2hardware_sd_server_matrix	software_delivery_server_id

Name	Columns
$hardw_r00001d0800000000	software_delivery_server_id->[dbo].[software_delivery_server].[software_delivery_server_id]
$hardw_r00001d1100000000	dis_hw_uuid->[dbo].[ca_discovered_hardware].[dis_hw_uuid]

SQL Script

CREATE TABLE [dbo].[hardware_sd_server_matrix]
(
[hardware_sd_server_matrix_id] [binary] (16) NOT NULL,
[is_evm_deleted] [tinyint] NULL,
[dis_hw_uuid] [binary] (16) NOT NULL,
[software_delivery_server_id] [binary] (16) NOT NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[hardware_sd_server_matrix] ADD CONSTRAINT [XPKhardware_sd_server_matrix] PRIMARY KEY CLUSTERED ([hardware_sd_server_matrix_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1hardware_sd_server_matrix] ON [dbo].[hardware_sd_server_matrix] ([dis_hw_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2hardware_sd_server_matrix] ON [dbo].[hardware_sd_server_matrix] ([software_delivery_server_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[hardware_sd_server_matrix] ADD CONSTRAINT [$hardw_r00001d0800000000] FOREIGN KEY ([software_delivery_server_id]) REFERENCES [dbo].[software_delivery_server] ([software_delivery_server_id])
GO
ALTER TABLE [dbo].[hardware_sd_server_matrix] ADD CONSTRAINT [$hardw_r00001d1100000000] FOREIGN KEY ([dis_hw_uuid]) REFERENCES [dbo].[ca_discovered_hardware] ([dis_hw_uuid])
GO