mecdata

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

mecdata Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
mecdataid |  | NUMERIC(15, 0) | NO | Mechanism data identifier
mecid |  | NUMERIC(15, 0) | YES | Mechanism identification. Each mechanism is assigned a unique positive integer which identifies it in the database
mecfreqid |  | NUMERIC(15, 0) | YES | Frequency information identifier
polarity |  | VARCHAR(2) | YES | Polarity of pick. This is the polarity as used by fpfit, corrected for dip, gain and reversals. Format like arrival.fm
discrepancy |  | VARCHAR(1) | YES | Mainly used for fpfit. Does the polarity of the data match the quadrant of the mechanism
orientation |  | VARCHAR(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 |  | NUMERIC(3, 2) | YES | Quality. Fpfit uses quality 0-9
amplitude |  | REAL/SMALLFLOAT | YES | SMTINV: spectral amplitude at the frequency given by mecfreqid
phase |  | REAL/SMALLFLOAT | YES | SMTINV: spectral phase at the frequency given by mecfreqid
time1 |  | NUMERIC(25, 10) | YES | Start time of: TDMT: complete waveform window SMTINV: window for spectrum FPFIT: pick time
time2 |  | NUMERIC(25, 10) | YES | End of window, if window used (CW, SW)
model |  | VARCHAR(10) | YES | Model used for greens functions; velocity model for other methods
zcor |  | NUMERIC(5, 0) | YES | TDMT: value of cross correlation shift in samples for best solution
corlen |  | NUMERIC(5, 0) | YES | TDMT: length of cross correlation window used in samples
dt |  | NUMERIC(11, 5) | YES | Sampling interval of data used in inversion (could be resampled from original data); sampling interval valid for GF and data
varred |  | NUMERIC(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 Keys

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

mecdata Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
mec | Non-Identifying | Zero or One to Zero or More |  |  |  | mecid | NO
mecfreq | Non-Identifying | Zero or One to Zero or More |  |  |  | mecfreqid | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
mecchannel | Identifying | One To Zero or More |  |  |  |  | NO

mecdata Check Constraints

Check Constraint Name | CheckConstraint
MecData01 | discrepancy IN ('T','F')
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