[dbo].[INFODBL]

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

Property

Value

Row Count

2833

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Primary Key INFODBL_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	DOMAINID	int	4
$Primary Key INFODBL_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	UNITID	int	4
$Primary Key INFODBL_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	ITPRID	int	4
$Primary Key INFODBL_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	ITNAMEID	int	4
$Indexes INFODBL_SK1: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFODBL_SK5: ITROOTID\ITPRNMID\ITDATE$	ITROOTID	int	4
$Indexes INFODBL_SK1: ITPRNMID\ITROOTID\ITRTNMID$	ITRTNMID	int	4
$Indexes INFODBL_SK1: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFODBL_SK5: ITROOTID\ITPRNMID\ITDATE$	ITPRNMID	int	4
	ITIDX	int	4
	ITTYPE	int	4
	ITVAL	real	4
	ITPVAL	real	4
$Indexes INFODBL_SK5: ITROOTID\ITPRNMID\ITDATE$	ITDATE	int	4
	ITLOCK	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key INFODBL_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$

DOMAINID

int

$Primary Key INFODBL_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$

UNITID

int

$Primary Key INFODBL_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$

ITPRID

int

$Primary Key INFODBL_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$

ITNAMEID

int

$Indexes INFODBL_SK1: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFODBL_SK5: ITROOTID\ITPRNMID\ITDATE$

ITROOTID

int

$Indexes INFODBL_SK1: ITPRNMID\ITROOTID\ITRTNMID$

ITRTNMID

int

$Indexes INFODBL_SK1: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFODBL_SK5: ITROOTID\ITPRNMID\ITDATE$

ITPRNMID

int

ITIDX

int

ITTYPE

int

ITVAL

real

ITPVAL

real

$Indexes INFODBL_SK5: ITROOTID\ITPRNMID\ITDATE$

ITDATE

int

ITLOCK

int

	Name	Columns
$Primary Key INFODBL_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	INFODBL_PK	UNITID, ITPRID, ITNAMEID, DOMAINID
	INFODBL_SK1	ITPRNMID, ITROOTID, ITRTNMID
	INFODBL_SK4	UNITID
	INFODBL_SK5	ITROOTID, ITPRNMID, ITDATE

Name

Columns

Unique

$Primary Key INFODBL_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$

INFODBL_PK

UNITID, ITPRID, ITNAMEID, DOMAINID

INFODBL_SK1

ITPRNMID, ITROOTID, ITRTNMID

INFODBL_SK4

UNITID

INFODBL_SK5

ITROOTID, ITPRNMID, ITDATE

SQL Script

CREATE TABLE [dbo].[INFODBL]
(
[DOMAINID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[ITPRID] [int] NOT NULL,
[ITNAMEID] [int] NOT NULL,
[ITROOTID] [int] NULL,
[ITRTNMID] [int] NULL,
[ITPRNMID] [int] NULL,
[ITIDX] [int] NULL,
[ITTYPE] [int] NULL,
[ITVAL] [real] NULL,
[ITPVAL] [real] NULL,
[ITDATE] [int] NULL,
[ITLOCK] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[INFODBL] ADD CONSTRAINT [INFODBL_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [ITPRID], [ITNAMEID], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFODBL_SK1] ON [dbo].[INFODBL] ([ITPRNMID], [ITROOTID], [ITRTNMID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFODBL_SK5] ON [dbo].[INFODBL] ([ITROOTID], [ITPRNMID], [ITDATE]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [INFODBL_SK4] ON [dbo].[INFODBL] ([UNITID]) ON [PRIMARY]
GO