Table marinedb.target_assemblages
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
target_assemblage varchar 20
abalone_plot_info.target_assemblage FK_abalone_plot_info_assemblage R
abalone_plot_info_active.target_assemblage FK_abalone_plot_info_active_assemblage R
abhab_plot_habitat_info.target_assemblage FK_abhab_plot_info_target R
abhab_plot_habitat_info_active.target_assemblage FK_abhab_plot_info_active_target R
abhab_plot_physical_info.target_assemblage FK_abhab_plot_phys_info_target R
abhab_plot_physical_info_active.target_assemblage FK_abhab_plot_phys_info_active_target R
abhab_plots_count_sizes.target_assemblage FK_abhabplot_count_sizes_target_assemblage R
abhab_plots_count_sizes_active.target_assemblage FK_abhabplot_count_sizes_active_target_assemblage R
abhab_segment_info.target_assemblage FK_abhab_seg_info_target R
abhab_segment_info_active.target_assemblage FK_abhab_seg_info_active_target R
abhab_segments_count_sizes.target_assemblage FK_abhab_count_sizes_target_assemblage R
abhab_segments_count_sizes_active.target_assemblage FK_abhab_count_sizes_active_target_assemblage R
checklist_entered.target_assemblage FK_checklist_entered_target_assemblage R
checklist_not_sampled.target_assemblage FK_checklist_not_sampled_target_assemblage R
checklist_quatraplots_active.target_assemblage FK_checklist_quatraplots_target_assemblage R
checklist_sampled.target_assemblage FK_checklist_sampled_target_assemblage R
field_event_data_collectors.target_assemblage FK_field_event_data_collectors_target R
field_event_data_collectors_active.target_assemblage FK_field_event_data_collectors_active_target R
form_methods.target_assemblage FK_form_methods_target_assemblage R
lottia_plot_info.target_assemblage FK_lottia_plot_info_assemblage R
lottia_plot_info_active.target_assemblage FK_lottia_plot_info_active_assemblage R
nps_entered.target_assemblage FK_nps_entered_target_assemblage R
photo_plot_info_active.target_assemblage FK_photo_plot_info__active_assemblage R
photo_plot_target_assemblages.target_assemblage FK_photo_plot_target_assemblages R
postelsia_info.target_assemblage FK_postelsia_info_assemblage R
postelsia_info_active.target_assemblage FK_postelsia_info_active_assemblage R
sea_star_plot_info.target_assemblage FK_sea_star_plot_info_assemblage R
sea_star_plot_info_active.target_assemblage FK_sea_star_plot_info_active_assemblage R
secondary_plot_info.target_assemblage FK_secondary_plot_info_assemblage R
secondary_plot_info_active.target_assemblage FK_secondary_plot_info_active_assemblage R
subsampled_plot_info.target_assemblage FK_subsampled_plot_info_assemblage R
target_assemblage_species.target_assemblage FK_assemblage_species_target_assemblage R
transect_info.target_assemblage FK_transect_info_assemblage R
transect_info_active.target_assemblage FK_transect_info_active_assemblage R
urchin_plot_info.target_assemblage FK_urchin_plot_info_assemblage R
urchin_plot_info_active.target_assemblage FK_urchin_plot_info_active_assemblage R
active_status enum 8 active
target_assemblage_description varchar 1000 see target_assemblage_species
create_date date 10
modify_date timestamp 19 current_timestamp()

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

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

Close relationships  within of separation: