[dbo].[INFOLNG]

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

Property

Value

Row Count

19175

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 INFOLNG_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	DOMAINID	int	4
$Primary Key INFOLNG_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	UNITID	int	4
$Primary Key INFOLNG_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	ITPRID	int	4
$Primary Key INFOLNG_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	ITNAMEID	int	4
$Indexes INFOLNG_SK2: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFOLNG_SK6: ITROOTID\ITPRNMID\ITDATE$	ITROOTID	int	4
$Indexes INFOLNG_SK2: ITPRNMID\ITROOTID\ITRTNMID$	ITRTNMID	int	4
$Indexes INFOLNG_SK2: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFOLNG_SK6: ITROOTID\ITPRNMID\ITDATE$	ITPRNMID	int	4
	ITIDX	int	4
	ITTYPE	int	4
	ITVAL	int	4
	ITPVAL	int	4
$Indexes INFOLNG_SK6: ITROOTID\ITPRNMID\ITDATE$	ITDATE	int	4
	ITLOCK	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

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

DOMAINID

int

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

UNITID

int

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

ITPRID

int

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

ITNAMEID

int

$Indexes INFOLNG_SK2: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFOLNG_SK6: ITROOTID\ITPRNMID\ITDATE$

ITROOTID

int

$Indexes INFOLNG_SK2: ITPRNMID\ITROOTID\ITRTNMID$

ITRTNMID

int

$Indexes INFOLNG_SK2: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFOLNG_SK6: ITROOTID\ITPRNMID\ITDATE$

ITPRNMID

int

ITIDX

int

ITTYPE

int

ITVAL

int

ITPVAL

int

$Indexes INFOLNG_SK6: ITROOTID\ITPRNMID\ITDATE$

ITDATE

int

ITLOCK

int

	Name	Columns
$Primary Key INFOLNG_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	INFOLNG_PK	UNITID, ITPRID, ITNAMEID, DOMAINID
	INFOLNG_SK1	ITVAL
	INFOLNG_SK2	ITPRNMID, ITROOTID, ITRTNMID
	INFOLNG_SK5	UNITID
	INFOLNG_SK6	ITROOTID, ITPRNMID, ITDATE

Name

Columns

Unique

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

INFOLNG_PK

UNITID, ITPRID, ITNAMEID, DOMAINID

INFOLNG_SK1

ITVAL

INFOLNG_SK2

ITPRNMID, ITROOTID, ITRTNMID

INFOLNG_SK5

UNITID

INFOLNG_SK6

ITROOTID, ITPRNMID, ITDATE

SQL Script

CREATE TABLE [dbo].[INFOLNG]
(
[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] [int] NULL,
[ITPVAL] [int] NULL,
[ITDATE] [int] NULL,
[ITLOCK] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[INFOLNG] ADD CONSTRAINT [INFOLNG_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [ITPRID], [ITNAMEID], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOLNG_SK2] ON [dbo].[INFOLNG] ([ITPRNMID], [ITROOTID], [ITRTNMID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOLNG_SK6] ON [dbo].[INFOLNG] ([ITROOTID], [ITPRNMID], [ITDATE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOLNG_SK1] ON [dbo].[INFOLNG] ([ITVAL]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [INFOLNG_SK5] ON [dbo].[INFOLNG] ([UNITID]) ON [PRIMARY]
GO