arrival Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
arid		NUMERIC(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		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
datetime		NUMERIC(25, 10)	NO	The date of associated with information in the record, in true epoch format
sta		VARCHAR(6)	NO	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net		VARCHAR(8)	YES	Unique network identifier. This character string is the name of a seismic network
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. Contains hypoinverse station card column 109 for historic catalogs
channel		VARCHAR(8)	YES	Channel name
channelsrc		VARCHAR(8)	YES	Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)
seedchan		VARCHAR(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		VARCHAR(2)	YES	Describes the individual sites on an array station, operated by the same network operator
iphase		VARCHAR(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		VARCHAR(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		VARCHAR(1)	YES	This field describes whether the clock quality associated with a particular arrival is known, and if so, is good or bad
clockcorr		NUMERIC(15, 0)	YES	This field indicates the amount of time to add to the arrival time if clock correction is known
ccset		VARCHAR(1)	YES	This field describes whether the clock correction has been added or applied to the arrivals in computing a hypocenter solution
fm		VARCHAR(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		NUMERIC(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		NUMERIC(4, 1)	YES	Station to event azimuth measured clockwise from true north. Identified from waveform analysis
slow		NUMERIC(8, 4)	YES	Observed slowness. This is the observed slowness of a wave as it sweeps across an array
deltim		NUMERIC(5, 2)	YES	Arrival time uncertainty. This attribute gives the standard deviation of a detection time
delinc		NUMERIC(4, 2)	YES	Uncertainty in the angle. This attribute gives the standard deviation of the angle of emergence
delaz		NUMERIC(5, 2)	YES	Uncertainty in the azimuth. This attribute gives the standard deviation of the azimuth of a signal
delslo		NUMERIC(8, 4)	YES	Uncertainty in slowness. This attribute gives the standard deviation of the slowness of a signal
quality		NUMERIC(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		DOUBLE PRECISION	YES	Signal-to-noise ratio. This is an estimate of the signal relative to that of the noise immediately preceding it
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

arrival Keys

Key Name	Key Type	Keys
arkey01	PrimaryKey	arid

arrival Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
remark	Non-Specific						NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
assocaro	Identifying	One To Zero or More					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')