netmag 
Logical Entity Name  netmag 
Default Table Name  netmag 
Definition  Summary information on a magnitude 

netmag Columns 
ColumnName  Domain  Datatype  NULL  Definition 
magid(PK)    NUMBER(15, 0)  NO  Magnitude identifier. This key is used to identify a magnitude in the Netmag relation. It is required for every magnitude 
orid(FK)    NUMBER(15, 0)  NO  Origin identification. Each origin is assigned a unique positive integer which identifies it in the database. The orid is used to identify one of the many hypotheses of the actual location of the event 
commid    NUMBER(15, 0)  YES  Comment identification. This is a key used to point to free-form comments entered in the Remark relation. These comments store additional information about a tuple in another relation. Within the Remark relation, there may be many tuples with the same commid and different lineno, but the same commid will appear in only one other tuple among the rest of the relations in the database 
magnitude    NUMBER(5, 2)  NO  Magnitude. This gives the magnitude value of the type indicated by magtype 
magtype    VARCHAR2(6)  NO  Magnitude type. This character string is used to specify the type of the magnitude measure 
auth    VARCHAR2(15)  NO  The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record 
subsource    VARCHAR2(8)  YES  A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE 
magalgo    VARCHAR2(15)  YES  This attribute represents the algorithm used to compute the magnitude 
nsta    NUMBER(5, 0)  YES  This quantity is the number of observations with non-zero input weights used to compute the magnitude or mechanism 
uncertainty    NUMBER(5, 3)  YES  Magnitude uncertainty. This is the standard deviation of the accompanying magnitude measurement 
gap    NUMBER(4, 1)  YES  Gap in azimuthal coverage 
distance    NUMBER(7, 3)  YES  Distance from the origin to the nearest station 
quality    NUMBER(2, 1)  YES  This attribute denotes the quality of an origin, an arrival, or a mechanism. 1.0 = good, 0.0 = bad 
rflag    VARCHAR2(2)  YES  This flag describes whether an observation was generated automatically, by a human, or has been finalized 
lddate    DATE  YES  Load date. Date and time that the record was created or last modified, in Oracle date datatype 

netmag Primary and Unique Keys 
Key Name  Key Type  Keys 
magkey01  PrimaryKey  magid 

netmag Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
origin  Non-Identifying  One To Zero or More  Net_Ori      orid  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
assocamm  Identifying  One To Zero or More  Aam_Net        NO  NO 
assoccom  Identifying  One To Zero or More  Aom_Net        NO  NO 
eventprefmag  Non-Identifying  One To Zero or More  Epm_Net        NO  NO 
event  Non-Identifying  One To Zero or More  Eve_Net        NO  NO 
mec  Non-Identifying  One To Zero or More  Mec_Net        NO  NO 
origin  Non-Identifying  One To Zero or More  Ori_Net        NO  NO 

netmag Check Constraints 
Check Constraint Name  CheckConstraint 
netmag05  quality >= 0.0 and quality <= 1.0 
netmag06  magid > 0 
netmag07  rflag in ('a','h','f','A','H','F') 
netmag01  magnitude >= -10.0 and magnitude <= 10.0 
netmag02  magtype in ('p', 'a','b','e','l','l1','l2','lg','c','s','w','z','B','un','d','h','n') 
netmag03  nsta >= 0 
netmag04  uncertainty >= 0.0