[dbo].[AMEPDEF]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	49
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

Heap

Row Count

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)
$Primary Key AMEPDEF_PK: EPID\DOMAINID$	DOMAINID	int	4
$Primary Key AMEPDEF_PK: EPID\DOMAINID$	EPID	int	4
	EPTITLE	varchar(127)	127
	EPAREA	int	4
	EPEVENT	int	4
	EPSEV	int	4
	EPSTATE	int	4
	EPFLAGS	int	4
	EPHISDAY	int	4
	EPID1	int	4
	EPID2	int	4
	EPID3	int	4
	EPID4	int	4
	EPJSUP	varchar(127)	127
	EPVFMT	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key AMEPDEF_PK: EPID\DOMAINID$

DOMAINID

int

$Primary Key AMEPDEF_PK: EPID\DOMAINID$

EPID

int

EPTITLE

varchar(127)

127

EPAREA

int

EPEVENT

int

EPSEV

int

EPSTATE

int

EPFLAGS

int

EPHISDAY

int

EPID1

int

EPID2

int

EPID3

int

EPID4

int

EPJSUP

varchar(127)

127

EPVFMT

int

	Name	Columns	Unique
$Primary Key AMEPDEF_PK: EPID\DOMAINID$	AMEPDEF_PK	EPID, DOMAINID

Name

Columns

Unique

$Primary Key AMEPDEF_PK: EPID\DOMAINID$

AMEPDEF_PK

EPID, DOMAINID

SQL Script

CREATE TABLE [dbo].[AMEPDEF]
(
[DOMAINID] [int] NOT NULL,
[EPID] [int] NOT NULL,
[EPTITLE] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPAREA] [int] NULL,
[EPEVENT] [int] NULL,
[EPSEV] [int] NULL,
[EPSTATE] [int] NULL,
[EPFLAGS] [int] NULL,
[EPHISDAY] [int] NULL,
[EPID1] [int] NULL,
[EPID2] [int] NULL,
[EPID3] [int] NULL,
[EPID4] [int] NULL,
[EPJSUP] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPVFMT] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AMEPDEF] ADD CONSTRAINT [AMEPDEF_PK] PRIMARY KEY NONCLUSTERED ([EPID], [DOMAINID]) ON [PRIMARY]
GO