[dbo].[sd_server_download

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

Name	Data Type	Max Length (Bytes)
sd_server_download_file_id	binary(16)	16
software_delivery_server_id	binary(16)	16
download_file_id	binary(16)	16
upload_date	int	4
uploaded_by	nvarchar(64)	128
creation_user	nvarchar(64)	128
creation_date	int	4
last_update_user	nvarchar(64)	128
last_update_date	int	4
version_number	int	4
auto_rep_version	timestamp	8

	Name	Columns	Unique
	XPKsd_server_download_file	sd_server_download_file_id
	xif1sd_server_download_file	software_delivery_server_id
	xif2sd_server_download_file	download_file_id

Name	Columns
$sd_se_r00001cda00000000	software_delivery_server_id->[dbo].[software_delivery_server].[software_delivery_server_id]

SQL Script

CREATE TABLE [dbo].[sd_server_download_file]
(
[sd_server_download_file_id] [binary] (16) NOT NULL,
[software_delivery_server_id] [binary] (16) NOT NULL,
[download_file_id] [binary] (16) NOT NULL,
[upload_date] [int] NULL,
[uploaded_by] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL,
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[sd_server_download_file] ADD CONSTRAINT [XPKsd_server_download_file] PRIMARY KEY CLUSTERED ([sd_server_download_file_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2sd_server_download_file] ON [dbo].[sd_server_download_file] ([download_file_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1sd_server_download_file] ON [dbo].[sd_server_download_file] ([software_delivery_server_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[sd_server_download_file] ADD CONSTRAINT [$sd_se_r00001cda00000000] FOREIGN KEY ([software_delivery_server_id]) REFERENCES [dbo].[software_delivery_server] ([software_delivery_server_id])
GO