mecdata

Logical Entity Name | MecData
Default Table Name | mecdata
Definition | Summary information on data associated with a mechanism

mecdata Columns

ColumnName | Domain | Datatype | NULL | Definition
mecdataid |  | NUMBER(15, 0) | NO | Mechanism data identifier
mecid |  | NUMBER(15, 0) | YES | Mechanism identification. Each mechanism is assigned a unique positive integer which identifies it in the database
mecfreqid |  | NUMBER(15, 0) | YES | Frequency information identifier
polarity |  | VARCHAR2(2) | YES | Polarity of pick. This is the polarity as used by fpfit, corrected for dip, gain and reversals. Format like arrival.fm
discrepancy |  | VARCHAR2(1) | YES | Mainly used for fpfit. Does the polarity of the data match the quadrant of the mechanism
orientation |  | VARCHAR2(1) | YES | How are the components listed in the mecchannel table used (rotation, transformation). If channel has a polarity reversal, i.e. polarity is inverted from the raw polarity read from the waveforms, this should be indicated by a 'I' for inverted in this field. If data have not been inverted, enter " " (blank)
quality |  | NUMBER(3, 2) | YES | Quality. Fpfit uses quality 0-9
amplitude |  | FLOAT(126) | YES | SMTINV: spectral amplitude at the frequency given by mecfreqid
phase |  | FLOAT(126) | YES | SMTINV: spectral phase at the frequency given by mecfreqid
time1 |  | NUMBER(25, 10) | YES | Start time of: TDMT: complete waveform window SMTINV: window for spectrum FPFIT: pick time
time2 |  | NUMBER(25, 10) | YES | End of window, if window used (CW, SW)
model |  | VARCHAR2(10) | YES | Model used for greens functions; velocity model for other methods
zcor |  | NUMBER(5, 0) | YES | TDMT: value of cross correlation shift in samples for best solution
corlen |  | NUMBER(5, 0) | YES | TDMT: length of cross correlation window used in samples
dt |  | NUMBER(11, 5) | YES | Sampling interval of data used in inversion (could be resampled from original data); sampling interval valid for GF and data
varred |  | NUMBER(4, 1) | YES | Fit for tis station
lddate |  | DATE | YES | Load date. Date and time that the record was created, in Oracle date datatype

mecdata Primary and Unique Keys

Key Name | Key Type | Keys
MecData_PK | PrimaryKey | mecdataid

mecdata Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred
mec | Non-Identifying | Zero or One to Zero or More |  |  |  | mecid | NO | NO | NO
mecfreq | Non-Identifying | Zero or One to Zero or More | MecData_FK02 |  |  | mecfreqid | NO | NO | NO

Child Relationships:

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

mecdata Check Constraints

Check Constraint Name | CheckConstraint
MecData02 | orientation IN ('C','R','T','H','3','L','E','N','Z','A','I',' ')
MecData03 | quality BETWEEN 0 AND 1
MecData04 | model IN ('mend1_','socal','gil7_')
MecData05 | mecid > 0
MecData06 | mecdataid > 0
MecData07 | mecfreqid > 0
MecData01 | discrepancy IN ('T','F')