eventtype

Logical Entity Name | eventtype
Default Table Name | eventtype
Definition | Summary information on event types

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
qmltype |  | VARCHAR2(80) | YES | QuakeMl event type

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 | YES

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')