Table marinedb.field_events
field events log

 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_count_sizes.site_code FK_abalone_count_sizes_field_event R
abalone_empty_shells.site_code FK_abalone_empty_field_event R
abalone_notes.site_code FK_abalone_notes_field_event R
abhab_not_sampled.site_code FK_abhab_notsampled_event R
abhab_notes.site_code FK_abhab_notes_field_event R
abhab_plot_habitat_info.site_code FK_abhab_plot_hab_info_fe R
abhab_plots_count_sizes.site_code FK_abhabplot_count_sizes_field_event R
abhab_plots_not_sampled.site_code FK_abhab_plot_notsampled_event R
abhab_plots_sampled.site_code FK_abhab_plot_sampled_event R
abhab_sampled.site_code FK_abhab_sampled_event R
abhab_segment_boundaries.site_code FK_abhab_seg_gps_fe R
abhab_segment_info.site_code FK_abhab_seg_info_fe R
abhab_segments_count_sizes.site_code FK_abhab_count_sizes_field_event R
checklist_entered.site_code FK_checklist_entered_event R
checklist_not_sampled.site_code FK_checklist_not_sampled_event R
checklist_sampled.site_code FK_checklist_sampled_event R
cryptochiton_count_sizes.site_code FK_cry_count_sizes_field_event R
field_event_bird_counts.site_code FK_field_event_bird_counts_field_events R
field_event_collections.site_code FK_field_event_collection_field_events R
field_event_conditions.site_code FK_field_event_conditions_field_event R
field_event_mammal_counts.site_code FK_field_event_mammal_counts_field_events R
field_event_mammal_disturbance.site_code FK_field_event_mammald_field_events R
field_event_non_native.site_code FK_field_event_non_native_field_events R
field_event_participants.site_code FK_field_events_participants R
field_event_recon.site_code FK_field_event_recon_field_event R
katharina_count_sizes.site_code FK_kat_count_sizes_field_event R
lottia_count_sizes.site_code FK_lottia_count_sizes_field_event R
lottia_cover.site_code FK_lc_field_event R
lottia_notes.site_code FK_lottia_notes_field_event R
mussel_depths.site_code FK_md_field_event R
mussel_sizes.site_code FK_ms_field_event R
nps_entered.site_code FK_nps_entered_event R
photo_plot_layers.site_code FK_photo_plot_layers_field_event R
photo_plot_layers_onp.site_code FK_photo_plot_layers_onp_field_event R
photo_plot_layers_summary.site_code FK_photo_plot_layers_summary_field_event R
photo_plot_notes.site_code FK_photo_plot_notes_field_event R
photo_plot_photoquad_summary.site_code FK_photo_plot_pq_summary_field_event R
photo_plot_understory_layers_summary.site_code FK_photo_plot_ulayers_summary_field_event R
photo_plots.site_code FK_photo_plot_field_event R
postelsia.site_code FK_postelsia_field_events R
postelsia_notes.site_code FK_postelsia_notes_field_event R
recon_notes.site_code FK_recon_notes_field_event R
sea_star_color_count_sizes.site_code FK_sea_star_colors_field_event R
sea_star_counts.site_code FK_sea_star_count_field_event R
sea_star_disease_count_sizes.site_code FK_sea_star_disease_count_sizes_field_event R
sea_star_notes.site_code FK_sea_star_notes_field_event R
seagrass_conditions.site_code FK_seagrass_conditions_field_event R
seagrass_cover.site_code FK_sc_field_event R
seagrass_thickness.site_code FK_st_field_event R
transect_notes.site_code FK_transect_notes_field_event R
transects.site_code FK_transects_field_event R
urchin_count_sizes.site_code FK_urchin_count_sizes_field_event R
urchin_notes.site_code FK_urchin_notes_field_event R
marine_sites.site_code FK_field_events_site_code R
the site code
survey_date date 10
abalone_count_sizes.survey_date FK_abalone_count_sizes_field_event R
abalone_empty_shells.survey_date FK_abalone_empty_field_event R
abalone_notes.survey_date FK_abalone_notes_field_event R
abhab_not_sampled.survey_date FK_abhab_notsampled_event R
abhab_notes.survey_date FK_abhab_notes_field_event R
abhab_plot_habitat_info.survey_date FK_abhab_plot_hab_info_fe R
abhab_plots_count_sizes.survey_date FK_abhabplot_count_sizes_field_event R
abhab_plots_not_sampled.survey_date FK_abhab_plot_notsampled_event R
abhab_plots_sampled.survey_date FK_abhab_plot_sampled_event R
abhab_sampled.survey_date FK_abhab_sampled_event R
abhab_segment_boundaries.survey_date FK_abhab_seg_gps_fe R
abhab_segment_info.survey_date FK_abhab_seg_info_fe R
abhab_segments_count_sizes.survey_date FK_abhab_count_sizes_field_event R
checklist_entered.survey_date FK_checklist_entered_event R
checklist_not_sampled.survey_date FK_checklist_not_sampled_event R
checklist_sampled.survey_date FK_checklist_sampled_event R
cryptochiton_count_sizes.survey_date FK_cry_count_sizes_field_event R
field_event_bird_counts.survey_date FK_field_event_bird_counts_field_events R
field_event_collections.survey_date FK_field_event_collection_field_events R
field_event_conditions.survey_date FK_field_event_conditions_field_event R
field_event_mammal_counts.survey_date FK_field_event_mammal_counts_field_events R
field_event_mammal_disturbance.survey_date FK_field_event_mammald_field_events R
field_event_non_native.survey_date FK_field_event_non_native_field_events R
field_event_participants.survey_date FK_field_events_participants R
field_event_recon.survey_date FK_field_event_recon_field_event R
katharina_count_sizes.survey_date FK_kat_count_sizes_field_event R
lottia_count_sizes.survey_date FK_lottia_count_sizes_field_event R
lottia_cover.survey_date FK_lc_field_event R
lottia_notes.survey_date FK_lottia_notes_field_event R
mussel_depths.survey_date FK_md_field_event R
mussel_sizes.survey_date FK_ms_field_event R
nps_entered.survey_date FK_nps_entered_event R
photo_plot_layers.survey_date FK_photo_plot_layers_field_event R
photo_plot_layers_onp.survey_date FK_photo_plot_layers_onp_field_event R
photo_plot_layers_summary.survey_date FK_photo_plot_layers_summary_field_event R
photo_plot_notes.survey_date FK_photo_plot_notes_field_event R
photo_plot_photoquad_summary.survey_date FK_photo_plot_pq_summary_field_event R
photo_plot_understory_layers_summary.survey_date FK_photo_plot_ulayers_summary_field_event R
photo_plots.survey_date FK_photo_plot_field_event R
postelsia.survey_date FK_postelsia_field_events R
postelsia_notes.survey_date FK_postelsia_notes_field_event R
recon_notes.survey_date FK_recon_notes_field_event R
sea_star_color_count_sizes.survey_date FK_sea_star_colors_field_event R
sea_star_counts.survey_date FK_sea_star_count_field_event R
sea_star_disease_count_sizes.survey_date FK_sea_star_disease_count_sizes_field_event R
sea_star_notes.survey_date FK_sea_star_notes_field_event R
seagrass_conditions.survey_date FK_seagrass_conditions_field_event R
seagrass_cover.survey_date FK_sc_field_event R
seagrass_thickness.survey_date FK_st_field_event R
transect_notes.survey_date FK_transect_notes_field_event R
transects.survey_date FK_transects_field_event R
urchin_count_sizes.survey_date FK_urchin_count_sizes_field_event R
urchin_notes.survey_date FK_urchin_notes_field_event R
The date the site was surveyed. Date format is yyyy-mm-dd.
group_code varchar 8
abalone_count_sizes.group_code FK_abalone_count_sizes_field_event R
abalone_empty_shells.group_code FK_abalone_empty_field_event R
abalone_notes.group_code FK_abalone_notes_field_event R
abhab_not_sampled.group_code FK_abhab_notsampled_event R
abhab_notes.group_code FK_abhab_notes_field_event R
abhab_plot_habitat_info.group_code FK_abhab_plot_hab_info_fe R
abhab_plots_count_sizes.group_code FK_abhabplot_count_sizes_field_event R
abhab_plots_not_sampled.group_code FK_abhab_plot_notsampled_event R
abhab_plots_sampled.group_code FK_abhab_plot_sampled_event R
abhab_sampled.group_code FK_abhab_sampled_event R
abhab_segment_boundaries.group_code FK_abhab_seg_gps_fe R
abhab_segment_info.group_code FK_abhab_seg_info_fe R
abhab_segments_count_sizes.group_code FK_abhab_count_sizes_field_event R
checklist_entered.group_code FK_checklist_entered_event R
checklist_not_sampled.group_code FK_checklist_not_sampled_event R
checklist_sampled.group_code FK_checklist_sampled_event R
cryptochiton_count_sizes.group_code FK_cry_count_sizes_field_event R
field_event_bird_counts.group_code FK_field_event_bird_counts_field_events R
field_event_collections.group_code FK_field_event_collection_field_events R
field_event_conditions.group_code FK_field_event_conditions_field_event R
field_event_mammal_counts.group_code FK_field_event_mammal_counts_field_events R
field_event_mammal_disturbance.group_code FK_field_event_mammald_field_events R
field_event_non_native.group_code FK_field_event_non_native_field_events R
field_event_participants.group_code FK_field_events_participants R
field_event_recon.group_code FK_field_event_recon_field_event R
katharina_count_sizes.group_code FK_kat_count_sizes_field_event R
lottia_count_sizes.group_code FK_lottia_count_sizes_field_event R
lottia_cover.group_code FK_lc_field_event R
lottia_notes.group_code FK_lottia_notes_field_event R
mussel_depths.group_code FK_md_field_event R
mussel_sizes.group_code FK_ms_field_event R
nps_entered.group_code FK_nps_entered_event R
photo_plot_layers.group_code FK_photo_plot_layers_field_event R
photo_plot_layers_onp.group_code FK_photo_plot_layers_onp_field_event R
photo_plot_layers_summary.group_code FK_photo_plot_layers_summary_field_event R
photo_plot_notes.group_code FK_photo_plot_notes_field_event R
photo_plot_photoquad_summary.group_code FK_photo_plot_pq_summary_field_event R
photo_plot_understory_layers_summary.group_code FK_photo_plot_ulayers_summary_field_event R
photo_plots.group_code FK_photo_plot_field_event R
postelsia.group_code FK_postelsia_field_events R
postelsia_notes.group_code FK_postelsia_notes_field_event R
recon_notes.group_code FK_recon_notes_field_event R
sea_star_color_count_sizes.group_code FK_sea_star_colors_field_event R
sea_star_counts.group_code FK_sea_star_count_field_event R
sea_star_disease_count_sizes.group_code FK_sea_star_disease_count_sizes_field_event R
sea_star_notes.group_code FK_sea_star_notes_field_event R
seagrass_conditions.group_code FK_seagrass_conditions_field_event R
seagrass_cover.group_code FK_sc_field_event R
seagrass_thickness.group_code FK_st_field_event R
transect_notes.group_code FK_transect_notes_field_event R
transects.group_code FK_transects_field_event R
urchin_count_sizes.group_code FK_urchin_count_sizes_field_event R
urchin_notes.group_code FK_urchin_notes_field_event R
monitoring_groups.group_code FK_field_events_group_code R
marine_common_season int unsigned 10
marine_common_seasons.marine_common_season FK_field_events_mcs R
marine_sample_type enum 10 standard
recorder varchar 10
marine_personnel.personnel_code FK_field_events_recorder R
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 6,067 rows at Thu Apr 03 16:08 PDT 2025

Indexes:
Column(s) Type Sort Constraint Name
site_code + survey_date + group_code Primary key Asc/Asc/Asc PRIMARY
group_code Performance Asc FK_field_events_group_code
marine_common_season Performance Asc FK_field_events_mcs
recorder Performance Asc FK_field_events_recorder

Close relationships  within of separation: