[dbo].[HARENVIRONMENT]

Property	Value
Row Count	17
Created	4:59:41 AM Monday, March 02, 2009
Last Modified	5:00:28 AM Monday, March 02, 2009

Property

Value

Row Count

Created

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

Last Modified

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

	Name	Data Type	Collation	Max Length (Bytes)	Default
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$ $Indexes HARENVIRONMENT_ARCHIVE_IND: ISARCHIVE\ENVOBJID\ENVISACTIVE$	ENVOBJID	int		4
$Indexes HARENVIRONMENT_BASELINE_IND: ENVIRONMENTNAME\BASELINEVIEWID$ $Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	ENVIRONMENTNAME	varchar(128)	SQL_Latin1_General_CP1_CS_AS	128
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$ $Indexes HARENVIRONMENT_ARCHIVE_IND: ISARCHIVE\ENVOBJID\ENVISACTIVE$	ENVISACTIVE	char(1)	SQL_Latin1_General_CP1_CI_AS	1
$Indexes HARENVIRONMENT_BASELINE_IND: ENVIRONMENTNAME\BASELINEVIEWID$ $Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	BASELINEVIEWID	int		4	((0))
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	CREATIONTIME	datetime		8	(getutcdate())
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	CREATORID	int		4
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	MODIFIEDTIME	datetime		8	(getutcdate())
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	MODIFIERID	int		4
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	NOTE	varchar(2000)	SQL_Latin1_General_CP1_CI_AS	2000
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$ $Indexes HARENVIRONMENT_ARCHIVE_IND: ISARCHIVE\ENVOBJID\ENVISACTIVE$	ISARCHIVE	char(1)	SQL_Latin1_General_CP1_CI_AS	1	('N')
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	ARCHIVEBY	int		4	((1))
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	ARCHIVEMACHINE	varchar(256)	SQL_Latin1_General_CP1_CI_AS	256
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	ARCHIVEFILE	varchar(256)	SQL_Latin1_General_CP1_CI_AS	256
$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$	ARCHIVETIME	datetime		8

Name

Data Type

Collation

Max Length (Bytes)

Allow Nulls

Default

$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$ $Indexes HARENVIRONMENT_ARCHIVE_IND: ISARCHIVE\ENVOBJID\ENVISACTIVE$

ENVOBJID

int

$Indexes HARENVIRONMENT_BASELINE_IND: ENVIRONMENTNAME\BASELINEVIEWID$ $Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$

ENVIRONMENTNAME

varchar(128)

SQL_Latin1_General_CP1_CS_AS

128

ENVISACTIVE

char(1)

SQL_Latin1_General_CP1_CI_AS

BASELINEVIEWID

int

((0))

$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$

CREATIONTIME

datetime

(getutcdate())

$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$

CREATORID

int

$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$

MODIFIEDTIME

datetime

(getutcdate())

$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$

MODIFIERID

int

$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$

NOTE

varchar(2000)

SQL_Latin1_General_CP1_CI_AS

2000

ISARCHIVE

char(1)

SQL_Latin1_General_CP1_CI_AS

('N')

$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$

ARCHIVEBY

int

((1))

$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$

ARCHIVEMACHINE

varchar(256)

SQL_Latin1_General_CP1_CI_AS

256

$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$

ARCHIVEFILE

varchar(256)

SQL_Latin1_General_CP1_CI_AS

256

$Indexes HARENVIRONMENT_ACTIVE_IND: ENVIRONMENTNAME\BASELINEVIEWID\CREATIONTIME\CREATORID\MODIFIEDTIME\MODIFIERID\NOTE\ARCHIVEBY\ARCHIVEMACHINE\ARCHIVEFILE\ARCHIVETIME\ENVISACTIVE\ISARCHIVE\ENVOBJID$

ARCHIVETIME

datetime

	Name	Columns	Unique
	HARENVIRONMENT_PK	ENVOBJID
	HARENVIRONMENT_IND	ENVIRONMENTNAME
	HARENVIRONMENT_ACTIVE_IND	ENVIRONMENTNAME, BASELINEVIEWID, CREATIONTIME, CREATORID, MODIFIEDTIME, MODIFIERID, NOTE, ARCHIVEBY, ARCHIVEMACHINE, ARCHIVEFILE, ARCHIVETIME, ENVISACTIVE, ISARCHIVE, ENVOBJID
	HARENVIRONMENT_ARCHIVE_IND	ISARCHIVE, ENVOBJID, ENVISACTIVE
	HARENVIRONMENT_BASELINE_IND	ENVIRONMENTNAME, BASELINEVIEWID

Name

Columns

Unique

HARENVIRONMENT_PK

ENVOBJID

HARENVIRONMENT_IND

ENVIRONMENTNAME

HARENVIRONMENT_ACTIVE_IND

ENVIRONMENTNAME, BASELINEVIEWID, CREATIONTIME, CREATORID, MODIFIEDTIME, MODIFIERID, NOTE, ARCHIVEBY, ARCHIVEMACHINE, ARCHIVEFILE, ARCHIVETIME, ENVISACTIVE, ISARCHIVE, ENVOBJID

HARENVIRONMENT_ARCHIVE_IND

ISARCHIVE, ENVOBJID, ENVISACTIVE

HARENVIRONMENT_BASELINE_IND

ENVIRONMENTNAME, BASELINEVIEWID

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARENVIRONMENT table stores the active environment objects. If users delete an environment, it will be removed from this table. However, the environment object information will be stored in the harAllEnvirs table.
Caption	COLUMN	ARCHIVEBY	User object ID who archived project
Caption	COLUMN	ARCHIVEFILE	Archive file name of project
Caption	COLUMN	ARCHIVEMACHINE	Computer name where project was archived to
Caption	COLUMN	ARCHIVETIME	Time of archive
Caption	COLUMN	BASELINEVIEWID	Baseline view object ID of project
Caption	COLUMN	CREATIONTIME	Time object was created
Caption	COLUMN	CREATORID	Object ID of creator
Caption	COLUMN	ENVIRONMENTNAME	Project name
Caption	COLUMN	ENVISACTIVE	Project active flag
Caption	COLUMN	ENVOBJID	Object ID of project
Caption	COLUMN	ISARCHIVE	Project has been archived (Y/N)
Caption	COLUMN	MODIFIEDTIME	Time object was modified
Caption	COLUMN	MODIFIERID	Object ID of modifier
Caption	COLUMN	NOTE	User-defined note

Name

Level 2 Type

Level 2 Name

Value

Caption

The HARENVIRONMENT table stores the active environment objects. If users delete an environment, it will be removed from this table. However, the environment object information will be stored in the harAllEnvirs table.

Caption

COLUMN

ARCHIVEBY

User object ID who archived project

Caption

COLUMN

ARCHIVEFILE

Archive file name of project

Caption

COLUMN

ARCHIVEMACHINE

Computer name where project was archived to

Caption

COLUMN

ARCHIVETIME

Time of archive

Caption

COLUMN

BASELINEVIEWID

Baseline view object ID of project

Caption

COLUMN

CREATIONTIME

Time object was created

Caption

COLUMN

CREATORID

Object ID of creator

Caption

COLUMN

ENVIRONMENTNAME

Project name

Caption

COLUMN

ENVISACTIVE

Project active flag

Caption

COLUMN

ENVOBJID

Object ID of project

Caption

COLUMN

ISARCHIVE

Project has been archived (Y/N)

Caption

COLUMN

MODIFIEDTIME

Time object was modified

Caption

COLUMN

MODIFIERID

Object ID of modifier

Caption

COLUMN

NOTE

User-defined note

SQL Script

CREATE TABLE [dbo].[HARENVIRONMENT]
(
[ENVOBJID] [int] NOT NULL,
[ENVIRONMENTNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ENVISACTIVE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BASELINEVIEWID] [int] NOT NULL CONSTRAINT [DF__HARENVIRO__BASEL__34C8D9D1] DEFAULT ((0)),
[CREATIONTIME] [datetime] NOT NULL CONSTRAINT [DF__HARENVIRO__CREAT__35BCFE0A] DEFAULT (getutcdate()),
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL CONSTRAINT [DF__HARENVIRO__MODIF__36B12243] DEFAULT (getutcdate()),
[MODIFIERID] [int] NOT NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISARCHIVE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARENVIRO__ISARC__37A5467C] DEFAULT ('N'),
[ARCHIVEBY] [int] NOT NULL CONSTRAINT [DF__HARENVIRO__ARCHI__38996AB5] DEFAULT ((1)),
[ARCHIVEMACHINE] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ARCHIVEFILE] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ARCHIVETIME] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARENVIRONMENT] ADD CONSTRAINT [HARENVIRONMENT_PK] PRIMARY KEY CLUSTERED ([ENVOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARENVIRONMENT_IND] ON [dbo].[HARENVIRONMENT] ([ENVIRONMENTNAME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARENVIRONMENT_BASELINE_IND] ON [dbo].[HARENVIRONMENT] ([BASELINEVIEWID]) INCLUDE ([ENVIRONMENTNAME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARENVIRONMENT_ACTIVE_IND] ON [dbo].[HARENVIRONMENT] ([ENVISACTIVE], [ISARCHIVE], [ENVOBJID]) INCLUDE ([ARCHIVEBY], [ARCHIVEFILE], [ARCHIVEMACHINE], [ARCHIVETIME], [BASELINEVIEWID], [CREATIONTIME], [CREATORID], [ENVIRONMENTNAME], [MODIFIEDTIME], [MODIFIERID], [NOTE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARENVIRONMENT_ARCHIVE_IND] ON [dbo].[HARENVIRONMENT] ([ISARCHIVE], [ENVOBJID], [ENVISACTIVE]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARENVIRONMENT table stores the active environment objects. If users delete an environment, it will be removed from this table. However, the environment object information will be stored in the harAllEnvirs table. ', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'User object ID who archived project', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'ARCHIVEBY'
GO
EXEC sp_addextendedproperty N'Caption', N'Archive file name of project', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'ARCHIVEFILE'
GO
EXEC sp_addextendedproperty N'Caption', N'Computer name where project was archived to', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'ARCHIVEMACHINE'
GO
EXEC sp_addextendedproperty N'Caption', N'Time of archive', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'ARCHIVETIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Baseline view object ID of project', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'BASELINEVIEWID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Project name', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'ENVIRONMENTNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Project active flag', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'ENVISACTIVE'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of project', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'ENVOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Project has been archived (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'ISARCHIVE'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARENVIRONMENT', 'COLUMN', N'NOTE'
GO