Table marinedb.marine_sites
MARINe sites

 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
abalone_group_site_species.site_code FK_abalone_group_site_species_site_code R
abalone_group_site_species_active.site_code FK_abalone_group_site_species_active_site_code R
abalone_plot_info.site_code FK_abalone_plot_info_site_code R
abalone_plot_info_active.site_code FK_abalone_plot_info_active_site_code R
abhab_plot_areas.site_code FK_abhab_plot_hab_cross_marine_sites R
abhab_plot_habitat_info.site_code FK_abhab_plot_hab_info_marine_sites R
abhab_plot_habitat_info_active.site_code FK_abhab_plot_hab_info_active_marine_sites R
abhab_plot_physical_info.site_code FK_abhab_plot_phys_info_marine_sites R
abhab_plot_physical_info_active.site_code FK_abhab_plot_phys_info_active_marine_sites R
abhab_segment_boundaries.site_code FK_abhab_seg_gps_marine_sites R
abhab_segment_boundaries_active.site_code FK_abhab_seg_gps_active_marine_sites R
abhab_segment_info.site_code FK_abhab_seg_info_marine_sites R
abhab_segment_info_active.site_code FK_abhab_seg_info_active_marine_sites R
checklist_quatraplots_active.site_code FK_checklist_quatraplots_site_code R
checklist_supplemental_sitewide.site_code FK_checklist_supplemental_sitewide_site_code R
checklist_supplemental_sitewide_active.site_code FK_checklist_supplemental_sitewide_active_site_code R
field_events.site_code FK_field_events_site_code R
field_events_active.site_code FK_field_events_site_code_active R
form_methods.site_code FK_form_methods_site_code R
funding_history.site_code FK_funding_history_site_code R
lottia_plot_info.site_code FK_lottia_plot_info_site_code R
lottia_plot_info_active.site_code FK_lottia_plot_info_active_site_code R
marine_group_sites.site_code FK_marine_group_sites_site_code R
marine_subgroups.site_code FK_marine_subgroups_site_code R
photo_plot_info.site_code FK_photo_plot_info_site_code R
photo_plot_info_active.site_code FK_photo_plot_info_active_site_code R
photo_plot_photoquad.site_code FK_photo_plot_pq_summary_site_code R
photo_plot_photoquad_active.site_code FK_photo_plot_pq_summary_active_site_code R
postelsia_info.site_code FK_postelsia_info_site_code R
postelsia_info_active.site_code FK_postelsia_info_active_site_code R
restricted_site_reference.site_code FK_marine_sites_restricted R
sea_star_plot_info.site_code FK_sea_star_plot_info_site_code R
sea_star_plot_info_active.site_code FK_sea_star_plot_info_active_site_code R
secondary_plot_info.site_code FK_secondary_plot_info_site_code R
secondary_plot_info_active.site_code FK_secondary_plot_info_active_site_code R
site_not_sampled.site_code FK_site_not_sampled_site_code R
site_not_sampled_active.site_code FK_site_not_sampled_active_site_code R
subsampled_plot_info.site_code FK_subsampled_plot_info_site_code R
transect_info.site_code FK_transect_info_site_code R
transect_info_active.site_code FK_transect_info_active_site_code R
urchin_plot_info.site_code FK_urchin_plot_info_site_code R
urchin_plot_info_active.site_code FK_urchin_plot_info_active_site_code R
master_site_reference.site_code FK_marine_sites_master R
established_date date 10  √  null
ltm_latitude float 12,8
ltm_longitude float 10,5

Table contained 292 rows at Thu Nov 06 11:53 PST 2025

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

Close relationships  within of separation: