SchemaSpy Analysis of srdb.srdb - Constraints Generated by
SchemaSpy
20 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
area_areatype_fkey area.areatype management.mgmt Restrict delete 
assessment_assessmethod_fkey assessment.assessmethod assessmethod.methodshort Restrict delete 
assessment_assessorid_fkey assessment.assessorid assessor.assessorid Restrict delete 
assessment_recorder_fkey assessment.recorder recorder.nameinxls Restrict delete 
assessment_stockid_fkey assessment.stockid stock.stockid Restrict delete 
assessor_mgmt_fkey assessor.mgmt management.mgmt Restrict delete 
bioparams_bioid_fkey bioparams.bioid biometrics.biounique Restrict delete 
brptots_assessid_fkey brptots.assessid assessment.assessid Restrict delete 
brptots_bioid_fkey brptots.bioid biometrics.biounique Restrict delete 
brptots_tsid_fkey brptots.tsid tsmetrics.tsunique Restrict delete 
fishbasesaupcodes_scientificname_fkey fishbasesaupcodes.scientificname taxonomy.scientificname Restrict delete 
lmetostocks_lme_number_fkey lmetostocks.lme_number lmerefs.lme_number Restrict delete 
lmetostocks_stockid_fkey lmetostocks.stockid stock.stockid Restrict delete 
referencedoc_assessid_fkey referencedoc.assessid assessment.assessid Restrict delete 
referencedoc_risfield_fkey referencedoc.risfield risfields.risfield Restrict delete 
risfieldvalues_risfield_fkey risfieldvalues.risfield risfields.risfield Restrict delete 
stock_areaid_fkey stock.areaid area.areaid Restrict delete 
stock_tsn_fkey stock.tsn taxonomy.tsn Restrict delete 
timeseries_assessid_fkey timeseries.assessid assessment.assessid Restrict delete 
timeseries_tsid_fkey timeseries.tsid tsmetrics.tsunique Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected