eventtype Columns

ColumnName	Domain	Datatype	NULL	Definition
etype		VARCHAR2(2)	NO	This attribute is used to identify the type of seismic event
name		VARCHAR2(16)	NO	Name associated with an event type
description		VARCHAR2(80)	YES	Event type description

eventtype Primary and Unique Keys

Key Name	Key Type	Keys
EVENTTYPEKEY01	PrimaryKey	etype

eventtype Foreign Keys

Parent Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Deferrable

Initially Deferred

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype	Deferrable	Initially Deferred
assoctypecat	Non-Identifying	One To Zero or More					NO	NO	NO
event	Non-Identifying	One To Zero or More					NO	NO	NO

eventtype Check Constraints

Check Constraint Name	CheckConstraint
EVENTTYPE02	etype IN\line ('le','re','ts','lp','se','to','tr','vt','nt','qb','ce','ex','sh','sn','th',\line 'av','co','df','ls','rb','rs','ve','bc','mi','pc','ot','st','uk','lf','su','px')