Table marinedb.abhab_plot_areas
abalone habitat plot area crosswalk table used to indicate which plot areas should be used for calculations for years with no area data collected

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
marine_sites.site_code FK_abhab_plot_hab_cross_marine_sites R
abalone_plot_info.site_code FK_abhab_plot_area_cross_info R
target_assemblage varchar 8
target_assemblages.target_assemblage FK_abhab_plot_cross_target R
abalone_plot_info.target_assemblage FK_abhab_plot_area_cross_info R
plot_code varchar 6
abalone_plot_info.plot_code FK_abhab_plot_area_cross_info R
area_m2 int 10
adjusted_area_m2 int 10
survey_year year 0
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 161 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_abhab_plot_cross_target

Close relationships  within of separation: