[dbo].[INFOTREE]

Property	Value
Row Count	6039
Created	3:44:36 PM Friday, June 13, 2003
Last Modified	3:44:36 PM Friday, June 13, 2003

Property

Value

Row Count

6039

Created

3:44:36 PM Friday, June 13, 2003

Last Modified

3:44:36 PM Friday, June 13, 2003

	Name	Data Type	Max Length (Bytes)
$Primary Key INFOTREE_PK: UNITID\ITID\DOMAINID$	DOMAINID	int	4
$Primary Key INFOTREE_PK: UNITID\ITID\DOMAINID$	UNITID	int	4
$Primary Key INFOTREE_PK: UNITID\ITID\DOMAINID$	ITID	int	4
$Indexes INFOTREE_SK3: ITPRID\ITROOTID$	ITROOTID	int	4
	ITRTNMID	int	4
$Indexes INFOTREE_SK3: ITPRID\ITROOTID$	ITPRID	int	4
	ITPRNMID	int	4
$Indexes INFOTREE_SK2: ITNAMEID\ITIDENT$	ITIDENT	int	4
	ITIDX	int	4
$Indexes INFOTREE_SK2: ITNAMEID\ITIDENT$	ITNAMEID	int	4
	ITFLAG	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key INFOTREE_PK: UNITID\ITID\DOMAINID$

DOMAINID

int

$Primary Key INFOTREE_PK: UNITID\ITID\DOMAINID$

UNITID

int

$Primary Key INFOTREE_PK: UNITID\ITID\DOMAINID$

ITID

int

$Indexes INFOTREE_SK3: ITPRID\ITROOTID$

ITROOTID

int

ITRTNMID

int

$Indexes INFOTREE_SK3: ITPRID\ITROOTID$

ITPRID

int

ITPRNMID

int

$Indexes INFOTREE_SK2: ITNAMEID\ITIDENT$

ITIDENT

int

ITIDX

int

$Indexes INFOTREE_SK2: ITNAMEID\ITIDENT$

ITNAMEID

int

ITFLAG

int

	Name	Columns
$Primary Key INFOTREE_PK: UNITID\ITID\DOMAINID$	INFOTREE_PK	UNITID, ITID, DOMAINID
	INFOTREE_SK2	ITNAMEID, ITIDENT
	INFOTREE_SK3	ITPRID, ITROOTID
	INFOTREE_SK5	ITRTNMID
	INFOTREE_SK6	UNITID
	INFOTREE_SK7	ITPRNMID

Name

Columns

Unique

$Primary Key INFOTREE_PK: UNITID\ITID\DOMAINID$

INFOTREE_PK

UNITID, ITID, DOMAINID

INFOTREE_SK2

ITNAMEID, ITIDENT

INFOTREE_SK3

ITPRID, ITROOTID

INFOTREE_SK5

ITRTNMID

INFOTREE_SK6

UNITID

INFOTREE_SK7

ITPRNMID

SQL Script

CREATE TABLE [dbo].[INFOTREE]
(
[DOMAINID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[ITID] [int] NOT NULL,
[ITROOTID] [int] NULL,
[ITRTNMID] [int] NULL,
[ITPRID] [int] NULL,
[ITPRNMID] [int] NULL,
[ITIDENT] [int] NULL,
[ITIDX] [int] NULL,
[ITNAMEID] [int] NULL,
[ITFLAG] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[INFOTREE] ADD CONSTRAINT [INFOTREE_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [ITID], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOTREE_SK2] ON [dbo].[INFOTREE] ([ITNAMEID], [ITIDENT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOTREE_SK3] ON [dbo].[INFOTREE] ([ITPRID], [ITROOTID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOTREE_SK7] ON [dbo].[INFOTREE] ([ITPRNMID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOTREE_SK5] ON [dbo].[INFOTREE] ([ITRTNMID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [INFOTREE_SK6] ON [dbo].[INFOTREE] ([UNITID]) ON [PRIMARY]
GO