mec

Logical Entity Name | mec
Default Table Name | mec
Definition | Summary information on a moment tensor

mec Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
mecid |  | NUMERIC(15, 0) | NO | Mechanism identification. Each mechanism is assigned a unique positive integer which identifies it in the database
oridin |  | NUMERIC(15, 0) | YES | Input origin. This attribute holds the origin identifier, orid, that points to the origin from which the mechanism was computed
oridout |  | NUMERIC(15, 0) | YES | Output origin. This attribute holds the origin identifier, orid, that points to the origin computed from the mechanism
magid |  | NUMERIC(15, 0) | YES | Magnitude identifier. This key is used to identify a magnitude in the Netmag relation. It is required for every magnitude
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
mechtype |  | VARCHAR(2) | YES | Mechanism/moment type
mecalgo |  | VARCHAR(15) | YES | This attribute represents the algorithm used to compute the mechanism
scalar |  | DOUBLE PRECISION | YES | Seismic scalar moment
erscalar |  | DOUBLE PRECISION | YES | Error in scalar moment. This is the standard deviation of the scalar moment
tft |  | VARCHAR(8) | YES | Type of source time function
tfd |  | DOUBLE PRECISION | YES | Duration of the source time function
mxx |  | DOUBLE PRECISION | YES | Moment tensor elements
myy |  | DOUBLE PRECISION | YES | Moment tensor elements
mzz |  | DOUBLE PRECISION | YES | Moment tensor elements
mxy |  | DOUBLE PRECISION | YES | Moment tensor elements
mxz |  | DOUBLE PRECISION | YES | Moment tensor elements
myz |  | DOUBLE PRECISION | YES | Moment tensor elements
smxx |  | DOUBLE PRECISION | YES | Uncertainties in moment tensor elements
smyy |  | DOUBLE PRECISION | YES | Uncertainties in moment tensor elements
smzz |  | DOUBLE PRECISION | YES | Uncertainties in moment tensor elements
smxy |  | DOUBLE PRECISION | YES | Uncertainties in moment tensor elements
smxz |  | DOUBLE PRECISION | YES | Uncertainties in moment tensor elements
smyz |  | DOUBLE PRECISION | YES | Uncertainties in moment tensor elements
srcduration |  | NUMERIC(6, 3) | YES | Source half-duration
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 a unique source within the domain specified by auth
strike1 |  | NUMERIC(3, 0) | YES | Strike of fault plane 1 from the best double couple
dip1 |  | NUMERIC(3, 0) | YES | Dip of fault plane 1 from the best double couple
rake1 |  | NUMERIC(4, 0) | YES | Rake of fault plane 1 from the best double couple solution
strike2 |  | NUMERIC(3, 0) | YES | Strike of fault plane 2 from the best double couple
dip2 |  | NUMERIC(2, 0) | YES | Dip of fault plane 2 from the best double couple
rake2 |  | NUMERIC(4, 0) | YES | Rake of fault plane 2 from the best double couple solution
unstrike1 |  | NUMERIC(6, 3) | YES | Uncertainty in strike 1
undip1 |  | NUMERIC(5, 3) | YES | Uncertainty in dip 1
unrake1 |  | NUMERIC(6, 3) | YES | Uncertainty in rake 1
unstrike2 |  | NUMERIC(6, 3) | YES | Uncertainty in strike 2
undip2 |  | NUMERIC(5, 3) | YES | Uncertainty in dip 2
unrake2 |  | NUMERIC(6, 3) | YES | Uncertainty in rake 2
eigenp |  | NUMERIC(7, 5) | YES | Eigen value of compressional axis in the principal axes representation of the best double couple
plungep |  | NUMERIC(2, 0) | YES | Plunge of the compressional axis in the principal axes representation of the best double couple
strikep |  | NUMERIC(3, 0) | YES | Strike of compressional axis in the principal axes representation of the best double couple
eigenn |  | NUMERIC(7, 5) | YES | Eigen value of null axis in the principal axes representation of the best double couple
plungen |  | NUMERIC(2, 0) | YES | Plunge of the null axis in the principal axes representation of the best double couple
striken |  | NUMERIC(3, 0) | YES | Strike of null axis in the principal axes representation of the best double couple
eigent |  | NUMERIC(7, 5) | YES | Eigen value of tension axis in the principal axes representation of the best double couple
plunget |  | NUMERIC(2, 0) | YES | Plunge of the tension axis in the principal axes representation of the best double couple
striket |  | NUMERIC(3, 0) | YES | Strike of tension axis in the principal axes representation of the best double couple
nsta |  | NUMERIC(5, 0) | YES | This quantity is the number of observations with non-zero input weights used to compute the magnitude or mechanism
pvr |  | NUMERIC(5, 0) | YES | Percent variance reduction
quality |  | NUMERIC(2, 1) | YES | This attribute denotes the quality of an origin, an arrival, or a mechanism. 1.0 = good, 0.0 = bad
pdc |  | NUMERIC(3, 0) | YES | Percent double couple of the seismic moment tensor
pclvd |  | NUMERIC(3, 0) | YES | Percent compensated linear vector dipole of the seismic moment tensor
piso |  | NUMERIC(3, 0) | YES | Percent isotropic of the seismic moment tensor
datetime |  | NUMERIC(25, 10) | NO | The date of associated with information in the record, in true epoch format
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 or last modified, in Oracle date datatype

