[dbo].[HARFILEEXTENSION]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	44
Created	4:59:44 AM Monday, March 02, 2009
Last Modified	5:00:26 AM Monday, March 02, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

4:59:44 AM Monday, March 02, 2009

Last Modified

5:00:26 AM Monday, March 02, 2009

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key HARFILEEXTENSION_PK: REPOSITOBJID\FILEEXTENSION$	REPOSITOBJID	int	4
$Cluster Primary Key HARFILEEXTENSION_PK: REPOSITOBJID\FILEEXTENSION$	FILEEXTENSION	varchar(64)	64

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key HARFILEEXTENSION_PK: REPOSITOBJID\FILEEXTENSION$

REPOSITOBJID

int

$Cluster Primary Key HARFILEEXTENSION_PK: REPOSITOBJID\FILEEXTENSION$

FILEEXTENSION

varchar(64)

	Name	Columns	Unique
$Cluster Primary Key HARFILEEXTENSION_PK: REPOSITOBJID\FILEEXTENSION$	HARFILEEXTENSION_PK	REPOSITOBJID, FILEEXTENSION

Name

Columns

Unique

$Cluster Primary Key HARFILEEXTENSION_PK: REPOSITOBJID\FILEEXTENSION$

HARFILEEXTENSION_PK

REPOSITOBJID, FILEEXTENSION

Name	Delete	Columns
HARFILEEXTENSION_REPID_FK	Cascade	REPOSITOBJID->[dbo].[HARREPOSITORY].[REPOSITOBJID]

Name

Delete

Columns

HARFILEEXTENSION_REPID_FK

Cascade

REPOSITOBJID->[dbo].[HARREPOSITORY].[REPOSITOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARFILEEXTENSION table stores the file extension information.
Caption	COLUMN	FILEEXTENSION	File extension
Caption	COLUMN	REPOSITOBJID	Object ID of repository

Name

Level 2 Type

Level 2 Name

Value

Caption

The HARFILEEXTENSION table stores the file extension information.

Caption

COLUMN

FILEEXTENSION

File extension

Caption

COLUMN

REPOSITOBJID

Object ID of repository

SQL Script

CREATE TABLE [dbo].[HARFILEEXTENSION]
(
[REPOSITOBJID] [int] NOT NULL,
[FILEEXTENSION] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARFILEEXTENSION] ADD CONSTRAINT [HARFILEEXTENSION_PK] PRIMARY KEY CLUSTERED ([REPOSITOBJID], [FILEEXTENSION]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARFILEEXTENSION] ADD CONSTRAINT [HARFILEEXTENSION_REPID_FK] FOREIGN KEY ([REPOSITOBJID]) REFERENCES [dbo].[HARREPOSITORY] ([REPOSITOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARFILEEXTENSION table stores the file extension information. ', 'SCHEMA', N'dbo', 'TABLE', N'HARFILEEXTENSION', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'File extension', 'SCHEMA', N'dbo', 'TABLE', N'HARFILEEXTENSION', 'COLUMN', N'FILEEXTENSION'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of repository', 'SCHEMA', N'dbo', 'TABLE', N'HARFILEEXTENSION', 'COLUMN', N'REPOSITOBJID'
GO