[dbo].[INFOQLT]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	0
Created	3:44:36 PM Friday, June 13, 2003
Last Modified	3:44:36 PM Friday, June 13, 2003

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

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)
	DOMAINID	int	4
$Indexes IQLT_ITEMS: ITGRNMID\ITRTNMID\ITIDENT$ $Indexes IQLT_GROUPS: ITPRNMID\ITRTNMID\ITIDENT$	ITRTNMID	int	4
	ITRTNAME	varchar(127)	127
$Indexes IQLT_GROUPS: ITPRNMID\ITRTNMID\ITIDENT$	ITPRNMID	int	4
	ITPRNAME	varchar(127)	127
$Indexes IQLT_ITEMS: ITGRNMID\ITRTNMID\ITIDENT$	ITGRNMID	int	4
	ITGRNAME	varchar(127)	127
	ITGRRWNM	varchar(127)	127
$Indexes IQLT_ITEMS: ITGRNMID\ITRTNMID\ITIDENT$ $Indexes IQLT_GROUPS: ITPRNMID\ITRTNMID\ITIDENT$	ITIDENT	int	4
	ITFLAG	int	4
	ITNAMEID	int	4
	ITNAME	varchar(127)	127
	ITTBL	int	4
	ITTYPE	int	4
	UTYPE	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

DOMAINID

int

$Indexes IQLT_ITEMS: ITGRNMID\ITRTNMID\ITIDENT$ $Indexes IQLT_GROUPS: ITPRNMID\ITRTNMID\ITIDENT$

ITRTNMID

int

ITRTNAME

varchar(127)

127

$Indexes IQLT_GROUPS: ITPRNMID\ITRTNMID\ITIDENT$

ITPRNMID

int

ITPRNAME

varchar(127)

127

$Indexes IQLT_ITEMS: ITGRNMID\ITRTNMID\ITIDENT$

ITGRNMID

int

ITGRNAME

varchar(127)

127

ITGRRWNM

varchar(127)

127

$Indexes IQLT_ITEMS: ITGRNMID\ITRTNMID\ITIDENT$

$Indexes IQLT_GROUPS: ITPRNMID\ITRTNMID\ITIDENT$

ITIDENT

int

ITFLAG

int

ITNAMEID

int

ITNAME

varchar(127)

127

ITTBL

int

ITTYPE

int

UTYPE

int

Name	Columns
IQLT_COMPONENTS	ITIDENT
IQLT_GROUPS	ITPRNMID, ITRTNMID, ITIDENT
IQLT_ITEMS	ITGRNMID, ITRTNMID, ITIDENT

Name

Columns

IQLT_COMPONENTS

ITIDENT

IQLT_GROUPS

ITPRNMID, ITRTNMID, ITIDENT

IQLT_ITEMS

ITGRNMID, ITRTNMID, ITIDENT

SQL Script

CREATE TABLE [dbo].[INFOQLT]
(
[DOMAINID] [int] NULL,
[ITRTNMID] [int] NULL,
[ITRTNAME] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ITPRNMID] [int] NULL,
[ITPRNAME] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ITGRNMID] [int] NULL,
[ITGRNAME] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ITGRRWNM] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ITIDENT] [int] NULL,
[ITFLAG] [int] NULL,
[ITNAMEID] [int] NULL,
[ITNAME] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ITTBL] [int] NULL,
[ITTYPE] [int] NULL,
[UTYPE] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IQLT_ITEMS] ON [dbo].[INFOQLT] ([ITGRNMID], [ITRTNMID], [ITIDENT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IQLT_COMPONENTS] ON [dbo].[INFOQLT] ([ITIDENT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IQLT_GROUPS] ON [dbo].[INFOQLT] ([ITPRNMID], [ITRTNMID], [ITIDENT]) ON [PRIMARY]
GO