[dbo].[REG_PROPERTY

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

1467

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_PROPERTY_VERSION_ID	int	4	1 - 1
$Foreign Keys FK__REG_PROPERTY_VER__4AB81AF0: [dbo].[REG_RESOURCE_VERSION].REG_RID\REG_VERSION$	REG_RID	varchar(50)	50
$Foreign Keys FK__REG_PROPERTY_VER__4AB81AF0: [dbo].[REG_RESOURCE_VERSION].REG_RID\REG_VERSION$	REG_VERSION	int	4
	REG_NAME	varchar(100)	100
	REG_PROPERTY_VALUE	varchar(500)	500

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

REG_PROPERTY_VERSION_ID

int

1 - 1

$Foreign Keys FK__REG_PROPERTY_VER__4AB81AF0: [dbo].[REG_RESOURCE_VERSION].REG_RID\REG_VERSION$

REG_RID

varchar(50)

$Foreign Keys FK__REG_PROPERTY_VER__4AB81AF0: [dbo].[REG_RESOURCE_VERSION].REG_RID\REG_VERSION$

REG_VERSION

int

REG_NAME

varchar(100)

100

REG_PROPERTY_VALUE

varchar(500)

500

	Name	Columns	Unique
	PK__REG_PROPERTY_VER__49C3F6B7	REG_PROPERTY_VERSION_ID

Name

Columns

Unique

PK__REG_PROPERTY_VER__49C3F6B7

REG_PROPERTY_VERSION_ID

Name	Columns
FK__REG_PROPERTY_VER__4AB81AF0	REG_RID->[dbo].[REG_RESOURCE_VERSION].[REG_RID] REG_VERSION->[dbo].[REG_RESOURCE_VERSION].[REG_VERSION]

Name

Columns

FK__REG_PROPERTY_VER__4AB81AF0

REG_RID->[dbo].[REG_RESOURCE_VERSION].[REG_RID]
REG_VERSION->[dbo].[REG_RESOURCE_VERSION].[REG_VERSION]

SQL Script

CREATE TABLE [dbo].[REG_PROPERTY_VERSION]
(
[REG_PROPERTY_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_NAME] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REG_PROPERTY_VALUE] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_PROPERTY_VERSION] ADD CONSTRAINT [PK__REG_PROPERTY_VER__49C3F6B7] PRIMARY KEY CLUSTERED ([REG_PROPERTY_VERSION_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_PROPERTY_VERSION] ADD CONSTRAINT [FK__REG_PROPERTY_VER__4AB81AF0] FOREIGN KEY ([REG_RID], [REG_VERSION]) REFERENCES [dbo].[REG_RESOURCE_VERSION] ([REG_RID], [REG_VERSION])
GO