mec Relationships

Parent Entity | Child Entity | Type | Foreign Keys
netmag | mec | Non-Identifying | magid
origin | mec | Non-Identifying | oridin
origin | mec | Non-Identifying | oridout
remark | mec | Non-Specific |
mec | event | Non-Identifying | prefmec
mec | origin | Non-Identifying | prefmec

mec Check Constraints

Check Constraint Name | CheckConstraint
mec10 | mxy >= -10.0 and mxy <= 10.0
mec11 | mxz >= -10.0 and mxz <= 10.0
mec12 | myz >= -10.0 and myz <= 10.0
mec13 | plungen >= 0 and plungen <= 90
mec14 | plungep >= 0 and plungep <= 90
mec15 | plunget >= 0 and plunget <= 90
mec16 | pclvd >= 0 and pclvd <= 100
mec17 | pdc >= 0 and pdc <= 100
mec18 | piso >= 0 and piso <= 100
mec19 | pvr >= 0 and pvr <= 100
mec20 | rake1 >= -180 and rake1 <= 180
mec21 | rake2 >= -180 and rake2 <= 180
mec22 | scalar >= -10.0 and scalar <= 10.0
mec23 | srcduration >= 0.0 and srcduration <= 100.0
mec24 | striken >= 0 and striken <= 360
mec25 | strikep >= 0 and strikep <= 360
mec26 | striket >= 0 and striket <= 360
mec27 | strike1 >= 0 and strike1 <= 360
mec28 | strike2 >= 0 and strike2 <= 360
mec29 | tfd > 0
mec30 | undip1 >= -180 and undip1 <= 180
mec31 | undip2 >= -180 and undip2 <= 180
mec32 | smxx >= -10.0 and smxx <= 10.0
mec33 | smyy >= -10.0 and smyy <= 10.0
mec34 | smzz >= -10.0 and smzz <= 10.0
mec35 | smxy >= -10.0 and smxy <= 10.0
mec36 | smxz >= -10.0 and smxz <= 10.0
mec37 | smyz >= -10.0 and smyz <= 10.0
mec38 | unrake1 >= -180.0 and unrake1 <= 180.0
mec39 | unrake2 >= -180.0 and unrake2 <= 180.0
mec40 | unstrike1 >= -180.0 and unstrike1 <= 180.0
mec41 | unstrike2 >= -180.0 and unstrike2 <= 180.0
mec01 | dip1 >= -90 and dip1 <= 90
mec02 | dip2 >= -90 and dip2 <= 90
mec03 | erscalar >= 0.0
mec05 | mecid > 0
mec06 | mechtype in ('C','C0','F','F0','H','N','S','S0')
mec07 | mxx >= -10.0 and mxx <= 10.0
mec08 | myy >= -10.0 and myy <= 10.0
mec09 | mzz >= -10.0 and mzz <= 10.0