[dbo].[HARVIEW]

Property	Value
Row Count	61
Created	5:00:24 AM Monday, March 02, 2009
Last Modified	5:00:28 AM Monday, March 02, 2009

	Name	Data Type	Collation	Max Length (Bytes)	Default
$Indexes HARVIEW_OBJIDNAME: VIEWOBJID\VIEWNAME$ $Indexes HARVIEW_ENV_IND: VIEWOBJID\VIEWTYPE\ENVOBJID$ $Indexes HARVIEW_VIEWTYPE: VIEWTYPE\ENVOBJID\VIEWOBJID$	VIEWOBJID	int		4
$Indexes HARVIEW_NAME_IND: VIEWNAME\ENVOBJID$ $Indexes HARVIEW_OBJIDNAME: VIEWOBJID\VIEWNAME$	VIEWNAME	varchar(128)	SQL_Latin1_General_CP1_CS_AS	128
$Indexes HARVIEW_ENV_IND: VIEWOBJID\VIEWTYPE\ENVOBJID$ $Indexes HARVIEW_VIEWTYPE: VIEWTYPE\ENVOBJID\VIEWOBJID$	VIEWTYPE	varchar(16)	SQL_Latin1_General_CP1_CI_AS	16
$Indexes HARVIEW_NAME_IND: VIEWNAME\ENVOBJID$ $Indexes HARVIEW_ENV_IND: VIEWOBJID\VIEWTYPE\ENVOBJID$ $Indexes HARVIEW_VIEWTYPE: VIEWTYPE\ENVOBJID\VIEWOBJID$	ENVOBJID	int		4
	CANVIEWEXTERNALLY	char(1)	SQL_Latin1_General_CP1_CI_AS	1
	BASELINEVIEWID	int		4
	CREATIONTIME	datetime		8	(getutcdate())
	CREATORID	int		4
	MODIFIEDTIME	datetime		8	(getutcdate())
	MODIFIERID	int		4
	SNAPSHOTTIME	datetime		8	(getutcdate())
	NOTE	varchar(2000)	SQL_Latin1_General_CP1_CI_AS	2000

	Name	Columns	Unique
	HARVIEW_PK	VIEWOBJID
	HARVIEW_NAME_IND	VIEWNAME, ENVOBJID
	HARVIEW_OBJIDNAME	VIEWOBJID, VIEWNAME
	HARVIEW_ENV_IND	VIEWOBJID, VIEWTYPE, ENVOBJID
	HARVIEW_VIEWTYPE	VIEWTYPE, ENVOBJID, VIEWOBJID

Name	Delete	Columns
HARVIEW_ENVID_FK	Cascade	ENVOBJID->[dbo].[HARENVIRONMENT].[ENVOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARVIEW table stores the view object.
Caption	COLUMN	BASELINEVIEWID	View object ID that view is based on
Caption	COLUMN	CANVIEWEXTERNALLY	Indicate view is globally visible
Caption	COLUMN	CREATIONTIME	Time object was created
Caption	COLUMN	CREATORID	Object ID of creator
Caption	COLUMN	ENVOBJID	Object ID of project
Caption	COLUMN	MODIFIEDTIME	Time object was modified
Caption	COLUMN	MODIFIERID	Object ID of modifier
Caption	COLUMN	NOTE	User-defined note
Caption	COLUMN	SNAPSHOTTIME	Time to filter versions for the snapshot view
Caption	COLUMN	VIEWNAME	Name of view object
Caption	COLUMN	VIEWOBJID	Object ID of view
Caption	COLUMN	VIEWTYPE	Working view/snapshotview/no view

SQL Script

CREATE TABLE [dbo].[HARVIEW]
(
[VIEWOBJID] [int] NOT NULL,
[VIEWNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[VIEWTYPE] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ENVOBJID] [int] NOT NULL,
[CANVIEWEXTERNALLY] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BASELINEVIEWID] [int] NOT NULL,
[CREATIONTIME] [datetime] NOT NULL CONSTRAINT [DF__HARVIEW__CREATIO__336AA144] DEFAULT (getutcdate()),
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL CONSTRAINT [DF__HARVIEW__MODIFIE__345EC57D] DEFAULT (getutcdate()),
[MODIFIERID] [int] NOT NULL,
[SNAPSHOTTIME] [datetime] NULL CONSTRAINT [DF__HARVIEW__SNAPSHO__3552E9B6] DEFAULT (getutcdate()),
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARVIEW] ADD CONSTRAINT [HARVIEW_PK] PRIMARY KEY CLUSTERED ([VIEWOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARVIEW_NAME_IND] ON [dbo].[HARVIEW] ([VIEWNAME], [ENVOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARVIEW_OBJIDNAME] ON [dbo].[HARVIEW] ([VIEWOBJID], [VIEWNAME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVIEW_ENV_IND] ON [dbo].[HARVIEW] ([ENVOBJID]) INCLUDE ([VIEWOBJID], [VIEWTYPE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVIEW_VIEWTYPE] ON [dbo].[HARVIEW] ([VIEWTYPE], [ENVOBJID], [VIEWOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARVIEW] ADD CONSTRAINT [HARVIEW_ENVID_FK] FOREIGN KEY ([ENVOBJID]) REFERENCES [dbo].[HARENVIRONMENT] ([ENVOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARVIEW table stores the view object. ', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'View object ID that view is based on', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'BASELINEVIEWID'
GO
EXEC sp_addextendedproperty N'Caption', N'Indicate view is globally visible', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'CANVIEWEXTERNALLY'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of project', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'ENVOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Time to filter versions for the snapshot view', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'SNAPSHOTTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of view object', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'VIEWNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of view', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'VIEWOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Working view/snapshotview/no view', 'SCHEMA', N'dbo', 'TABLE', N'HARVIEW', 'COLUMN', N'VIEWTYPE'
GO