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