PTOBS_id

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PT_ID INTEGER 2000000000,10 null
PAIRING_ptrup.PT_ID R
PTOBS_aperture.PT_ID R
PTOBS_confidence.PT_ID R
PTOBS_dip.PT_ID R
PTOBS_fzw.PT_ID R
PTOBS_geology.PT_ID R
PTOBS_location.PT_ID R
PTOBS_nsplays.PT_ID R
PTOBS_off_ads.PT_ID R
PTOBS_off_fns.PT_ID R
PTOBS_off_fps.PT_ID R
PTOBS_off_nhs.PT_ID R
PTOBS_off_tds.PT_ID R
PTOBS_off_vs.PT_ID R
PTOBS_on_ads.PT_ID R
PTOBS_on_fns.PT_ID R
PTOBS_on_fps.PT_ID R
PTOBS_on_nhs.PT_ID R
PTOBS_on_tds.PT_ID R
PTOBS_on_vs.PT_ID R
PTOBS_slip_nonzero.PT_ID R
PTOBS_tot_ads.PT_ID R
PTOBS_tot_fns.PT_ID R
PTOBS_tot_fps.PT_ID R
PTOBS_tot_nhs.PT_ID R
PTOBS_tot_tds.PT_ID R
PTOBS_tot_vs.PT_ID R
row_entry_date_updated DATETIME 2000000000,10 null
EQ_ID INTEGER 2000000000,10 null
METADATA_events.EQ_ID R
obs_year INTEGER 2000000000,10 null
DS_ID INTEGER 2000000000,10 null
METADATA_datasets.DS_ID R
days_elapsed INTEGER 2000000000,10 null
MEAS_ID INTEGER 2000000000,10 null
PTOBS_aperture.MEAS_ID R
PTOBS_confidence.MEAS_ID R
PTOBS_dip.MEAS_ID R
PTOBS_fzw.MEAS_ID R
PTOBS_location.MEAS_ID R
PTOBS_nsplays.MEAS_ID R
PTOBS_off_ads.MEAS_ID R
PTOBS_off_fns.MEAS_ID R
PTOBS_off_fps.MEAS_ID R
PTOBS_off_nhs.MEAS_ID R
PTOBS_off_tds.MEAS_ID R
PTOBS_off_vs.MEAS_ID R
PTOBS_on_ads.MEAS_ID R
PTOBS_on_fns.MEAS_ID R
PTOBS_on_fps.MEAS_ID R
PTOBS_on_nhs.MEAS_ID R
PTOBS_on_tds.MEAS_ID R
PTOBS_on_vs.MEAS_ID R
PTOBS_slip_nonzero.MEAS_ID R
PTOBS_tot_ads.MEAS_ID R
PTOBS_tot_fns.MEAS_ID R
PTOBS_tot_fps.MEAS_ID R
PTOBS_tot_nhs.MEAS_ID R
PTOBS_tot_tds.MEAS_ID R
PTOBS_tot_vs.MEAS_ID R
originator_id TEXT 2000000000,10 null
obs_mody INTEGER 2000000000,10 null
row_entry_source_file TEXT 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