Constraints

39 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
PTOBS_aperture.DS_ID
PTOBS_aperture.EQ_ID
PTOBS_aperture.MEAS_ID
PTOBS_aperture.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_off_nhs.DS_ID
PTOBS_off_nhs.EQ_ID
PTOBS_off_nhs.MEAS_ID
PTOBS_off_nhs.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_tot_ads.DS_ID
PTOBS_tot_ads.EQ_ID
PTOBS_tot_ads.MEAS_ID
PTOBS_tot_ads.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_tot_fps.DS_ID
PTOBS_tot_fps.EQ_ID
PTOBS_tot_fps.MEAS_ID
PTOBS_tot_fps.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_nsplays.DS_ID
PTOBS_nsplays.EQ_ID
PTOBS_nsplays.MEAS_ID
PTOBS_nsplays.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_tot_fns.DS_ID
PTOBS_tot_fns.EQ_ID
PTOBS_tot_fns.MEAS_ID
PTOBS_tot_fns.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_on_vs.DS_ID
PTOBS_on_vs.EQ_ID
PTOBS_on_vs.MEAS_ID
PTOBS_on_vs.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
RUPOBS_confidence.DS_ID
RUPOBS_confidence.EQ_ID
RUPOBS_confidence.RUP_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
RUPOBS_id.RUP_ID
Restrict delete
PTOBS_location.DS_ID
PTOBS_location.EQ_ID
PTOBS_location.MEAS_ID
PTOBS_location.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_fzw.DS_ID
PTOBS_fzw.EQ_ID
PTOBS_fzw.MEAS_ID
PTOBS_fzw.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_on_tds.DS_ID
PTOBS_on_tds.EQ_ID
PTOBS_on_tds.MEAS_ID
PTOBS_on_tds.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_off_tds.DS_ID
PTOBS_off_tds.EQ_ID
PTOBS_off_tds.MEAS_ID
PTOBS_off_tds.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_tot_nhs.DS_ID
PTOBS_tot_nhs.EQ_ID
PTOBS_tot_nhs.MEAS_ID
PTOBS_tot_nhs.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_confidence.DS_ID
PTOBS_confidence.EQ_ID
PTOBS_confidence.MEAS_ID
PTOBS_confidence.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_geology.PT_DS_ID
PTOBS_geology.EQ_ID
PTOBS_geology.GEO_DS_ID
PTOBS_geology.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
METADATA_geology.DS_ID
PTOBS_id.PT_ID
Restrict delete
RUPOBS_sliprate.DS_ID
RUPOBS_sliprate.EQ_ID
RUPOBS_sliprate.RUP_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
RUPOBS_id.RUP_ID
Restrict delete
RUPOBS_geology.RUP_DS_ID
RUPOBS_geology.EQ_ID
RUPOBS_geology.GEO_DS_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
METADATA_geology.DS_ID
Restrict delete
PTOBS_tot_tds.DS_ID
PTOBS_tot_tds.EQ_ID
PTOBS_tot_tds.MEAS_ID
PTOBS_tot_tds.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_id.DS_ID
PTOBS_id.EQ_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
Restrict delete
PTOBS_tot_vs.DS_ID
PTOBS_tot_vs.EQ_ID
PTOBS_tot_vs.MEAS_ID
PTOBS_tot_vs.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_slip_nonzero.DS_ID
PTOBS_slip_nonzero.EQ_ID
PTOBS_slip_nonzero.MEAS_ID
PTOBS_slip_nonzero.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
RUPOBS_mapscale.DS_ID
RUPOBS_mapscale.EQ_ID
RUPOBS_mapscale.RUP_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
RUPOBS_id.RUP_ID
Restrict delete
METADATA_points.DS_ID
METADATA_points.EQ_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
Restrict delete
PTOBS_dip.DS_ID
PTOBS_dip.EQ_ID
PTOBS_dip.MEAS_ID
PTOBS_dip.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_on_ads.DS_ID
PTOBS_on_ads.EQ_ID
PTOBS_on_ads.MEAS_ID
PTOBS_on_ads.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_off_vs.DS_ID
PTOBS_off_vs.EQ_ID
PTOBS_off_vs.MEAS_ID
PTOBS_off_vs.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_on_nhs.DS_ID
PTOBS_on_nhs.EQ_ID
PTOBS_on_nhs.MEAS_ID
PTOBS_on_nhs.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
RUPOBS_faultname.DS_ID
RUPOBS_faultname.EQ_ID
RUPOBS_faultname.RUP_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
RUPOBS_id.RUP_ID
Restrict delete
METADATA_ruptures.DS_ID
METADATA_ruptures.EQ_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
Restrict delete
RUPOBS_location.DS_ID
RUPOBS_location.EQ_ID
RUPOBS_location.RUP_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
RUPOBS_id.RUP_ID
Restrict delete
PTOBS_off_fps.DS_ID
PTOBS_off_fps.EQ_ID
PTOBS_off_fps.MEAS_ID
PTOBS_off_fps.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
RUPOBS_endcheck.DS_ID
RUPOBS_endcheck.EQ_ID
RUPOBS_endcheck.RUP_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
RUPOBS_id.RUP_ID
Restrict delete
METADATA_geology.DS_ID
METADATA_datasets.DS_ID
Restrict delete
PTOBS_on_fps.DS_ID
PTOBS_on_fps.EQ_ID
PTOBS_on_fps.MEAS_ID
PTOBS_on_fps.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_off_ads.DS_ID
PTOBS_off_ads.EQ_ID
PTOBS_off_ads.MEAS_ID
PTOBS_off_ads.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_on_fns.DS_ID
PTOBS_on_fns.EQ_ID
PTOBS_on_fns.MEAS_ID
PTOBS_on_fns.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_off_fns.DS_ID
PTOBS_off_fns.EQ_ID
PTOBS_off_fns.MEAS_ID
PTOBS_off_fns.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PAIRING_ptrup.RUP_DS_ID
PAIRING_ptrup.PT_DS_ID
PAIRING_ptrup.EQ_ID
PAIRING_ptrup.PT_ID
PAIRING_ptrup.RUP_ID
METADATA_datasets.DS_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.PT_ID
RUPOBS_id.RUP_ID
Restrict delete
RUPOBS_id.DS_ID
RUPOBS_id.EQ_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
Restrict delete

Check Constraints

Table Constraint Name Constraint