| magtype |
| Base Entity | eventprefmag |
| Attribute Name | magtype |
| Logical Rolename | |
| ColumnName | magtype |
| RoleName | |
| Definition | Magnitude type. This character string is used to specify the type of the magnitude measure |
| Note | Range: magtype = {p | a | b | e | l | l1 | l2 | lg | c | s | w | z | B | un | d | h | n | dl}
p = initial P-wave amplitude magnitude
a = primary amplitude magnitude (Jerry Eaton's XMAG)
b = body-wave magnitude
e = energy magnitude
l = local magnitude
l1 = traditional UCB local magnitude
l2 = network UCB local magnitude
lg = Lg magnitude
c = primary coda magnitude
s = Ms - surface wave magnitude
w = moment magnitude
z = low gain (Z component) magnitude of Hirshorn and Lindh (1989)
B = magnitude estimated from 14-kg Benioff's
un = unknown magnitude type
d = duration magnitude
h = human assigned magnitude
n = no magnitude
dl = low-gain initial P-wave amplitude magnitude |
| evid |
| Base Entity | eventprefmag |
| Attribute Name | evid |
| Logical Rolename | |
| ColumnName | evid |
| RoleName | |
| Definition | 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 |
| Note | Range: evid > 0 |
| magid |
| Base Entity | eventprefmag |
| Attribute Name | magid |
| Logical Rolename | |
| ColumnName | magid |
| RoleName | |
| Definition | Magnitude identifier. This key is used to identify a magnitude in the Netmag relation. It is required for every magnitude |
| Note | Range: magid > 0 |
| lddate |
| Base Entity | eventprefmag |
| Attribute Name | lddate |
| Logical Rolename | |
| ColumnName | lddate |
| RoleName | |
| Definition | Load date. Date and time that the record was created, in Oracle date datatype |
| Note | Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS |