eventprefmag

Logical Entity Name | eventprefmag
Default Table Name | eventprefmag
Definition | Summary information on preferred magnitudes for an event

eventprefmag Columns

ColumnName | Domain | Datatype | NULL | Definition
type |  | VARCHAR2(6) | NO | Magnitude type. This character string is used to specify the type of the magnitude measure
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
magid |  | NUMBER(15, 0) | NO | Magnitude identifier. This key is used to identify a magnitude in the Netmag relation. It is required for every magnitude
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

eventprefmag Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
event | eventprefmag | Non-Identifying | evid
netmag | eventprefmag | Non-Identifying | magid

eventprefmag Check Constraints

Check Constraint Name | CheckConstraint
EventPrefMag_CHKTYP | type in ('a','b','e','l','l1','l2','lg','c','s','w','z','B', 'un','d','h','n')