EVNT

608 rows


Description

General information for earthquake events

Columns

Column Type Size Nulls Auto Default Children Parents Comments
EVNT_ID INT UNSIGNED 10 √ null
FLDO.EVNT_ID FLDO_ibfk_1C
IM.EVNT_ID IM_ibfk_1C
SEGM.EVNT_ID SEGM_ibfk_1C

Unique ID (primary key) for entries in the EVNT table
EVNT_EQID INT UNSIGNED 10 √ null

Unique ID reported in NGA databases
EVNT_NM VARCHAR 250 √ null

Earthquake Name
EVNT_YR INT 10 √ null

Earthquake Year
EVNT_MD INT 10 √ null

Earthquake Month and Date
EVNT_HM INT 10 √ null

Earthquake Hour and Minutes
HYPO_LAT DOUBLE 22 √ null

Hypocenter Latitude (deg)
HYPO_LON DOUBLE 22 √ null

Hypocenter Longitude (deg)
HYPO_DT FLOAT 12 √ null

Hypocenter Depth (km)
EVNT_MAG FLOAT 12 √ null

Earthquake Magnitude
MAG_TY VARCHAR 30 √ null

Magnitude Type
MAG_UNCK FLOAT 12 √ null

Magnitude Uncertainty: Kagan Model
MAG_UNCST FLOAT 12 √ null

Magnitude Uncertainty: Statistical
EVNT_MO FLOAT 12 √ null

Seismic Moment Mo (dyne.cm)
EVNT_MECH TINYINT 3 √ null

Mechanism Based on Rake Angle (5=unkwnown)
EVNT_RUP TINYINT 3 √ null

Coseismic Surface Rupture: 1=Yes; 0=No; 3=Unknown
EVNT_FFMOD TINYINT 3 √ null

Finite Rupture Model: 1=Yes; 0=No
EVNT_STRIKE FLOAT 12 √ null

Average Strike (deg)
EVNT_RAKE FLOAT 12 √ null

Average Rake (deg)
EVNT_DIP FLOAT 12 √ null

Average Dip (deg)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc EVNT_ID

Relationships

Close relationships within degrees of separation