[dbo].[INFOMEMO]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
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

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)
$Primary Key INFOMEMO_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$ $Cluster Key INFOMEMO_SK5: UNITID\ITPRID\DOMAINID$	DOMAINID	int	4
$Primary Key INFOMEMO_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$ $Cluster Key INFOMEMO_SK5: UNITID\ITPRID\DOMAINID$	UNITID	int	4
$Primary Key INFOMEMO_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$ $Cluster Key INFOMEMO_SK5: UNITID\ITPRID\DOMAINID$	ITPRID	int	4
$Primary Key INFOMEMO_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	ITNAMEID	int	4
$Indexes INFOMEMO_SK1: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFOMEMO_SK2: ITROOTID\ITPRNMID\ITDATE$	ITROOTID	int	4
$Indexes INFOMEMO_SK1: ITPRNMID\ITROOTID\ITRTNMID$	ITRTNMID	int	4
$Indexes INFOMEMO_SK1: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFOMEMO_SK2: ITROOTID\ITPRNMID\ITDATE$	ITPRNMID	int	4
	ITIDX	int	4
	ITTYPE	int	4
	ITVAL	text	max
$Indexes INFOMEMO_SK2: ITROOTID\ITPRNMID\ITDATE$	ITDATE	int	4
	ITLOCK	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key INFOMEMO_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$ $Cluster Key INFOMEMO_SK5: UNITID\ITPRID\DOMAINID$

DOMAINID

int

$Primary Key INFOMEMO_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$ $Cluster Key INFOMEMO_SK5: UNITID\ITPRID\DOMAINID$

UNITID

int

$Primary Key INFOMEMO_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$ $Cluster Key INFOMEMO_SK5: UNITID\ITPRID\DOMAINID$

ITPRID

int

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

ITNAMEID

int

$Indexes INFOMEMO_SK1: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFOMEMO_SK2: ITROOTID\ITPRNMID\ITDATE$

ITROOTID

int

$Indexes INFOMEMO_SK1: ITPRNMID\ITROOTID\ITRTNMID$

ITRTNMID

int

$Indexes INFOMEMO_SK1: ITPRNMID\ITROOTID\ITRTNMID$ $Indexes INFOMEMO_SK2: ITROOTID\ITPRNMID\ITDATE$

ITPRNMID

int

ITIDX

int

ITTYPE

int

ITVAL

text

max

$Indexes INFOMEMO_SK2: ITROOTID\ITPRNMID\ITDATE$

ITDATE

int

ITLOCK

int

	Name	Columns
$Primary Key INFOMEMO_PK: UNITID\ITPRID\ITNAMEID\DOMAINID$	INFOMEMO_PK	UNITID, ITPRID, ITNAMEID, DOMAINID
	INFOMEMO_SK1	ITPRNMID, ITROOTID, ITRTNMID
	INFOMEMO_SK2	ITROOTID, ITPRNMID, ITDATE
$Cluster Key INFOMEMO_SK5: UNITID\ITPRID\DOMAINID$	INFOMEMO_SK5	UNITID, ITPRID, DOMAINID

Name

Columns

Unique

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

INFOMEMO_PK

UNITID, ITPRID, ITNAMEID, DOMAINID

INFOMEMO_SK1

ITPRNMID, ITROOTID, ITRTNMID

INFOMEMO_SK2

ITROOTID, ITPRNMID, ITDATE

$Cluster Key INFOMEMO_SK5: UNITID\ITPRID\DOMAINID$

INFOMEMO_SK5

UNITID, ITPRID, DOMAINID

SQL Script

CREATE TABLE [dbo].[INFOMEMO]
(
[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] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ITDATE] [int] NULL,
[ITLOCK] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[INFOMEMO] ADD CONSTRAINT [INFOMEMO_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [ITPRID], [ITNAMEID], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOMEMO_SK1] ON [dbo].[INFOMEMO] ([ITPRNMID], [ITROOTID], [ITRTNMID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INFOMEMO_SK2] ON [dbo].[INFOMEMO] ([ITROOTID], [ITPRNMID], [ITDATE]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [INFOMEMO_SK5] ON [dbo].[INFOMEMO] ([UNITID], [ITPRID], [DOMAINID]) ON [PRIMARY]
GO