origin_error

Logical Entity Name | origin_error
Default Table Name | origin_error
Definition | Error data on event location

origin_error Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
orid |  | 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
sxx |  | NUMERIC(7, 3) | YES | Elements of the covariance matrix for the location defined by orid. The covariance matrix is symmetric (and positive definite) so that sxy = syx, etc., (x, y, z, t) refer to latitude, longitude, depth and origin time, respectively. These attributes (together with sdobs, ndef and dattype) provide all the information necessary to construct the K-dimensional (K=2, 3, 4) confidence ellipse or ellipsoids at any confidence limit desired
syy |  | NUMERIC(7, 3) | YES | Elements of the covariance matrix for the location defined by orid. The covariance matrix is symmetric (and positive definite) so that sxy = syx, etc., (x, y, z, t) refer to latitude, longitude, depth and origin time, respectively. These attributes (together with sdobs, ndef and dattype) provide all the information necessary to construct the K-dimensional (K=2, 3, 4) confidence ellipse or ellipsoids at any confidence limit desired
szz |  | NUMERIC(7, 3) | YES | Elements of the covariance matrix for the location defined by orid. The covariance matrix is symmetric (and positive definite) so that sxy = syx, etc., (x, y, z, t) refer to latitude, longitude, depth and origin time, respectively. These attributes (together with sdobs, ndef and dattype) provide all the information necessary to construct the K-dimensional (K=2, 3, 4) confidence ellipse or ellipsoids at any confidence limit desired
stt |  | NUMERIC(7, 3) | YES | Elements of the covariance matrix for the location defined by orid. The covariance matrix is symmetric (and positive definite) so that sxy = syx, etc., (x, y, z, t) refer to latitude, longitude, depth and origin time, respectively. These attributes (together with sdobs, ndef and dattype) provide all the information necessary to construct the K-dimensional (K=2, 3, 4) confidence ellipse or ellipsoids at any confidence limit desired
sxy |  | NUMERIC(7, 3) | YES | Elements of the covariance matrix for the location defined by orid. The covariance matrix is symmetric (and positive definite) so that sxy = syx, etc., (x, y, z, t) refer to latitude, longitude, depth and origin time, respectively. These attributes (together with sdobs, ndef and dattype) provide all the information necessary to construct the K-dimensional (K=2, 3, 4) confidence ellipse or ellipsoids at any confidence limit desired
sxz |  | NUMERIC(7, 3) | YES | Elements of the covariance matrix for the location defined by orid. The covariance matrix is symmetric (and positive definite) so that sxy = syx, etc., (x, y, z, t) refer to latitude, longitude, depth and origin time, respectively. These attributes (together with sdobs, ndef and dattype) provide all the information necessary to construct the K-dimensional (K=2, 3, 4) confidence ellipse or ellipsoids at any confidence limit desired
syz |  | NUMERIC(7, 3) | YES | Elements of the covariance matrix for the location defined by orid. The covariance matrix is symmetric (and positive definite) so that sxy = syx, etc., (x, y, z, t) refer to latitude, longitude, depth and origin time, respectively. These attributes (together with sdobs, ndef and dattype) provide all the information necessary to construct the K-dimensional (K=2, 3, 4) confidence ellipse or ellipsoids at any confidence limit desired
stx |  | NUMERIC(7, 3) | YES | Elements of the covariance matrix for the location defined by orid. The covariance matrix is symmetric (and positive definite) so that sxy = syx, etc., (x, y, z, t) refer to latitude, longitude, depth and origin time, respectively. These attributes (together with sdobs, ndef and dattype) provide all the information necessary to construct the K-dimensional (K=2, 3, 4) confidence ellipse or ellipsoids at any confidence limit desired
sty |  | NUMERIC(7, 3) | YES | Elements of the covariance matrix for the location defined by orid. The covariance matrix is symmetric (and positive definite) so that sxy = syx, etc., (x, y, z, t) refer to latitude, longitude, depth and origin time, respectively. These attributes (together with sdobs, ndef and dattype) provide all the information necessary to construct the K-dimensional (K=2, 3, 4) confidence ellipse or ellipsoids at any confidence limit desired
stz |  | NUMERIC(7, 3) | YES | Elements of the covariance matrix for the location defined by orid. The covariance matrix is symmetric (and positive definite) so that sxy = syx, etc., (x, y, z, t) refer to latitude, longitude, depth and origin time, respectively. These attributes (together with sdobs, ndef and dattype) provide all the information necessary to construct the K-dimensional (K=2, 3, 4) confidence ellipse or ellipsoids at any confidence limit desired
azismall |  | NUMERIC(5, 2) | YES | Azimuth of smallest principal error
dipsmall |  | NUMERIC(4, 2) | YES | Dip of smallest principal error
magsmall |  | NUMERIC(7, 5) | YES | Magnitude of smallest principal error
aziinter |  | NUMERIC(5, 2) | YES | Azimuth of intermediate principal error
dipinter |  | NUMERIC(4, 2) | YES | Dip of intermediate principal error
maginter |  | NUMERIC(7, 5) | YES | Magnitude of intermediate principal error
azilarge |  | NUMERIC(5, 2) | YES | Azimuth of largest principal error
diplarge |  | NUMERIC(4, 2) | YES | Dip of largest principal error
maglarge |  | NUMERIC(7, 5) | YES | Magnitude of largest principal error
lddate |  | DATE | YES | Load date. Date and time that the record was created, in Oracle date datatype

origin_error Keys

Key Name | Key Type | Keys
orerrkey01 | PrimaryKey | orid

origin_error Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
origin | Identifying | One To Zero or More |  |  |  | orid | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

origin_error Check Constraints

Check Constraint Name | CheckConstraint
orig_error01 | aziinter >= 0.0 and aziinter <= 360.0
orig_error02 | azilarge >= 0.0 and azilarge <= 360.0
orig_error03 | azismall >= 0.0 and azismall <= 360.0
orig_error04 | dipinter >= -90.0 and dipinter <= 90.0
orig_error05 | diplarge >= -90.0 and diplarge <= 90.0
orig_error06 | dipsmall >= -90.0 and dipsmall <= 90.0
orig_error07 | maginter >= 0.0
orig_error08 | maglarge >= 0.0
orig_error09 | magsmall >= 0.0
orig_error10 | stx > 0.0
orig_error11 | sty > 0.0
orig_error12 | stz > 0.0
orig_error13 | sxx > 0.0
orig_error14 | sxy > 0.0
orig_error15 | sxz > 0.0
orig_error16 | syy > 0.0
orig_error17 | syz > 0.0
orig_error18 | stt > 0.0
orig_error19 | szz > 0.0