PTOBS_id

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obs_date_approx_flag BOOLEAN 2000000000,10 null
location_basis TEXT 2000000000,10 null
obs_year INTEGER 2000000000,10 null
DS_ID INTEGER 2000000000,10 null
METADATA_datasets.DS_ID R
row_entry_source_file TEXT 2000000000,10 null
row_entry_date_updated DATETIME 2000000000,10 null
EQ_ID INTEGER 2000000000,10 null
METADATA_events.EQ_ID R
originator_id TEXT 2000000000,10 null
measurement_uncertainty_type TEXT 2000000000,10 null
aperture_max_meters FLOAT 2000000000,10 null
MEAS_ID INTEGER 2000000000,10 null
INTERPRETATIONS_pts.MEAS_ID R
PTOBS_ads.MEAS_ID R
PTOBS_aftershock.MEAS_ID R
PTOBS_compass.MEAS_ID R
PTOBS_confidence.MEAS_ID R
PTOBS_feature.MEAS_ID R
PTOBS_fns.MEAS_ID R
PTOBS_fps.MEAS_ID R
PTOBS_fzw.MEAS_ID R
PTOBS_nhs.MEAS_ID R
PTOBS_nsplays.MEAS_ID R
PTOBS_sh.MEAS_ID R
PTOBS_slip_nonzero.MEAS_ID R
PTOBS_tds.MEAS_ID R
PTOBS_vs.MEAS_ID R
obs_mody INTEGER 2000000000,10 null
PT_ID INTEGER 2000000000,10 null
ECS_pts.PT_ID R
INTERPRETATIONS_pts.PT_ID R
PAIRING_ptrup.PT_ID R
PTOBS_ads.PT_ID R
PTOBS_aftershock.PT_ID R
PTOBS_compass.PT_ID R
PTOBS_confidence.PT_ID R
PTOBS_elevation.PT_ID R
PTOBS_feature.PT_ID R
PTOBS_fns.PT_ID R
PTOBS_fps.PT_ID R
PTOBS_fzw.PT_ID R
PTOBS_geology.PT_ID R
PTOBS_location.PT_ID R
PTOBS_nhs.PT_ID R
PTOBS_nsplays.PT_ID R
PTOBS_sh.PT_ID R
PTOBS_slip_nonzero.PT_ID R
PTOBS_tds.PT_ID R
PTOBS_vs.PT_ID R
days_elapsed INTEGER 2000000000,10 null

Indexes

Constraint Name Type Sort Column(s)
PTOBS_id_s_pk Primary key Asc/Asc/Asc/Asc DS_ID + EQ_ID + MEAS_ID + PT_ID
sqlite_autoindex_PTOBS_id_1 Must be unique Asc/Asc/Asc/Asc PT_ID + EQ_ID + DS_ID + MEAS_ID

Relationships