SchemaSpy Analysis of marinedb Generated by
SchemaSpy
Generated by SchemaSpy on Thu Nov 06 11:53 PST 2025
Database Type: MySQL - 5.5.5-10.5.27-MariaDB SourceForge.net

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table Children Parents Columns Rows Comments
abalone_count_sizes 14 14 101,247 abalone counts and sizes data
abalone_count_sizes_active 14 14 1,378 abalone counts and sizes data entry
abalone_empty_shells 15 15 1,648 abalone empty shell data
abalone_empty_shells_active 15 15 138 abalone empty shell data entry
abalone_group_site_species 6 3 6 281 abalone group, site, and species junction table
abalone_group_site_species_active 6 3 3 283 active abalone group, site, and species junction table
abalone_habitat_sites 1 4 0 abalone habitat sites
abalone_nn_codes 6 4 6 MARINe abalone nearest neighbor codes
abalone_notes 6 8 333 abalone notes
abalone_notes_active 6 8 17 abalone notes active
abalone_plot_info 11 3 9 425 abalone plot information
abalone_plot_info_active 8 3 3 374 abalone plot information for active plots
abalone_shell_codes 2 3 3 MARINe abalone empty shell codes codes
abalone_size_bins 8 6 41 the values that may be used for abalone size
abhab_habitat_codes 4 3 4 MARINe abalone habitat codes
abhab_not_sampled 9 8 0 checklist for tracking abalone habitat segments not sampled
abhab_not_sampled_active 9 8 0 checklist for tracking abalone habitat segments not sampled for data entry
abhab_notes 4 8 76 abalone habitat notes
abhab_notes_active 4 8 4 abalone habitat notes active
abhab_plot_areas 5 8 161 abalone habitat plot area crosswalk table used to indicate which plot areas should be used for calculations for years with no area data collected
abhab_plot_habitat_info 6 19 370 abalone habitat plot habitat info
abhab_plot_habitat_info_active 6 19 3 abalone habitat plot habitat info data entry
abhab_plot_physical_info 4 10 177 abalone habitat plot physical info
abhab_plot_physical_info_active 4 10 1 abalone habitat plot physical info data entry
abhab_plots_count_sizes 13 15 1,947 abalone habitat plot counts and sizes
abhab_plots_count_sizes_active 13 15 33 abalone habitat plot counts and sizes data entry
abhab_plots_not_sampled 4 8 3 checklist for tracking abalone habitat plots not sampled
abhab_plots_not_sampled_active 7 8 0 checklist for tracking abalone habitat plots not sampled for data entry
abhab_plots_sampled 4 8 323 checklist for tracking abalone habitat plots sampled
abhab_plots_sampled_active 7 8 3 checklist for tracking abalone habitat plots sampled for data entry
abhab_rock_type_codes 4 3 15 the rock type codes for abalone habitat surveys
abhab_sampled 9 8 418 checklist for tracking abalone habitat segments sampled
abhab_sampled_active 9 8 157 checklist for tracking abalone habitat segments sampled for data entry
abhab_segment_boundaries 6 10 1,383 abalone habitat segment boundary coordinates
abhab_segment_boundaries_active 6 10 125 abalone habitat segment boundary coordinates data entry
abhab_segment_ids 10 3 70 list of segment ids that can be used for abalone habitat surveys
abhab_segment_info 12 9 26 504 abalone habitat segment physical info
abhab_segment_info_active 12 9 26 157 abalone habitat segment physical info data entry
abhab_segments_count_sizes 14 15 6,506 abalone habitat counts and sizes
abhab_segments_count_sizes_active 14 15 553 abalone habitat counts and sizes data entry
abhab_substrate_codes 4 3 11 the substrate codes for abalone habitat surveys
biodiversity_sites 1 8 193 biodiversity sites
bird_codes 2 3 20 the bird codes for the species counted during bird and count
bird_count_values 2 6 145 the values that may be used for bird counts
checklist_codes_active 3 2 codes indicating if a site has been sampled or not for checklist data entry
checklist_entered 6 8 77,335 checklist for sampled plots where data have been entered and verified
checklist_entered_active 7 8 2,935 checklist for sampled plots where data have been entered but not verified
checklist_not_sampled 6 8 28,732 checklist for tracking not sampled plots for verified data
checklist_not_sampled_active 7 8 5,898 checklist for tracking not sampled plots for data entry
checklist_quatraplots_active 20 4 4 6,228 List of plots for all target assemblages for data entry
checklist_sampled 6 8 85,232 checklist for tracking sampled plots for verified data
checklist_sampled_active 7 8 2,820 checklist for tracking sampled plots for data entry
checklist_supplemental_sitewide 2 5 833 other activities done at the site that are not plot specific
checklist_supplemental_sitewide_active 2 2 845 other activities done at the site that are not plot specific for data entry
cit_sites 1 4 90 citizen science sites
collection_count_values 2 6 118 the values that may be used for species collection counts
collection_projects 2 5 7 list of projects that have associated species collections
collection_qualifiers 2 1 1 2 MARINe collection qualifiers
collection_species 2 1 3 20 list of species that may be collected
collection_types 2 3 6 the values that may be used for the type of species collection
condition_codes 36 4 5 condition codes for field log entries
count_qualifiers 20 1 1 2 MARINe count qualifiers
count_size_methods 20 1 1 13 MARINe count size methods
count_size_plot_codes 10 2 45 MARINe count size plot codes
cryptochiton_count_sizes 13 14 1,474 cryptochiton counts and sizes data
cryptochiton_count_sizes_active 13 14 403 cryptochiton counts and sizes data
cryptochiton_group_species 2 2 5 4 cryptochiton group and species junction table
cryptochiton_group_species_active 2 2 2 4 cryptochiton group and species junction table for data entry
cryptochiton_size_bins 2 6 32 the values that may be used for cryptochiton size
database_changes 4 272 production database changes tracking table
field_event_bird_counts 5 7 6,719 bird counts from the field log
field_event_bird_counts_active 5 7 237 bird counts from the field log data entry
field_event_collections 12 12 51 species collections from the field log
field_event_collections_active 12 12 2 species collections from the field log data entry
field_event_conditions 18 27 3,087 field event conditions
field_event_conditions_active 18 27 189 field event conditions data entry
field_event_data_collectors 7 9 36,368 field event data collectors
field_event_data_collectors_active 7 9 922 field event data collectors data entry
field_event_mammal_counts 5 7 2,019 mammal counts from the field log
field_event_mammal_counts_active 5 7 137 mammal counts from the field log data entry
field_event_mammal_disturbance 7 12 206 mammal disturbance info from the field log
field_event_mammal_disturbance_active 7 12 56 mammal disturbance info from the field log data entry
field_event_non_native 5 7 7,335 non native invasive species presence observations from the field log
field_event_non_native_active 5 7 656 non native invasive species presence observations from the field log data entry
field_event_participants 8 4 6 19,555 field events participants
field_event_participants_active 8 4 6 1,048 field events participants data entry
field_event_recon 10 11 28,696 field event reconnaisance data from the field log
field_event_recon_active 10 11 0 field event reconnaisance data entry from the field log
field_events 162 4 8 6,544 field events log
field_events_active 147 4 8 308 field events data entry
form_method_codes 2 15 MARINe form method codes and descriptions
form_methods 3 3 614 List of methods by site and target assemblage; used for data entry
form_photo_plot_species_sort 2 122 the sort order for species used in the photo plot web entry form
form_postelsia_site_plot_location_meter 4 6 871 reference table for postelsia web data entry
form_transect_species_sort 2 58 the sort order for species used in the photo plot web entry form
funding_groups 1 1 2 27 MARINe funding groups
funding_history 3 8 304 history of funding by site and funding group
funding_levels 1 3 5 list of types of funding
gps_boundary_codes 2 4 4 MARINe site location types
gps_location_codes 3 0 MARINe site location types
katharina_count_sizes 13 14 7,433 katharina counts and sizes data
katharina_count_sizes_active 13 14 1,101 katharina counts and sizes data
katharina_group_species 2 2 5 8 katharina group and species junction table
katharina_group_species_active 2 2 2 7 katharina group and species junction table for data entry
katharina_size_bins 2 6 19 the values that may be used for katharina size
logger_codes 2 6 6 temperature data logger and type
logger_status_codes 2 4 5 temperature data logger status codes used in temperature log
lottia_count_sizes 12 13 231,304 lottia counts and sizes data
lottia_count_sizes_active 12 13 507 lottia counts and sizes data entry
lottia_cover 9 10 1,930 lottia plot mussel and pollicipes cover data
lottia_cover_active 9 10 4 lottia plot mussel and pollicipes cover data entry
lottia_cover_group_species 2 2 5 9 lottia plot mussel and pollicipes cover group and species junction table
lottia_cover_group_species_active 2 2 2 9 lottia plot mussel and pollicipes cover group and species junction table for data entry
lottia_group_species 2 2 5 12 lottia group and species junction table
lottia_group_species_active 2 2 2 11 active lottia group and species junction table
lottia_notes 6 8 211 lottia notes
lottia_notes_active 6 8 3 lottia notes active
lottia_plot_info 5 3 9 397 lottia plot information
lottia_plot_info_active 5 3 3 361 lottia plot information for active plots
lottia_size_bins 2 6 122 the values that may be used for lottia size
mammal_codes 4 3 9 the mammal codes for the species counted during mammal and c
mammal_count_values 4 6 110 the values that may be used for mammal counts
mammal_disturbance_details 2 3 6 list of disturbance details for mammal disturbance
mammal_disturbance_levels 2 5 4 list of disturbance levels for mammal disturbance
marine_common_seasons 4 8 177 MARINe common seasons
marine_group_sites 2 5 335 marine group sites
marine_groups 3 6 80 MARINe groups
marine_lumping_codes 10 5 81 MARINe lumping codes table
marine_personnel 4 8 1,616 MARINe personnel
marine_sites 42 1 4 292 MARINe sites
marine_species 47 9 273 MARINe species
marine_species_lumping 11 20 259 MARINe species lumping reference table
marine_subgroups 2 2 47 MARINe subgroups
master_site_reference 9 28 440 master site reference for all survey sites
method_codes 5 4 31 MARINe method codes
migrations 3 0
mobile_group_species 2 5 0 MARINe mobile invertebrate species by group
mobile_group_species_active 2 2 0 active mobile group and species junction table
mobile_size_bins 6 0 the values that may be used for mobile species sizes
monitoring_groups 37 1 2 21 designated monitoring groups
mussel_depth_numbers 2 4 10 MARINe mussel depth number values
mussel_depth_qualifiers 2 1 1 2 MARINe mussel depth qualifiers
mussel_depths 11 12 21,341 mussel depth data
mussel_depths_active 11 12 2,836 mussel depth data entry
mussel_layer_codes 2 4 3 MARINe mussel size layer values
mussel_size_depth_bins 4 6 32 the values that may be used for mussel size and depth measurements
mussel_size_depth_group_species 2 2 5 9 MARINe mussel depth species by group
mussel_size_depth_group_species_active 2 2 2 9 mussel depth group and species junction table for data entry
mussel_size_qualifiers 2 1 1 2 MARINe mussel size qualifiers
mussel_sizes 11 13 23,412 mussel size data
mussel_sizes_active 11 13 2,929 mussel size data entry
mussel_watch_sites 1 4 0 mussel watch sites
non_native_abundance_codes 2 3 3 abundance codes for field log non native invasive species entries
non_native_species 2 1 7 7 MARINe non native invasive species list
nps_entered 6 8 41,419 checklist for nps (CHIS, ONP, CABR) sampled plots where data have been entered and verified
oil_spill_sites 1 2 39 oil spill sites
other_sites 1 5 0 other sites
password_resets 3 3
photo_plot_core_species 1 4 52 MARINe photo plot core species
photo_plot_core_species_active 1 1 51 MARINe photo plot core species active
photo_plot_group_species 14 2 2 1,709 photo plots group and species junction table
photo_plot_group_species_active 9 2 2 1,274 photo plots group and species active junction table
photo_plot_groups 2 1 1 21 designated monitoring groups that sample photo plots
photo_plot_groups_active 1 1 1 18 designated monitoring groups that sample photo plots for active data
photo_plot_info 20 3 10 2,352 photo plots information
photo_plot_info_active 14 3 3 2,172 photo plots information for active plots
photo_plot_layer_codes 5 90 photo plot layer codes
photo_plot_layer_rules 2 6 2,580 photo plot layer rules table to compare with historic photo
photo_plot_layer_rules_onp 2 6 366 photo plot layer rules table for onp data to compare with historic photo plots
photo_plot_layers 12 13 1,143,408 photo plot layers data table
photo_plot_layers_active 12 13 54,747 photo plot layers data entry
photo_plot_layers_onp 11 13 11,299 NCCN/ONP photo plot layers data table
photo_plot_layers_summary 10 10 112,514 photo plot layers summary data compatible with non layered p
photo_plot_layers_summary_active 10 10 4,381 photo plot layers summary data compatible with non layered p
photo_plot_methods 12 1 1 9 MARINe photo plot methods
photo_plot_notes 6 8 5,372 photo_plot notes
photo_plot_notes_active 6 8 0 photo_plot notes active
photo_plot_photoquad 4 9 1,475 verified photo plot data uploaded from photoquad after reformatting
photo_plot_photoquad_active 4 9 137 photo plot data uploaded from photoquad after reformatting
photo_plot_photoquad_summary 10 10 1,686 verified photo plot summary data entered using photoquad program
photo_plot_photoquad_summary_active 10 10 148 photo plot summary data entered using photoquad program
photo_plot_quadrat_codes 2 2 510 MARINe photo plot quadrat codes
photo_plot_quadrat_locations 2 3 100 MARINe quadrat locations
photo_plot_qualifiers 10 1 1 3 MARINe photo plot qualifiers
photo_plot_supplemental_species 2 5 739 MARINe photo plot supplemental species
photo_plot_supplemental_species_active 2 2 459 MARINe photo plot supplemental species active
photo_plot_target_assemblages 2 1 2 20 photo plot target assemblages
photo_plot_understory_layers_summary 10 10 105,575 photo plot understory layers summary data
photo_plots 10 11 2,475,116 photo plots data
photo_plots_active 10 11 6,827 photo plots data entry table
photo_target_codes 2 1 3 20 photo plot target assemblage codes used in photos
postelsia 11 14 13,011 postelsia data
postelsia_active 11 14 514 postelsia data entry table
postelsia_direction_codes 3 3 4 MARINe postelsia direction codes
postelsia_group_species 2 2 5 0 postelsia group and species junction table
postelsia_group_species_active 2 2 2 0 postelsia active group and species junction table
postelsia_info 8 3 15 37 postelsia plot information
postelsia_info_active 5 3 3 37 active postelsia plot information
postelsia_methods 2 1 1 0 MARINe postelsia methods
postelsia_notes 6 8 20 postelsia notes
postelsia_notes_active 6 8 0 postelsia notes data entry
postelsia_qualifiers 2 1 1 2 MARINe postelsia qualifiers
qualifier_codes 8 4 8 MARINe qualifier codes
quatraplot_codes 29 2 535 list of quadrat transect and plot codes
recon_abundance_codes 2 3 7 abundance codes for field log recon entries
recon_condition_codes 6 3 6 condition codes for field log recon entries
recon_group_species 2 2 5 406 MARINe recon species list
recon_group_species_active 2 2 369 MARINe recon species list active data entry
recon_notes 4 7 1,488 recon notes
recon_notes_active 4 7 0 recon notes active
recon_recruitment_codes 2 3 5 recruitment codes for field log recon entries
reef_sand_people_count_values 4 6 106 the values that may be used for humans on reef and sand in f
restricted_site_reference 1 30 5 site reference for restricted survey sites; location and site names should not be shared without permission
role_codes 2 3 2 MARINe roles
sea_star_color_count_sizes 12 14 29,950 sea stars color data
sea_star_counts 10 11 1,956 sea stars counts data
sea_star_disease_codes 2 4 8 MARINe sea star disease codes
sea_star_disease_count_sizes 13 14 34,035 sea star counts and sizes data
sea_star_disease_count_sizes_active 13 14 4,658 sea star counts and sizes data entry
sea_star_group_species 6 2 5 153 sea stars group and species junction table
sea_star_group_species_active 2 2 2 91 sea stars group and species junction table for data entry
sea_star_notes 6 8 484 sea_star notes
sea_star_notes_active 6 8 8 sea_star notes active
sea_star_plot_info 11 3 9 351 sea star plot information
sea_star_plot_info_active 5 3 3 312 sea star plot information for active plots
sea_star_size_bins 3 6 35 the values that may be used for sea star size
seagrass_conditions 8 10 667 seagrass cover estimate conditions
seagrass_conditions_active 8 10 8 seagrass cover estimate conditions data entry
seagrass_cover 9 10 3,169 seagrass cover data
seagrass_cover_active 9 10 68 seagrass cover data entry
seagrass_cover_group_species 2 2 5 10 seagrass cover group and species junction table
seagrass_cover_group_species_active 2 2 2 9 seagrass cover group and species junction table for data entry
seagrass_thickness 9 11 16,639 seagrass thickness data
seagrass_thickness_active 7 11 255 seagrass thickness data entry
seagrass_thickness_group_species 1 2 5 5 seagrass thickness group and species junction table
seagrass_thickness_group_species_active 1 2 2 5 seagrass thickness group and species junction table for data entry
secondary_plot_info 32 4 7 3,017 plot information for secondary protocols done in existing plots
secondary_plot_info_active 32 4 4 1,681 plot information for secondary protocols done in active existing plots for data entry
site_not_sampled 3 6 92 MARINe sites that were not sampled where marine_sample_type would have been standard
site_not_sampled_active 3 6 2 MARINe sites that were not sampled where marine_sample_type would have been standard for active data
size_qualifiers 19 1 1 4 MARINe size qualifiers
subsampled_plot_info 5 8 22 subsampled plot information for plots where a multiplier should be used for calculating means
survey_type_codes 16 5 41 survey type codes
target_assemblage_species 2 4 35 species in target assemblages
target_assemblages 37 5 30 target assemblages
temperature_log 8 11 22 temperature logger by date and status
temperature_log_active 5 11 25 temperature logger by date and status data entry
temperature_loggers 3 1 7 88 temperature loggers
temperature_loggers_active 1 7 8 temperature loggers data entry
temperature_sites 4 1 3 110 sites where temperature loggers are deployed
tided_temperature_utc 2 14 0 temperature data combined with tides and detided value used for daily seawater means from loggers in Coordinated Universal Time (UTC)
tided_temperature_utc_active 2 14 10,562,539 temperature data combined with tides and detided value used for daily seawater means from loggers in Coordinated Universal Time (UTC) for new data loading
transect_codes 2 2 16 MARINe transect codes
transect_core_species 1 4 24 MARINe transect core species
transect_core_species_active 1 1 24 MARINe active transect core species
transect_group_species 2 2 2 701 transect group and species junction table
transect_group_species_active 2 3 2 356 transect active group and species junction table
transect_groups 2 1 1 13 designated monitoring groups that sample transects
transect_groups_active 1 1 1 10 designated monitoring groups that sample transects for active data
transect_info 5 3 9 196 transects information
transect_info_active 5 3 3 183 active transects information
transect_methods 2 1 1 4 MARINe transect methods
transect_notes 6 8 1,720 transect notes
transect_notes_active 6 8 0 transect notes active
transect_qualifiers 2 1 1 2 MARINe transect qualifiers
transect_supplemental_species 2 5 285 MARINe transect supplemental species
transect_supplemental_species_active 2 2 116 MARINe active transect supplemental species
transects 10 11 144,236 transects data
transects_active 10 11 1,551 transects data entry table
urchin_count_sizes 13 14 8,400 urchin counts and sizes data
urchin_count_sizes_active 13 14 1,237 urchin counts and sizes data entry
urchin_disease_codes 2 4 5 MARINe urchin disease codes
urchin_group_species 2 2 5 27 urchin group and species junction table
urchin_group_species_active 2 2 2 27 urchin group and species junction table for data entry
urchin_notes 6 8 206 urchin notes
urchin_notes_active 6 8 0 urchin notes active
urchin_plot_info 5 3 9 283 urchin plot information
urchin_plot_info_active 5 3 3 263 urchin plot information for active plots
urchin_size_bins 2 6 11 the values that may be used for urchin size
users 7 42
vouchered_sites 1 4 0 vouchered sites
wind_speeds 2 4 5 wind speed codes for field log entries
zonetype 2 4 8 temperature data zone and type
           
283 Tables     1,992 15,560,679  
0 Views     0