Table marinedb.count_size_plot_codes
MARINe count size plot codes

 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
plot_code varchar 6
abalone_plot_info.plot_code FK_abalone_plot_info_plot_code R
abalone_plot_info_active.plot_code FK_abalone_plot_info_active_plot_code R
abhab_plot_habitat_info.plot_code Implied Constraint R
abhab_plot_habitat_info_active.plot_code Implied Constraint R
abhab_plot_physical_info.plot_code Implied Constraint R
abhab_plot_physical_info_active.plot_code Implied Constraint R
lottia_plot_info.plot_code FK_lottia_plot_info_plot_code R
lottia_plot_info_active.plot_code FK_lottia_plot_info_active_plot_code R
postelsia_info.plot_code FK_postelsia_info_plot_code R
postelsia_info_active.plot_code FK_postelsia_info_active_plot_code R
sea_star_plot_info.plot_code FK_sea_star_plot_info_plot_code R
sea_star_plot_info_active.plot_code FK_sea_star_plot_info_active_plot_code R
urchin_plot_info.plot_code FK_urchin_plot_info_plot_code R
urchin_plot_info_active.plot_code FK_urchin_plot_info_active_plot_code R
create_date date 10

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

Indexes:
Column(s) Type Sort Constraint Name
plot_code Primary key Asc PRIMARY

Close relationships  within of separation: