124 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_megatrait_quality_lookup |
|
|
Restrict delete | ||
| fk_megatrait_quality_parent |
|
|
Cascade on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_megastructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_macrotrait_quality_lookup |
|
|
Restrict delete | ||
| fk_macrotrait_quality_parent |
|
|
Cascade on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_microstructure |
|
|
Cascade on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| tbl_ingestion_submissions_submitted_by_fkey |
|
|
Restrict delete | ||
| tbl_ingestion_submissions_reviewed_by_fkey |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_mesotrait_quality_parent |
|
|
Cascade on delete | ||
| fk_mesotrait_quality_lookup |
|
|
Restrict delete | ||
| fk_junct_megastructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| tbl_audit_logs_actor_userid_fkey |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| jtbl_project_citations_projectid_fkey |
|
|
Cascade on delete | ||
| jtbl_project_citations_citationid_fkey |
|
|
Cascade on delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_Tectsetting_Lookup |
|
|
Restrict delete | ||
| fk_megastructure_age_confidence |
|
|
Restrict delete | ||
| fk_horScale_Lookup |
|
|
Restrict delete | ||
| fk_depSetting_Lookup |
|
|
Restrict delete | ||
| fk_megastructure_projectID |
|
|
Null on delete | ||
| fk_sedInterface_Lookup |
|
|
Restrict delete | ||
| fk_buildupInterface_Lookup |
|
|
Restrict delete | ||
| fk_initiation_Lookup |
|
|
Restrict delete | ||
| fk_substrate_Lookup |
|
|
Restrict delete | ||
| fk_megastructure_age_basis |
|
|
Restrict delete | ||
| fk_buildupType_Lookup |
|
|
Restrict delete | ||
| fk_megastructure_age_unit |
|
|
Restrict delete | ||
| fk_vertScale_Lookup |
|
|
Restrict delete | ||
| fk_megastructure_age_qualifier |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| jtbl_collection_citations_collectionid_fkey |
|
|
Cascade on delete | ||
| jtbl_collection_citations_citationid_fkey |
|
|
Cascade on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_megastructure_macrostructure |
|
|
Null on delete | ||
| fk_attitude_Lookup |
|
|
Restrict delete | ||
| fk_spacing_Lookup |
|
|
Restrict delete | ||
| fk_growthVar_Lookup |
|
|
Restrict delete | ||
| fk_aspectRation_Lookup |
|
|
Restrict delete | ||
| fk_linkage_Lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| jtbl_citationgroups_citationgroupid_fkey |
|
|
Cascade on delete | ||
| jtbl_citationgroups_citationid_fkey |
|
|
Cascade on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_microtrait_quality_parent |
|
|
Cascade on delete | ||
| fk_microtrait_quality_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_megastructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_macrostructure_mesostructure |
|
|
Null on delete | ||
| fk_latCont_Lookup |
|
|
Restrict delete | ||
| fk_modSkew_Lookup |
|
|
Restrict delete | ||
| fk_clotHier_Lookup |
|
|
Restrict delete | ||
| fk_lamInheritance_Lookup |
|
|
Restrict delete | ||
| fk_synRelief_Lookup |
|
|
Restrict delete | ||
| fk_wall_Lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| tbl_change_requests_requested_by_fkey |
|
|
Restrict delete | ||
| tbl_change_requests_reviewed_by_fkey |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_mesostructure_microstructure |
|
|
Null on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_ingestion_attachment_canonical_photo |
|
|
Restrict delete | ||
| tbl_ingestion_attachments_submission_id_fkey |
|
|
Cascade on delete | ||
| fk_photolinks_mesostructure |
|
|
Null on delete | ||
| fk_photolinks_macrostructure |
|
|
Null on delete | ||
| fk_photolinks_microstructure |
|
|
Null on delete | ||
| fk_photolinks_megastructure |
|
|
Null on delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| tbl_ingestion_submissions | chk_tbl_ingestion_submissions_status | (status = ANY (ARRAY['DRAFT'::text, 'SUBMITTED'::text, 'IN_REVIEW'::text, 'CHANGES_REQUESTED'::text, 'PUBLISHED'::text, 'REJECTED'::text])) |
| tbl_ingestion_submissions | chk_tbl_ingestion_submissions_ux_level_used | ((ux_level_used IS NULL) OR (ux_level_used = ANY (ARRAY['minimal'::text, 'enhanced'::text, 'advanced'::text, 'custom'::text]))) |
| tbl_megastructuredata | chk_megastructure_interpreted_age_pair | (((megainterpretedage IS NULL) AND (megainterpretedageunitid IS NULL)) OR ((megainterpretedage IS NOT NULL) AND (megainterpretedageunitid IS NOT NULL))) |
| spatial_ref_sys | spatial_ref_sys_srid_check | ((srid > 0) AND (srid <= 998999)) |
| tbl_change_requests | tbl_change_requests_status_check | (status = ANY (ARRAY['PENDING'::text, 'APPROVED'::text, 'REJECTED'::text])) |
| tbl_ingestion_attachments | chk_ingestion_attachment_promotion_link | (((canonical_photo_id IS NULL) AND (promoted_at IS NULL)) OR ((canonical_photo_id IS NOT NULL) AND (promoted_at IS NOT NULL) AND (promotion_role IS NOT NULL) AND ((status)::text = 'STAGED'::text))) |
| tbl_ingestion_attachments | chk_ingestion_attachment_promotion_role | ((promotion_role IS NULL) OR ((promotion_role)::text = ANY ((ARRAY['MEGASTRUCTURE_REFERENCE_IMAGE'::character varying, 'MEGASTRUCTURE_DOCUMENT'::character varying])::text[]))) |
| tbl_ingestion_attachments | chk_ingestion_attachment_removed_at | ((((status)::text = 'STAGED'::text) AND (removed_at IS NULL)) OR (((status)::text = 'REMOVED'::text) AND (removed_at IS NOT NULL))) |
| tbl_ingestion_attachments | chk_ingestion_attachment_removed_not_selected | (((status)::text <> 'REMOVED'::text) OR ((promotion_role IS NULL) AND (promotion_selected_at IS NULL) AND (canonical_photo_id IS NULL) AND (promoted_at IS NULL))) |
| tbl_ingestion_attachments | chk_ingestion_attachment_selection_time | (((promotion_role IS NULL) AND (promotion_selected_at IS NULL)) OR ((promotion_role IS NOT NULL) AND (promotion_selected_at IS NOT NULL))) |
| tbl_ingestion_attachments | chk_ingestion_attachment_size | (byte_size > 0) |
| tbl_ingestion_attachments | chk_ingestion_attachment_status | ((status)::text = ANY ((ARRAY['STAGED'::character varying, 'REMOVED'::character varying])::text[])) |