eventtype Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
etype		VARCHAR(2)	NO	This attribute is used to identify the type of seismic event
name		VARCHAR(16)	NO	Name associated with an event type
description		VARCHAR(80)	YES	Event type description
qmltype		VARCHAR(80)	YES	QuakeMl event type

eventtype Keys

Key Name	Key Type	Keys
EVENTTYPEKEY01	PrimaryKey	etype

eventtype Relationships

Parent Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
assoctypecat	Non-Identifying	One To Zero or More					NO
event	Non-Identifying	One To Zero or More					NO

eventtype Check Constraints

Check Constraint Name	CheckConstraint
EVENTTYPE02	etype IN ('eq','lp','se','to','tr','vt','nt','qb','ce','ex','sh','sn','th','av','co','df','ls','rb','rs','ve','bc','mi','pc','ot','st','uk','lf','su','px'','ne','nr','ae','cl','cc','ax','cx','ee','de','me','rc','bl','ie','rl','fi','fe','cr','tc','oc','oe','pe','sb','an','al','he','iq','sl')