Constraints

18 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
exposure_log_parent_fk
exposure_log.parent
charge_fields.field_root
Restrict delete
exposure_log_fk
exposure_log.dataset
mast_products.dataset
Restrict delete
fk_tile_exposures
mosaic_tiles_exposures.expid
exposure_files.eid
Restrict delete
fk_unique_objid
nirspec_unique_match.objid
nirspec_unique.objid
Restrict delete
mast_products_fk
mast_products.obsid
mast_query.obsid
Restrict delete
fk_ext_datemask
mosfire_extractions.datemask
mosfire_datemask.datemask
Restrict delete
const_fitq_root
redshift_fit_quasar.phot_root
charge_fields.field_root
Restrict delete
const_fit_root
redshift_fit.phot_root
charge_fields.field_root
Restrict delete
mosfire_spectra_j_datemask_fkey
mosfire_spectra_j.datemask
mosfire_spectra_j.filter
mosfire_spectra_j.slitnum
mosfire_extractions.datemask
mosfire_extractions.filter
mosfire_extractions.slitnum
Restrict delete
mosfire_spectra_h_datemask_fkey
mosfire_spectra_h.datemask
mosfire_spectra_h.filter
mosfire_spectra_h.slitnum
mosfire_extractions.datemask
mosfire_extractions.filter
mosfire_extractions.slitnum
Restrict delete
mosfire_spectra_k_datemask_fkey
mosfire_spectra_k.datemask
mosfire_spectra_k.filter
mosfire_spectra_k.slitnum
mosfire_extractions.datemask
mosfire_extractions.filter
mosfire_extractions.slitnum
Restrict delete
const_chroot
photometry_apcorr.p_root
charge_fields.field_root
Restrict delete
mosfire_spectra_y_datemask_fkey
mosfire_spectra_y.datemask
mosfire_spectra_y.filter
mosfire_spectra_y.slitnum
mosfire_extractions.datemask
mosfire_extractions.filter
mosfire_extractions.slitnum
Restrict delete
exposure_saturated_eid_fkey
exposure_saturated.eid
exposure_files.eid
Restrict delete
fk_exp_datemask
mosfire_exposures.datemask
mosfire_datemask.datemask
Restrict delete
field_observation_obs_key_fkey
field_observation.obs_key
observation.obs_key
Cascade on delete
field_observation_field_key_fkey
field_observation.field_key
survey_fields.field_key
Cascade on delete
mosfire_phot_matches_datemask_fkey
mosfire_phot_matches.datemask
mosfire_phot_matches.filter
mosfire_phot_matches.slitnum
mosfire_extractions.datemask
mosfire_extractions.filter
mosfire_extractions.slitnum
Restrict delete

Check Constraints

Table Constraint Name Constraint