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

mec Columns 
ColumnName  Domain  Datatype  NULL  Definition 
mecid(PK)    NUMBER(15, 0)  NO  Mechanism identification. Each mechanism is assigned a unique positive integer which identifies it in the database 
oridin(FK)    NUMBER(15, 0)  YES  Input origin. This attribute holds the origin identifier, orid, that points to the origin from which the mechanism was computed 
oridout(FK)    NUMBER(15, 0)  YES  Output origin. This attribute holds the origin identifier, orid, that points to the origin computed from the mechanism 
magid(FK)    NUMBER(15, 0)  YES  Magnitude identifier. This key is used to identify a magnitude in the Netmag relation. It is required for every magnitude 
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 
mechtype    VARCHAR2(2)  YES  Mechanism type 
mecalgo    VARCHAR2(15)  YES  This attribute represents the algorithm used to compute the mechanism (TDMT,TMTS=Dreger's code; FPFIT=fpfit; SMTINV=Pasyanos code) 
scalar    BINARY_DOUBLE  YES  Seismic scalar moment (no value stored for fpfit) 
erscalar    BINARY_DOUBLE  YES  Error in scalar moment. This is the standard deviation of the scalar moment 
tft    VARCHAR2(8)  YES  Type of source time function. Used to specify if time function and source half-duration are assumed, derived, or determined 
tfd    BINARY_DOUBLE  YES  Duration of the source time function 
mxx    BINARY_DOUBLE  YES  Moment tensor elements. Given in Aki convention 
myy    BINARY_DOUBLE  YES  Moment tensor elements. Given in Aki convention 
mzz    BINARY_DOUBLE  YES  Moment tensor elements. Given in Aki convention 
mxy    BINARY_DOUBLE  YES  Moment tensor elements. Given in Aki convention 
mxz    BINARY_DOUBLE  YES  Moment tensor elements. Given in Aki convention 
myz    BINARY_DOUBLE  YES  Moment tensor elements. Given in Aki convention 
smxx    BINARY_DOUBLE  YES  Uncertainties in moment tensor elements 
smyy    BINARY_DOUBLE  YES  Uncertainties in moment tensor elements 
smzz    BINARY_DOUBLE  YES  Uncertainties in moment tensor elements 
smxy    BINARY_DOUBLE  YES  Uncertainties in moment tensor elements 
smxz    BINARY_DOUBLE  YES  Uncertainties in moment tensor elements 
smyz    BINARY_DOUBLE  YES  Uncertainties in moment tensor elements 
srcduration    NUMBER(6, 3)  YES  Source half-duration 
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 
strike1    NUMBER(3, 0)  YES  Strike of fault plane 1 from the best double couple 
dip1    NUMBER(3, 0)  YES  Dip of fault plane 1 from the best double couple 
rake1    NUMBER(4, 0)  YES  Rake of fault plane 1 from the best double couple solution 
strike2    NUMBER(3, 0)  YES  Strike of fault plane 2 from the best double couple 
dip2    NUMBER(2, 0)  YES  Dip of fault plane 2 from the best double couple 
rake2    NUMBER(4, 0)  YES  Rake of fault plane 2 from the best double couple solution 
unstrike1    NUMBER(6, 3)  YES  Uncertainty in strike 1 
undip1    NUMBER(5, 3)  YES  Uncertainty in dip 1 
unrake1    NUMBER(6, 3)  YES  Uncertainty in rake 1 
unstrike2    NUMBER(6, 3)  YES  Uncertainty in strike 2 
undip2    NUMBER(5, 3)  YES  Uncertainty in dip 2 
unrake2    NUMBER(6, 3)  YES  Uncertainty in rake 2 
eigenp    BINARY_DOUBLE  YES  Eigen value of compressional axis in the principal axes representation of the best double couple 
plungep    NUMBER(2, 0)  YES  Plunge of the compressional axis in the principal axes representation of the best double couple 
strikep    NUMBER(3, 0)  YES  Strike of compressional axis in the principal axes representation of the best double couple 
eigenn    BINARY_DOUBLE  YES  Eigen value of null axis in the principal axes representation of the best double couple 
plungen    NUMBER(2, 0)  YES  Plunge of the null axis in the principal axes representation of the best double couple 
striken    NUMBER(3, 0)  YES  Strike of null axis in the principal axes representation of the best double couple 
eigent    BINARY_DOUBLE  YES  Eigen value of tension axis in the principal axes representation of the best double couple 
plunget    NUMBER(2, 0)  YES  Plunge of the tension axis in the principal axes representation of the best double couple 
striket    NUMBER(3, 0)  YES  Strike of tension axis in the principal axes representation of the best double couple 
nsta    NUMBER(5, 0)  YES  This quantity is the number of observations with non-zero input weights used to compute the mechanism. For CW=nsta, for FPFIT=nPobs, for HASH=nobs 
pvr    NUMBER(5, 0)  YES  Goodness of fit. For TDMT this is percent variance reduction; for FPFIT this is (1-misfit)*100 
quality    NUMBER(2, 1)  YES  This attribute denotes the quality of an origin, an arrival, or a mechanism. 1.0 = good, 0.0 = bad 
pdc    NUMBER(3, 0)  YES  Percent double couple of the seismic moment tensor 
pclvd    NUMBER(3, 0)  YES  Percent compensated linear vector dipole of the seismic moment tensor 
piso    NUMBER(3, 0)  YES  Percent isotropic of the seismic moment tensor. If the solution is constrained to have zero trace (no "ISO"), then "ISO" should be NULL, as opposed to a case where the full moment tensor was used, and the ISO component ended up being very small ("0") 
datetime    NUMBER(25, 10)  NO  The date of associated with information in the record, in true epoch format 
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 

mec Primary and Unique Keys 
Key Name  Key Type  Keys 
meckey01  PrimaryKey  mecid 

mec Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
netmag  Non-Identifying  Zero or One to Zero or More  Mec_Net      magid  NO  NO  NO 
origin  Non-Identifying  Zero or One to Zero or More  Mec_Ori      oridin  NO  NO  NO 
origin  Non-Identifying  Zero or One to Zero or More  Mec_Ori2      oridout  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
eventprefmec  Non-Identifying  One To Zero or More          NO  NO  YES 
mecdata  Non-Identifying  One To Zero or More          NO  NO  YES 
mecobject  Non-Identifying  One To Zero or More          NO  NO  NO 
event  Non-Identifying  One To Zero or More  Eve_Mec        NO  NO  NO 
origin  Non-Identifying  One To Zero or More  Ori_Mec        NO  NO  NO 

mec Check Constraints 
Check Constraint Name  CheckConstraint 
mec01  dip1 >= -90 and dip1 <= 90 
mec02  dip2 >= -90 and dip2 <= 90 
mec03  erscalar >= 0.0 
mec05  mecid > 0 
mec06  mechtype in ('FP','MT') 
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 
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 
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 
mec42  quality >= 0.0 and quality <= 1.0