Table marinedb.abhab_plot_habitat_info
abalone habitat plot habitat info

 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
field_events.site_code FK_abhab_plot_hab_info_fe R
marine_sites.site_code FK_abhab_plot_hab_info_marine_sites R
survey_date date 10
field_events.survey_date FK_abhab_plot_hab_info_fe R
group_code varchar 8
field_events.group_code FK_abhab_plot_hab_info_fe R
target_assemblage varchar 8
target_assemblages.target_assemblage FK_abhab_plot_info_target R
plot_code varchar 6
count_size_plot_codes.plot_code Implied Constraint R
start_time time 8
end_time time 8
percent_good int 10
percent_moderate int 10
percent_poor int 10
percent_good_nobio varchar 3 NA
percent_moderate_nobio varchar 3 NA
percent_poor_nobio varchar 3 NA
area_m2 int 10
adjusted_area_m2 int 10
percent_abs_removable varchar 3 NA
mussel_encroachment varchar 3
condition_codes.condition_code FK_abhab_plot_info_encroach R
create_date date 10
modify_date timestamp 19 current_timestamp()

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

Indexes:
Column(s) Type Sort Constraint Name
site_code + survey_date + group_code + plot_code Primary key Asc/Asc/Asc/Asc PRIMARY
mussel_encroachment Performance Asc FK_abhab_plot_info_encroach
target_assemblage Performance Asc FK_abhab_plot_info_target

Close relationships  within of separation: