[dbo].[AMEPHIS]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	3074
Created	3:44:34 PM Friday, June 13, 2003
Last Modified	3:44:34 PM Friday, June 13, 2003

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

3074

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Key AMEPHIS_SK1: EPID\DOMAINID$	DOMAINID	int	4
$Cluster Key AMEPHIS_SK1: EPID\DOMAINID$	EPID	int	4
	EPAREA	int	4
	EPEVENT	int	4
	HDATE	int	4
	HPRI	varchar(100)	100
	HPRITYPE	int	4
	HPRIDID	int	4
	HPRIID	int	4
	HSEC	varchar(100)	100
	HSECTYPE	int	4
	HSECDID	int	4
	HSECID	int	4
	HTER	varchar(100)	100
	HTERTYPE	int	4
	HTERDID	int	4
	HTERID	int	4
	HUSER	varchar(100)	100
$Indexes AMEPHIS_SK2: HUSERID\HUSERDID$	HUSERDID	int	4
$Indexes AMEPHIS_SK2: HUSERID\HUSERDID$	HUSERID	int	4
	HOLD	varchar(100)	100
	HNEW	varchar(50)	50
	EPVFMT	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Key AMEPHIS_SK1: EPID\DOMAINID$

DOMAINID

int

$Cluster Key AMEPHIS_SK1: EPID\DOMAINID$

EPID

int

EPAREA

int

EPEVENT

int

HDATE

int

HPRI

varchar(100)

100

HPRITYPE

int

HPRIDID

int

HPRIID

int

HSEC

varchar(100)

100

HSECTYPE

int

HSECDID

int

HSECID

int

HTER

varchar(100)

100

HTERTYPE

int

HTERDID

int

HTERID

int

HUSER

varchar(100)

100

$Indexes AMEPHIS_SK2: HUSERID\HUSERDID$

HUSERDID

int

$Indexes AMEPHIS_SK2: HUSERID\HUSERDID$

HUSERID

int

HOLD

varchar(100)

100

HNEW

varchar(50)

EPVFMT

int

	Name	Columns
$Cluster Key AMEPHIS_SK1: EPID\DOMAINID$	AMEPHIS_SK1	EPID, DOMAINID
	AMEPHIS_SK2	HUSERID, HUSERDID

Name

Columns

$Cluster Key AMEPHIS_SK1: EPID\DOMAINID$

AMEPHIS_SK1

EPID, DOMAINID

AMEPHIS_SK2

HUSERID, HUSERDID

SQL Script

CREATE TABLE [dbo].[AMEPHIS]
(
[DOMAINID] [int] NULL,
[EPID] [int] NULL,
[EPAREA] [int] NULL,
[EPEVENT] [int] NULL,
[HDATE] [int] NULL,
[HPRI] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HPRITYPE] [int] NULL,
[HPRIDID] [int] NULL,
[HPRIID] [int] NULL,
[HSEC] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HSECTYPE] [int] NULL,
[HSECDID] [int] NULL,
[HSECID] [int] NULL,
[HTER] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HTERTYPE] [int] NULL,
[HTERDID] [int] NULL,
[HTERID] [int] NULL,
[HUSER] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HUSERDID] [int] NULL,
[HUSERID] [int] NULL,
[HOLD] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HNEW] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPVFMT] [int] NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [AMEPHIS_SK1] ON [dbo].[AMEPHIS] ([EPID], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [AMEPHIS_SK2] ON [dbo].[AMEPHIS] ([HUSERID], [HUSERDID]) ON [PRIMARY]
GO