Table marinedb.monitoring_groups
designated monitoring groups

 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
group_code varchar 8
abalone_group_site_species.group_code FK_abalone_group_site_species_group_code R
abalone_group_site_species_active.group_code FK_abalone_group_site_species_active_group_code R
cryptochiton_group_species.group_code FK_cryptochiton_group_species_group_code R
cryptochiton_group_species_active.group_code FK_cryptochiton_group_species_active_group_code R
field_events.group_code FK_field_events_group_code R
field_events_active.group_code FK_field_events_group_code_active R
katharina_group_species.group_code FK_katharina_group_species_group_code R
katharina_group_species_active.group_code FK_katharina_group_species_active_group_code R
lottia_cover_group_species.group_code FK_lotcover_group_species_group_code R
lottia_cover_group_species_active.group_code FK_lotcover_group_species_active_group_code R
lottia_group_species.group_code FK_lottia_group_species_group_code R
lottia_group_species_active.group_code FK_lottia_active_group_species_group_code R
marine_group_sites.group_code FK_marine_group_sites_group_code R
mobile_group_species.group_code FK_mobile_group_species_group_code R
mobile_group_species_active.group_code FK_mobile_group_species_active_group_code R
mussel_size_depth_group_species.group_code FK_md_group_species_group_code R
mussel_size_depth_group_species_active.group_code FK_md_group_species_active_group_code R
photo_plot_groups.group_code FK_photo_plot_monitoring_groups R
photo_plot_supplemental_species.group_code FK_photo_plot_supplemental_group_code R
photo_plot_supplemental_species_active.group_code FK_photo_plot_supplemental_active_group_code R
postelsia_group_species.group_code FK_postelsia_group_species_group_code R
postelsia_group_species_active.group_code FK_postelsia_group_species_active_group_code R
recon_group_species.group_code FK_recon_group_species_group_code R
sea_star_group_species.group_code FK_sea_stars_group_species_group_code R
sea_star_group_species_active.group_code FK_sea_stars_group_species_active_group_code R
seagrass_cover_group_species.group_code FK_seacover_group_species_group_code R
seagrass_cover_group_species_active.group_code FK_seacover_group_species_active_group_code R
seagrass_thickness_group_species.group_code FK_seathick_group_species_group_code R
seagrass_thickness_group_species_active.group_code FK_seathick_group_species_active_group_code R
site_not_sampled.group_code FK_site_not_sampled_group_code R
site_not_sampled_active.group_code FK_site_not_sampled_active_group_code R
transect_group_species_active.group_code FK_transect_group_species_active_group_code R
transect_groups.group_code FK_transect_monitoring_groups R
transect_supplemental_species.group_code FK_transect_supplemental_group_code R
transect_supplemental_species_active.group_code FK_transect_supplemental_group_active_code R
urchin_group_species.group_code FK_urchin_group_species_group_code R
urchin_group_species_active.group_code FK_urchin_group_species_active_group_code R
marine_groups.group_code FK_monitoring_marine_groups R
create_date date 10

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

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

Close relationships  within of separation: