Constraints

35 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
INTERPRETATIONS_rups.DS_ID
INTERPRETATIONS_rups.EQ_ID
INTERPRETATIONS_rups.RUP_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
RUPOBS_id.RUP_ID
Restrict delete
PTOBS_vs.DS_ID
PTOBS_vs.EQ_ID
PTOBS_vs.MEAS_ID
PTOBS_vs.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_ads.DS_ID
PTOBS_ads.EQ_ID
PTOBS_ads.MEAS_ID
PTOBS_ads.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
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_fns.DS_ID
PTOBS_fns.EQ_ID
PTOBS_fns.MEAS_ID
PTOBS_fns.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_location.DS_ID
PTOBS_location.EQ_ID
PTOBS_location.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_fps.DS_ID
PTOBS_fps.EQ_ID
PTOBS_fps.MEAS_ID
PTOBS_fps.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_elevation.DS_ID
PTOBS_elevation.EQ_ID
PTOBS_elevation.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_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
PTOBS_nhs.DS_ID
PTOBS_nhs.EQ_ID
PTOBS_nhs.MEAS_ID
PTOBS_nhs.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
PTOBS_sh.DS_ID
PTOBS_sh.EQ_ID
PTOBS_sh.MEAS_ID
PTOBS_sh.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_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
INTERPRETATIONS_pts.DS_ID
INTERPRETATIONS_pts.EQ_ID
INTERPRETATIONS_pts.MEAS_ID
INTERPRETATIONS_pts.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete
RUPOBS_geology.RUP_DS_ID
RUPOBS_geology.EQ_ID
RUPOBS_geology.GEO_DS_ID
RUPOBS_geology.RUP_ID
RUPOBS_geology.NODE_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
METADATA_geology.DS_ID
RUPOBS_id.RUP_ID
RUPOBS_location.NODE_ID
Restrict delete
ECS_linepath.EQ_ID
METADATA_events.EQ_ID
Restrict delete
PTOBS_feature.DS_ID
PTOBS_feature.EQ_ID
PTOBS_feature.MEAS_ID
PTOBS_feature.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
RUPOBS_length.DS_ID
RUPOBS_length.EQ_ID
RUPOBS_length.RUP_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
RUPOBS_id.RUP_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
ECS_pts.DS_ID
ECS_pts.EQ_ID
ECS_pts.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.PT_ID
Restrict delete
ECS_rups.DS_ID
ECS_rups.EQ_ID
ECS_rups.RUP_ID
ECS_rups.NODE_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
RUPOBS_id.RUP_ID
RUPOBS_location.NODE_ID
Restrict delete
METADATA_points.DS_ID
METADATA_points.EQ_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_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
PTOBS_tds.DS_ID
PTOBS_tds.EQ_ID
PTOBS_tds.MEAS_ID
PTOBS_tds.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_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
RUPOBS_aftershock.DS_ID
RUPOBS_aftershock.EQ_ID
RUPOBS_aftershock.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_aftershock.DS_ID
PTOBS_aftershock.EQ_ID
PTOBS_aftershock.MEAS_ID
PTOBS_aftershock.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
PTOBS_compass.DS_ID
PTOBS_compass.EQ_ID
PTOBS_compass.MEAS_ID
PTOBS_compass.PT_ID
METADATA_datasets.DS_ID
METADATA_events.EQ_ID
PTOBS_id.MEAS_ID
PTOBS_id.PT_ID
Restrict delete

Check Constraints

Table Constraint Name Constraint