SchemaSpy Analysis of popler_3.public - Constraints Generated by
SchemaSpy
18 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
biomass_table_site_in_project_biomass_fkey_fkey biomass_table.site_in_project_biomass_fkey site_in_project_table.site_in_project_key Cascade on delete 
biomass_table_taxa_biomass_fkey_fkey biomass_table.taxa_biomass_fkey taxa_table.taxa_table_key Cascade on delete 
climate_raw_table_stationid_fkey climate_raw_table.stationid climate_station_table.stationid Cascade on delete 
climate_station_table_lterid_fkey climate_station_table.lterid lter_table.lterid Restrict delete 
count_table_site_in_project_count_fkey_fkey count_table.site_in_project_count_fkey site_in_project_table.site_in_project_key Cascade on delete 
count_table_taxa_count_fkey_fkey count_table.taxa_count_fkey taxa_table.taxa_table_key Cascade on delete 
density_table_site_in_project_density_fkey_fkey density_table.site_in_project_density_fkey site_in_project_table.site_in_project_key Cascade on delete 
density_table_taxa_density_fkey_fkey density_table.taxa_density_fkey taxa_table.taxa_table_key Cascade on delete 
individual_table_site_in_project_individual_fkey_fkey individual_table.site_in_project_individual_fkey site_in_project_table.site_in_project_key Cascade on delete 
individual_table_taxa_individual_fkey_fkey individual_table.taxa_individual_fkey taxa_table.taxa_table_key Cascade on delete 
percent_cover_table_site_in_project_percent_cover_fkey_fkey percent_cover_table.site_in_project_percent_cover_fkey site_in_project_table.site_in_project_key Cascade on delete 
percent_cover_table_taxa_percent_cover_fkey_fkey percent_cover_table.taxa_percent_cover_fkey taxa_table.taxa_table_key Cascade on delete 
project_table_lter_project_fkey_fkey project_table.lter_project_fkey lter_table.lterid Restrict delete 
site_in_project_table_project_table_fkey_fkey site_in_project_table.project_table_fkey project_table.proj_metadata_key Restrict delete 
site_in_project_table_study_site_table_fkey_fkey site_in_project_table.study_site_table_fkey study_site_table.study_site_key Restrict delete 
study_site_table_lter_table_fkey_fkey study_site_table.lter_table_fkey lter_table.lterid Restrict delete 
taxa_accepted_table_taxa_original_fkey_fkey taxa_accepted_table.taxa_original_fkey taxa_table.taxa_table_key Cascade on delete 
taxa_table_site_in_project_taxa_key_fkey taxa_table.site_in_project_taxa_key site_in_project_table.site_in_project_key Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected