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

netmag Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
magid(PK)    NUMERIC(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)    NUMERIC(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    NUMERIC(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    NUMERIC(5, 2)  NO  Magnitude. This gives the magnitude value of the type indicated by magtype 
magtype    VARCHAR(6)  NO  Magnitude type. This character string is used to specify the type of the magnitude measure 
auth    VARCHAR(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    VARCHAR(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    VARCHAR(15)  YES  This attribute represents the algorithm used to compute the magnitude 
nsta    NUMERIC(5, 0)  YES  This quantity is the number of stations with non-zero input weights used to compute the magnitude 
nobs    NUMERIC(5, 0)  YES  This quantity is the number of observations with non-zero input weights used to compute the magnitude 
uncertainty    NUMERIC(5, 3)  YES  Magnitude uncertainty. Median of the absolute values of the channel magnitude residual deviations from the channel magnitude's median, the summary magnitude. 
gap    NUMERIC(4, 1)  YES  Gap in azimuthal coverage 
distance    NUMERIC(7, 3)  YES  Distance from the origin to the nearest station 
quality    NUMERIC(2, 1)  YES  This attribute denotes the quality of an origin, an arrival, or a mechanism. 1.0 = good, 0.0 = bad 
rflag    VARCHAR(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, in Oracle date datatype 

netmag Keys 
Key Name  Key Type  Keys 
magkey01  PrimaryKey  magid 

netmag Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
origin  Non-Identifying  One To Zero or More        orid  NO 
remark  Non-Specific            NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
assocamm  Identifying  One To Zero or More          NO 
assoccom  Identifying  One To Zero or More          NO 
eventprefmag  Non-Identifying  One To Zero or More          NO 
event  Non-Identifying  One To Zero or More          NO 
mec  Non-Identifying  One To Zero or More          NO 
origin  Non-Identifying  One To Zero or More          NO 

netmag Check Constraints 
Check Constraint Name  CheckConstraint 
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','dl') 
netmag03  nsta >= 0 
netmag04  uncertainty >= 0.0 
netmag05  quality >= 0.0 and quality <= 1.0 
netmag06  magid > 0 
netmag07  rflag in ('a','h','f','A','H','F') 
netmag08  nobs >= 0