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(PK)    NUMERIC(15, 0)  NO  Mechanism data identifier 
mecid(FK)    NUMERIC(15, 0)  YES  Mechanism identification. Each mechanism is assigned a unique positive integer which identifies it in the database 
mecfreqid(FK)    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