| mecdataid |
| Base Entity | mecdata |
| Attribute Name | mecdataid |
| Logical Rolename | |
| ColumnName | mecdataid |
| RoleName | |
| Definition | Mechanism data identifier |
| Note | Range: mecdataid > 0 |
| mecid |
| Base Entity | mecdata |
| Attribute Name | mecid |
| Logical Rolename | |
| ColumnName | mecid |
| RoleName | |
| Definition | Mechanism identification. Each mechanism is assigned a unique positive integer which identifies it in the database |
| Note | Range: mecid > 0 |
| mecfreqid |
| Base Entity | mecdata |
| Attribute Name | mecfreqid |
| Logical Rolename | |
| ColumnName | mecfreqid |
| RoleName | |
| Definition | Frequency information identifier |
| Note | Range: mecfreqid > 0 |
| polarity |
| Base Entity | mecdata |
| Attribute Name | polarity |
| Logical Rolename | |
| ColumnName | polarity |
| RoleName | |
| Definition | Polarity of pick. This is the polarity as used by fpfit, corrected for dip, gain and reversals. Format like arrival.fm |
| Note | Range: All two-letter permutations of (c | d | .} U {u | r | .} |
| discrepancy |
| Base Entity | mecdata |
| Attribute Name | discrepancy |
| Logical Rolename | |
| ColumnName | discrepancy |
| RoleName | |
| Definition | Mainly used for fpfit. Does the polarity of the data match the quadrant of the mechanism |
| Note | Range: discrepancy = {T | F} T = TRUE F = FALSE |
| orientation |
| Base Entity | mecdata |
| Attribute Name | orientation |
| Logical Rolename | |
| ColumnName | orientation |
| RoleName | |
| Definition | 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) |
| Note | Range: orientation = {C | R | T | H | 3 | L | E | N | Z | A | I} |
| quality |
| Base Entity | mecdata |
| Attribute Name | quality |
| Logical Rolename | |
| ColumnName | quality |
| RoleName | |
| Definition | Quality. Fpfit uses quality 0-9 |
| Note | Range: 0 <= quality <= 1 |
| amplitude |
| Base Entity | mecdata |
| Attribute Name | amplitude |
| Logical Rolename | |
| ColumnName | amplitude |
| RoleName | |
| Definition | SMTINV: spectral amplitude at the frequency given by mecfreqid |
| Note |
| phase |
| Base Entity | mecdata |
| Attribute Name | phase |
| Logical Rolename | |
| ColumnName | phase |
| RoleName | |
| Definition | SMTINV: spectral phase at the frequency given by mecfreqid |
| Note |
| time1 |
| Base Entity | mecdata |
| Attribute Name | time1 |
| Logical Rolename | |
| ColumnName | time1 |
| RoleName | |
| Definition | Start time of: TDMT: complete waveform window SMTINV: window for spectrum FPFIT: pick time |
| Note |
| time2 |
| Base Entity | mecdata |
| Attribute Name | time2 |
| Logical Rolename | |
| ColumnName | time2 |
| RoleName | |
| Definition | End of window, if window used (CW, SW) |
| Note |
| model |
| Base Entity | mecdata |
| Attribute Name | model |
| Logical Rolename | |
| ColumnName | model |
| RoleName | |
| Definition | Model used for greens functions; velocity model for other methods |
| Note | Range: model = {mend1_ | socal | gil7_} |
| zcor |
| Base Entity | mecdata |
| Attribute Name | zcor |
| Logical Rolename | |
| ColumnName | zcor |
| RoleName | |
| Definition | TDMT: value of cross correlation shift in samples for best solution |
| Note |
| corlen |
| Base Entity | mecdata |
| Attribute Name | corlen |
| Logical Rolename | |
| ColumnName | corlen |
| RoleName | |
| Definition | TDMT: length of cross correlation window used in samples |
| Note |
| dt |
| Base Entity | mecdata |
| Attribute Name | dt |
| Logical Rolename | |
| ColumnName | dt |
| RoleName | |
| Definition | Sampling interval of data used in inversion (could be resampled from original data); sampling interval valid for GF and data |
| Note |
| varred |
| Base Entity | mecdata |
| Attribute Name | varred |
| Logical Rolename | |
| ColumnName | varred |
| RoleName | |
| Definition | Fit for tis station |
| Note |
| lddate |
| Base Entity | mecdata |
| Attribute Name | lddate |
| Logical Rolename | |
| ColumnName | lddate |
| RoleName | |
| Definition | Load date. Date and time that the record was created, in Oracle date datatype |
| Note | Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS |