[dbo].[REG_RESOURCE

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	1087
Created	1:08:01 AM Thursday, September 10, 2009
Last Modified	1:08:01 AM Thursday, September 10, 2009

	Name	Data Type	Max Length (Bytes)	Identity
	REG_RESOURCE_VERSION_ID	int	4	1 - 1
$Indexes UQ__REG_RESOURCE_VER__440B1D61: REG_RID\REG_VERSION$	REG_RID	varchar(50)	50
$Indexes UQ__REG_RESOURCE_VER__440B1D61: REG_RID\REG_VERSION$	REG_VERSION	int	4
	REG_PATH	varchar(2000)	2000
	REG_MEDIA_TYPE	varchar(500)	500
	REG_COLLECTION	int	4
	REG_CREATOR	varchar(500)	500
	REG_CREATED_TIME	datetime	8
	REG_LAST_UPDATOR	varchar(500)	500
	REG_LAST_UPDATED_TIME	datetime	8
	REG_DESCRIPTION	text	max
	REG_CONTENT_ID	varchar(50)	50
	REG_ASSOCIATED_SNAPSHOT_ID	int	4

	Name	Columns	Unique
	PK__REG_RESOURCE_VER__4316F928	REG_RESOURCE_VERSION_ID
	UQ__REG_RESOURCE_VER__440B1D61	REG_RID, REG_VERSION

Name	Columns
FK__REG_RESOU__REG_C__44FF419A	REG_CONTENT_ID->[dbo].[REG_CONTENT_VERSION].[REG_CONTENT_VERSION_ID]

SQL Script

CREATE TABLE [dbo].[REG_RESOURCE_VERSION]
(
[REG_RESOURCE_VERSION_ID] [int] NOT NULL IDENTITY(1, 1),
[REG_RID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REG_VERSION] [int] NOT NULL,
[REG_PATH] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REG_MEDIA_TYPE] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REG_COLLECTION] [int] NOT NULL,
[REG_CREATOR] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REG_CREATED_TIME] [datetime] NULL,
[REG_LAST_UPDATOR] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REG_LAST_UPDATED_TIME] [datetime] NULL,
[REG_DESCRIPTION] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REG_CONTENT_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REG_ASSOCIATED_SNAPSHOT_ID] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_RESOURCE_VERSION] ADD CONSTRAINT [PK__REG_RESOURCE_VER__4316F928] PRIMARY KEY CLUSTERED ([REG_RESOURCE_VERSION_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_RESOURCE_VERSION] ADD CONSTRAINT [UQ__REG_RESOURCE_VER__440B1D61] UNIQUE NONCLUSTERED ([REG_RID], [REG_VERSION]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_RESOURCE_VERSION] ADD CONSTRAINT [FK__REG_RESOU__REG_C__44FF419A] FOREIGN KEY ([REG_CONTENT_ID]) REFERENCES [dbo].[REG_CONTENT_VERSION] ([REG_CONTENT_VERSION_ID])
GO