Table marinedb.target_assemblage_species
species in target assemblages

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
species_code char 6
marine_species.species_code FK_assemblage_species_marine_species R
target_assemblage varchar 20
target_assemblages.target_assemblage FK_assemblage_species_target_assemblage R
public enum 4 yes
create_date date 10

Table contained 35 rows at Thu Apr 03 16:08 PDT 2025

Indexes:
Column(s) Type Sort Constraint Name
species_code + target_assemblage Primary key Asc/Asc PRIMARY
target_assemblage Performance Asc FK_assemblage_species_target_assemblage

Close relationships  within of separation: