origin 
Logical Entity Name  origin 
Default Table Name  origin 
Definition  Data on event location 

origin Columns 
ColumnName  Domain  Datatype  NULL  Definition 
orid(PK)    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 
evid(FK)    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 
prefmag(FK)    NUMBER(15, 0)  YES  Preferred magnitude. This attribute holds the magnitude identifier, magid, that points to the preferred magnitude for a seismic event or an origin 
prefmec(FK)    NUMBER(15, 0)  YES  Preferred mechanism. This attribute holds the mechanism identifier, mecid, that points to the preferred mechanism for a seismic event or an origin 
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 
bogusflag    NUMBER(1, 0)  YES  This field describes whether an origin is bogus or not 
datetime    NUMBER(25, 10)  NO  The date of associated with information in the record, in true epoch format 
lat    NUMBER(9, 7)  NO  Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes 
lon    NUMBER(10, 7)  NO  Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian 
depth    NUMBER(7, 3)  YES  Source depth. This attribute gives the depth of the event origin. The reference depth of 0 is usually defined as the average elevation of stations used to determine the origin, although other data may be specified. Positive values are down, negative values are up from the reference point 
type    VARCHAR2(2)  YES  Type of location 
algorithm    VARCHAR2(15)  YES  Algorithm used. This is a brief textual description of the algorithm used to compute a seismic origin 
algo_assoc    VARCHAR2(80)  YES  Association algorithm used. This is a textual description of the algorithm used for associating the data 
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 
datumhor    VARCHAR2(8)  YES  Datum type for horizontal (latitude and longitude) coordinates 
datumver    VARCHAR2(8)  YES  Datum type for depth or elevation 
gap    NUMBER(4, 1)  YES  Gap in azimuthal coverage 
distance    NUMBER(7, 3)  YES  Distance from the origin to the nearest station 
wrms    NUMBER(5, 3)  YES  This attribute denotes the weighted RMS 
stime    NUMBER(6, 3)  YES  Origin time error. This attribute denotes the standard deviation of the origin time 
erhor    NUMBER(7, 3)  YES  Horizontal error. This attribute denotes the location uncertainty that accompanies the location 
sdep    NUMBER(7, 3)  YES  Depth error. This is the standard deviation of the depth estimate 
erlat    NUMBER(7, 3)  YES  Error in latitude. This is the standard deviation of the latitude estimate 
erlon    NUMBER(7, 3)  YES  Error in longitude. This is the standard deviation of the longitude estimate 
totalarr    NUMBER(5, 0)  YES  Total number of phases in the database for the specified orid. This field signifies the number of P and S arrivals with non-zero input weights 
totalamp    NUMBER(6, 0)  YES  Total number of amplitudes in the database for the specified orid. Not all amplitudes have to associated with all magnitudes or origins 
ndef    NUMBER(5, 0)  YES  This attribute denotes the number of phases with non-zero output weights used in hypocenter calculation 
nbs    NUMBER(4, 0)  YES  Number of S phase readings with non-zero output weights 
nbfm    NUMBER(4, 0)  YES  Number of P first motions with non-zero input weights 
locevid    VARCHAR2(12)  YES  Local event identifier. This attribute describes the original event identifier of the event. In combination with auth and subsource, it can be used to uniquely identify the original event identifier from that source. For example, waveforms from the original source may be associated with this identifier 
quality    NUMBER(2, 1)  YES  This attribute denotes the quality of an origin, an arrival, or a mechanism. 1.0 = good, 0.0 = bad 
fdepth    VARCHAR2(1)  YES  This attribute indicates if the depth was fixed or not to compute the solution 
fepi    VARCHAR2(1)  YES  This attribute indicates if the epicenter was fixed or not to compute the solution 
ftime    VARCHAR2(1)  YES  This attribute indicates if the origin time was fixed or not to compute the solution 
vmodelid    VARCHAR2(2)  YES  Velocity model identification 
cmodelid    VARCHAR2(2)  YES  Velocity model domain 
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 

origin Primary and Unique Keys 
Key Name  Key Type  Keys 
orkey01  PrimaryKey  orid 

origin Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
event  Non-Identifying  One To Zero or More  Ori_Eve      evid  NO  NO 
mec  Non-Identifying  Zero or One to Zero or More  Ori_Mec      prefmec  NO  NO 
netmag  Non-Identifying  Zero or One to Zero or More  Ori_Net      prefmag  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
assocaro  Identifying  One To Zero or More  Aao_Ori        NO  NO 
assoccoo  Identifying  One To Zero or More  Aco_Ori        NO  NO 
assocamo  Identifying  One To Zero or More  Amo_Ori        NO  NO 
event  Non-Identifying  One To Zero or More  Eve_Ori        NO  NO 
mec  Non-Identifying  One To Zero or More  Mec_Ori        NO  NO 
mec  Non-Identifying  One To Zero or More  Mec_Ori2        NO  NO 
netmag  Non-Identifying  One To Zero or More  Net_Ori        NO  NO 
origin_error  Identifying  One To Zero or More  Ori__Err_Ori        NO  NO 

origin Check Constraints 
Check Constraint Name  CheckConstraint 
origin02  datumhor in ('NAD27','WGS84') 
origin03  datumver in ('NAD27','WGS84','AVERAGE') 
origin04  depth >= -10.0 and depth <= 1000.0 
origin05  distance >= 0.0 
origin06  erhor >= 0.0 
origin07  erlat >= 0.0 
origin08  erlon >= 0.0 
origin09  fdepth in ('y','n') 
origin10  fepi in ('y','n') 
origin11  ftime in ('y','n') 
origin12  gap >= 0.0 and gap <= 360.0 
origin15  nbfm >= 0 
origin16  nbs >= 0 
origin17  ndef >= 0 
origin18  orid > 0 
origin19  quality >= 0.0 and quality <= 1.0 
origin20  type in ('H','HO','HR','HI','GO','C','A') 
origin21  stime >= 0.0 
origin23  wrms >= 0.0 
origin24  sdep >=0.0 
origin25  totalarr >=0 
origin26  totalamp >= 0 
origin28  rflag in ('a','h','f','A','H','F')