Table marinedb.marine_species
MARINe species

 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
species_code char 6
abalone_group_site_species.species_code FK_abalone_group_site_species_species_code R
abalone_group_site_species_active.species_code FK_abalone_group_site_species_active_species_code R
collection_species.species_code FK_collection_species_marine R
cryptochiton_group_species.species_code FK_cryptochiton_group_species_species_code R
cryptochiton_group_species_active.species_code FK_cryptochiton_group_species_species_active_code R
katharina_group_species.species_code FK_katharina_group_species_species_code R
katharina_group_species_active.species_code FK_katharina_group_species_species_active_code R
lottia_cover_group_species.species_code FK_lotcover_group_species_species_code R
lottia_cover_group_species_active.species_code FK_lotcover_group_species_active_species_code R
lottia_group_species.species_code FK_lottia_group_species_species_code R
lottia_group_species_active.species_code FK_lottia_active_group_species_species_code R
marine_species_lumping.species_code FK_marine_species_lump_species_code R
mobile_group_species.species_code FK_mobile_group_species_species_code R
mobile_group_species_active.species_code FK_mobile_group_species_active_species_code R
mussel_size_depth_group_species.species_code FK_md_group_species_species_code R
mussel_size_depth_group_species_active.species_code FK_md_group_species_species_active_code R
non_native_species.species_code FK_non_native_species_code R
photo_plot_core_species.species_code FK_photo_plot_core_species_code R
photo_plot_core_species_active.species_code FK_photo_plot_core_species_active_species_code R
photo_plot_group_species.species_code photo_plot_group_species_ibfk_2 R
photo_plot_group_species_active.species_code photo_plot_group_species_active_ibfk_5 R
photo_plot_layer_rules.bottom_layer FK_photo_plot_layer_rules_bottom_species_codes R
photo_plot_layer_rules.top_layer FK_photo_plot_layer_rules_top_species_codes R
photo_plot_layer_rules_onp.bottom_layer FK_photo_plot_layer_rules_onp_bottom_codes R
photo_plot_layer_rules_onp.top_layer FK_photo_plot_layer_rules_onp_top_codes R
photo_plot_supplemental_species.species_code FK_photo_plot_supplemental_species_code R
photo_plot_supplemental_species_active.species_code FK_photo_plot_supplemental_active_species_code R
postelsia_group_species.species_code FK_postelsia_group_species_species_code R
postelsia_group_species_active.species_code FK_postelsia_group_species_active_species_code R
recon_group_species.species_code FK_recon_group_species_species_code R
recon_notes.species_code FK_recon_notes_species R
recon_notes_active.species_code FK_recon_notes_active_species R
sea_star_group_species.species_code FK_sea_stars_group_species_species_code R
sea_star_group_species_active.species_code FK_sea_stars_group_species_species_active_code R
seagrass_cover_group_species.species_code FK_seacover_group_species_species_code R
seagrass_cover_group_species_active.species_code FK_seacover_group_species_species_active_code R
seagrass_thickness_group_species.species_code FK_seathick_group_species_species_code R
seagrass_thickness_group_species_active.species_code FK_seathick_group_species_species_active_code R
target_assemblage_species.species_code FK_assemblage_species_marine_species R
transect_core_species.species_code FK_transect_core_species_code R
transect_core_species_active.species_code FK_transect_core_species_active_code R
transect_group_species.species_code FK_transectt_group_species_species_code R
transect_group_species_active.species_code FK_transectt_group_species_species_active_code R
transect_supplemental_species.species_code FK_transect_supplemental_species_code R
transect_supplemental_species_active.species_code FK_transect_supplemental_species_active_code R
urchin_group_species.species_code FK_urchin_group_species_species_code R
urchin_group_species_active.species_code FK_urchin_group_species_active_species_code R
form_photo_plot_species_sort.species_code Implied Constraint R
marine_species_name varchar 75
active_status enum 8 active
biological_flag enum 5 TRUE
taxonomic_id varchar 100
taxonomic_source varchar 100
marine_species_definition varchar 500  √  null
create_date date 10
modify_date timestamp 19 current_timestamp()

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

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

Close relationships  within of separation: