arrival

Logical Entity Name | arrival
Default Table Name | arrival
Definition | Summary information on a seismic arrival

arrival Columns

ColumnName | Domain | Datatype | NULL | Definition
arid |  | NUMBER(15, 0) | NO | Arrival identifier. Each arrival is assigned a unique positive integer identifying it. This number is used in the AssocArO relation along with the origin identifier to link Arrival and 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
datetime |  | NUMBER(25, 10) | NO | The date of associated with information in the record, in true epoch format
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | YES | Unique network identifier. This character string is the name of a seismic network
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. Contains hypoinverse station card column 109 for historic catalogs
channel |  | VARCHAR2(8) | YES | Channel name
channelsrc |  | VARCHAR2(8) | YES | Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)
seedchan |  | VARCHAR2(3) | YES | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code
location |  | VARCHAR2(2) | YES | Describes the individual sites on an array station, operated by the same network operator
iphase |  | VARCHAR2(8) | YES | Reported phase. This eight-character field holds the name initially given to a seismic phase. Standard seismological labels for the types of signals (or phases) are used (e.g., P, PKP, PcP, pP). Both upper and lower case letters are available and should be used when appropriate, for example, pP or PcP
qual |  | VARCHAR2(1) | YES | Onset quality. This single-character flag is used to denote the sharpness of the onset of a seismic phase. This attribute does not denote the timing accuracy
clockqual |  | VARCHAR2(1) | YES | This field describes whether the clock quality associated with a particular arrival is known, and if so, is good or bad
clockcorr |  | NUMBER(15, 0) | YES | This field indicates the amount of time to add to the arrival time if clock correction is known
ccset |  | VARCHAR2(1) | YES | This field describes whether the clock correction has been added or applied to the arrivals in computing a hypocenter solution
fm |  | VARCHAR2(2) | YES | First motion. This is a two-character indication of first motion. The first character describes first motion seen on short-period channels and the second holds for long-period instruments. Compression (dilation) on a short-period sensor is denoted by c(d) and compression (dilation) on a long-period sensor is denoted by u(r). Empty character positions will be indicated by dots (e.g., ".r"). Lower quality first motions can be described by +(-)
ema |  | NUMBER(5, 2) | YES | Emergence angle. This attribute is the emergence angle of an arrival, as observed at a three-component station or array. The value increases from the vertical direction towards the horizontal
azimuth |  | NUMBER(4, 1) | YES | Station to event azimuth measured clockwise from true north. Identified from waveform analysis
slow |  | NUMBER(8, 4) | YES | Observed slowness. This is the observed slowness of a wave as it sweeps across an array
deltim |  | NUMBER(5, 2) | YES | Arrival time uncertainty. This attribute gives the standard deviation of a detection time
delinc |  | NUMBER(4, 2) | YES | Uncertainty in the angle. This attribute gives the standard deviation of the angle of emergence
delaz |  | NUMBER(5, 2) | YES | Uncertainty in the azimuth. This attribute gives the standard deviation of the azimuth of a signal
delslo |  | NUMBER(8, 4) | YES | Uncertainty in slowness. This attribute gives the standard deviation of the slowness of a signal
quality |  | NUMBER(3, 2) | YES | This attribute denotes the quality of an origin, an arrival, or a mechanism. 1.0 = good, 0.0 = bad. Hypoinverse station archive card columns 17 & 50: 0, 5 --> 1.00 1, 6 --> 0.75 2, 7 --> 0.50 3, 8 --> 0.25 4, 9 --> 0.00
snr |  | BINARY_DOUBLE | YES | Signal-to-noise ratio. This is an estimate of the signal relative to that of the noise immediately preceding it
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, in Oracle date datatype

arrival Primary and Unique Keys

Key Name | Key Type | Keys
arkey01 | PrimaryKey | arid

arrival Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred
assocaro | Identifying | One To Zero or More | Aao_Arr |  |  |  | NO | NO | NO

arrival Check Constraints

Check Constraint Name | CheckConstraint
arrival01 | arid > 0
arrival02 | azimuth >= 0.0 and azimuth <= 360.0
arrival03 | delaz > 0.0
arrival04 | delinc >= 0.0
arrival05 | delslo > 0.0
arrival06 | deltim >= 0.0
arrival07 | ema >= 0.0 and ema <= 90.0
arrival08 | fm in ('cu','cr','c.','du','dr','d.','.u','.r','..','+u','+r','+.','-u','-r','-.')
arrival09 | qual in ('i','e','w','I','E','W')
arrival10 | slow >= 0.0
arrival11 | snr > 0.0
arrival12 | quality >= 0.0 and quality <= 1.0
arrival13 | ccset < 1
arrival14 | rflag in ('a','h','f','A','H','F')