SchemaSpy - Table ESEC.ESECDBA.EVT_PORT_SMRY_1

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

DEST_PORT

varchar2

96

SEV

number

22

CUST_ID

number

22

CUST.CUST_ID

Implied Constraint

EVT_TIME

date

7

EVT_CNT

number

22

√

null

DATE_CREATED

date

7

√

null

DATE_MODIFIED

date

7

√

null

CREATED_BY

number

22

√

null

MODIFIED_BY

number

22

√

null

Table contained 0 rows at Tue May 04 17:09 EDT 2010

Indexes:

Column(s)	Type	Sort	Constraint Name
EVT_TIME + DEST_PORT + SEV + CUST_ID	Must be unique	Asc/Asc/Asc/Asc	EVT_PORT_SMRY_1_UK1