SchemaSpy Analysis of sola_cs.opentenure - Constraints Generated by
SchemaSpy
26 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
claim_claimant_id_fk8 claim.claimant_id party.id Restrict delete 
claim_comment_claim_id_fk8 claim_comment.claim_id claim.id Cascade on delete 
claim_fk_type_code claim.type_code rrr_type.code Restrict delete 
claim_location_claim_id_fk8 claim_location.claim_id claim.id Cascade on delete 
claim_share_claim_id_fk12 claim_share.claim_id claim.id Cascade on delete 
claim_status_code_fk18 claim.status_code claim_status.code Restrict delete 
claim_uses_attachment_claim_id_fk126 claim_uses_attachment.claim_id claim.id Cascade on delete 
field_constraint_field_constraint_type_fkey field_constraint.field_constraint_type field_constraint_type.code Cascade on delete 
field_constraint_field_template_id_fkey field_constraint.field_template_id field_template.id Cascade on delete 
field_constraint_option_field_constraint_id_fkey field_constraint_option.field_constraint_id field_constraint.id Cascade on delete 
field_payload_field_type_fkey field_payload.field_type field_type.code Cascade on delete 
field_payload_field_value_type_fkey field_payload.field_value_type field_value_type.code Cascade on delete 
field_payload_section_element_payload_id_fkey field_payload.section_element_payload_id section_element_payload.id Cascade on delete 
field_template_field_type_fkey field_template.field_type field_type.code Cascade on delete 
field_template_section_template_id_fkey field_template.section_template_id section_template.id Cascade on delete 
fk_challenged_claim claim.challenged_claim_id claim.id Restrict delete 
fk_claim_land_use_type claim.land_use_code land_use_type.code Restrict delete 
fk_claim_rejection_reason_code claim.rejection_reason_code rejection_reason.code Restrict delete 
fk_document_type_code attachment.type_code administrative_source_type.code Restrict delete 
form_payload_claim_id_fkey form_payload.claim_id claim.id Cascade on delete 
form_payload_form_template_name_fkey form_payload.form_template_name form_template.name Cascade on delete 
party_for_claim_share_claim_id_fk43 party_for_claim_share.claim_share_id claim_share.id Cascade on delete 
party_for_claim_share_party_id_fk23 party_for_claim_share.party_id party.id Cascade on delete 
section_element_payload_section_payload_id_fkey section_element_payload.section_payload_id section_payload.id Cascade on delete 
section_payload_form_payload_id_fkey section_payload.form_payload_id form_payload.id Cascade on delete 
section_template_form_template_name_fkey section_template.form_template_name form_template.name Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected