Table marinedb.sea_star_plot_info_active
sea star plot information for active plots

 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
site_code char 6
sea_star_disease_count_sizes_active.site_code FK_sea_star_disease_count_sizes_active_plot_info R
sea_star_notes_active.site_code FK_sea_star_notes_active_sea_star_target R
marine_sites.site_code FK_sea_star_plot_info_active_site_code R
target_assemblage varchar 20
sea_star_disease_count_sizes_active.target_assemblage FK_sea_star_disease_count_sizes_active_plot_info R
sea_star_notes_active.target_assemblage FK_sea_star_notes_active_sea_star_target R
target_assemblages.target_assemblage FK_sea_star_plot_info_active_assemblage R
plot_code varchar 6
sea_star_disease_count_sizes_active.plot_code FK_sea_star_disease_count_sizes_active_plot_info R
count_size_plot_codes.plot_code FK_sea_star_plot_info_active_plot_code R

Table contained 312 rows at Thu Nov 06 11:53 PST 2025

Indexes:
Column(s) Type Sort Constraint Name
site_code + target_assemblage + plot_code Primary key Asc/Asc/Asc PRIMARY
target_assemblage Performance Asc FK_sea_star_plot_info_active_assemblage
plot_code Performance Asc FK_sea_star_plot_info_active_plot_code

Close relationships  within of separation: