significant_event Columns

ColumnName	Domain	Datatype	NULL	Definition
evid		NUMBER(15, 0)	NO	Event identifier. Each event is assigned a unique integer which identifies it in a database. It is possible for several records in the Origin relation to have the same evid. This indicates there are several opinions about the location of the event. The evid does not have to be identical to the local network’s event identifier, which is stored in the Origin table. This allows merging data for a single event from multiple sources without insisting that database evid is identical to the source’s local event identifier
evname		VARCHAR2(80)	YES	Event name. This is a descriptive name for major events
remarks		VARCHAR2(2)	YES	This attribute is used to give some information about the event, such as felt or damage
nfelt		NUMBER(8, 0)	YES	Number of felt reports
mmi		NUMBER(2, 0)	YES	Reported or inferred Mercali intensity for event
pga		NUMBER(6, 4)	YES	Peak ground acceleration recorded by any station for the event. Represented in g, where 1.0 = 1g
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

significant_event Primary and Unique Keys

Key Name	Key Type	Keys
sigevkey01	PrimaryKey	evid

significant_event Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable
event	Identifying	One To Zero or More	Sig_Eve_Eve			evid	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

significant_event Check Constraints

Check Constraint Name	CheckConstraint
seg_event01	mmi >= 1 and mmi <= 12
seg_event02	nfelt > 0
seg_event03	pga > 0.0
seg_event04	remarks in ('f','d','fd','df')