Table marinedb.field_events_active
field events data entry

 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_active.site_code FK_abalone_count_sizes_active_field_event R
abalone_empty_shells_active.site_code FK_abalone_empty_active_field_event R
abalone_notes_active.site_code FK_abalone_notes_active_field_event R
abhab_not_sampled_active.site_code FK_abhab_notsampled_active_event R
abhab_notes_active.site_code FK_abhab_notes_active_field_event R
abhab_plot_habitat_info_active.site_code FK_abhab_plot_hab_info_active_fe R
abhab_plots_count_sizes_active.site_code FK_abhabplot_count_sizes_active_field_event R
abhab_plots_not_sampled_active.site_code FK_abhab_plot_notsampled_active_event R
abhab_plots_sampled_active.site_code FK_abhab_plot_sampled_active_event R
abhab_sampled_active.site_code FK_abhab_sampled_active_event R
abhab_segment_boundaries_active.site_code FK_abhab_seg_gps_active_fe R
abhab_segment_info_active.site_code FK_abhab_seg_info_active_fe R
abhab_segments_count_sizes_active.site_code FK_abhab_count_sizes_active_field_event R
checklist_entered_active.site_code FK_checklist_entered_active_event R
checklist_not_sampled_active.site_code FK_checklist_not_sampled_active_event R
checklist_sampled_active.site_code FK_checklist_sampled_active_event R
cryptochiton_count_sizes_active.site_code FK_cry_count_sizes_active_field_event R
field_event_bird_counts_active.site_code FK_field_event_bird_counts_active_field_events R
field_event_collections_active.site_code FK_field_event_collection_active_field_events R
field_event_conditions_active.site_code FK_field_event_conditions_active_field_event R
field_event_mammal_counts_active.site_code FK_field_event_mammal_counts_active_field_events R
field_event_mammal_disturbance_active.site_code FK_field_event_mammald_activefield_events R
field_event_non_native_active.site_code FK_field_event_nonnative_active_field_events R
field_event_participants_active.site_code FK_field_events_participants_active R
field_event_recon_active.site_code FK_field_event_recon_active_field_event R
katharina_count_sizes_active.site_code FK_kat_count_sizes_active_field_even R
lottia_count_sizes_active.site_code FK_lottia_count_sizes_active_field_event R
lottia_cover_active.site_code FK_lc_field_event_active R
lottia_notes_active.site_code FK_lottia_notes_active_field_event R
mussel_depths_active.site_code FK_md_active_field_event R
mussel_sizes_active.site_code FK_ms_active_field_event R
photo_plot_layers_active.site_code FK_photo_plot_layers_active_field_event R
photo_plot_layers_summary_active.site_code FK_photo_plot_layers_summary_active_field_event R
photo_plot_notes_active.site_code FK_photo_plot_notes_active_field_event R
photo_plot_photoquad_summary_active.site_code FK_photo_plot_pq_summary_active_field_event R
photo_plots_active.site_code FK_photo_plot_active_field_event R
postelsia_active.site_code FK_postelsia_active_field_event R
postelsia_notes_active.site_code FK_postelsia_notes_active_field_event R
recon_notes_active.site_code FK_recon_notes_active_field_event R
sea_star_disease_count_sizes_active.site_code FK_sea_star_disease_count_sizes_active_field_event R
sea_star_notes_active.site_code FK_sea_star_notes_active_field_event R
seagrass_conditions_active.site_code FK_seagrass_conditions_active_field_event R
seagrass_cover_active.site_code FK_sc_field_event_active R
seagrass_thickness_active.site_code FK_st_field_event_active R
transect_notes_active.site_code FK_transect_notes_active_field_event R
transects_active.site_code FK_transects_active_field_event R
urchin_count_sizes_active.site_code FK_urchin_count_sizes_active_field_event R
urchin_notes_active.site_code FK_urchin_notes_active_field_event R
marine_sites.site_code FK_field_events_site_code_active R
survey_date date 10
abalone_count_sizes_active.survey_date FK_abalone_count_sizes_active_field_event R
abalone_empty_shells_active.survey_date FK_abalone_empty_active_field_event R
abalone_notes_active.survey_date FK_abalone_notes_active_field_event R
abhab_not_sampled_active.survey_date FK_abhab_notsampled_active_event R
abhab_notes_active.survey_date FK_abhab_notes_active_field_event R
abhab_plot_habitat_info_active.survey_date FK_abhab_plot_hab_info_active_fe R
abhab_plots_count_sizes_active.survey_date FK_abhabplot_count_sizes_active_field_event R
abhab_plots_not_sampled_active.survey_date FK_abhab_plot_notsampled_active_event R
abhab_plots_sampled_active.survey_date FK_abhab_plot_sampled_active_event R
abhab_sampled_active.survey_date FK_abhab_sampled_active_event R
abhab_segment_boundaries_active.survey_date FK_abhab_seg_gps_active_fe R
abhab_segment_info_active.survey_date FK_abhab_seg_info_active_fe R
abhab_segments_count_sizes_active.survey_date FK_abhab_count_sizes_active_field_event R
checklist_entered_active.survey_date FK_checklist_entered_active_event R
checklist_not_sampled_active.survey_date FK_checklist_not_sampled_active_event R
checklist_sampled_active.survey_date FK_checklist_sampled_active_event R
cryptochiton_count_sizes_active.survey_date FK_cry_count_sizes_active_field_event R
field_event_bird_counts_active.survey_date FK_field_event_bird_counts_active_field_events R
field_event_collections_active.survey_date FK_field_event_collection_active_field_events R
field_event_conditions_active.survey_date FK_field_event_conditions_active_field_event R
field_event_mammal_counts_active.survey_date FK_field_event_mammal_counts_active_field_events R
field_event_mammal_disturbance_active.survey_date FK_field_event_mammald_activefield_events R
field_event_non_native_active.survey_date FK_field_event_nonnative_active_field_events R
field_event_participants_active.survey_date FK_field_events_participants_active R
field_event_recon_active.survey_date FK_field_event_recon_active_field_event R
katharina_count_sizes_active.survey_date FK_kat_count_sizes_active_field_even R
lottia_count_sizes_active.survey_date FK_lottia_count_sizes_active_field_event R
lottia_cover_active.survey_date FK_lc_field_event_active R
lottia_notes_active.survey_date FK_lottia_notes_active_field_event R
mussel_depths_active.survey_date FK_md_active_field_event R
mussel_sizes_active.survey_date FK_ms_active_field_event R
photo_plot_layers_active.survey_date FK_photo_plot_layers_active_field_event R
photo_plot_layers_summary_active.survey_date FK_photo_plot_layers_summary_active_field_event R
photo_plot_notes_active.survey_date FK_photo_plot_notes_active_field_event R
photo_plot_photoquad_summary_active.survey_date FK_photo_plot_pq_summary_active_field_event R
photo_plots_active.survey_date FK_photo_plot_active_field_event R
postelsia_active.survey_date FK_postelsia_active_field_event R
postelsia_notes_active.survey_date FK_postelsia_notes_active_field_event R
recon_notes_active.survey_date FK_recon_notes_active_field_event R
sea_star_disease_count_sizes_active.survey_date FK_sea_star_disease_count_sizes_active_field_event R
sea_star_notes_active.survey_date FK_sea_star_notes_active_field_event R
seagrass_conditions_active.survey_date FK_seagrass_conditions_active_field_event R
seagrass_cover_active.survey_date FK_sc_field_event_active R
seagrass_thickness_active.survey_date FK_st_field_event_active R
transect_notes_active.survey_date FK_transect_notes_active_field_event R
transects_active.survey_date FK_transects_active_field_event R
urchin_count_sizes_active.survey_date FK_urchin_count_sizes_active_field_event R
urchin_notes_active.survey_date FK_urchin_notes_active_field_event R
group_code varchar 8
abalone_count_sizes_active.group_code FK_abalone_count_sizes_active_field_event R
abalone_empty_shells_active.group_code FK_abalone_empty_active_field_event R
abalone_notes_active.group_code FK_abalone_notes_active_field_event R
abhab_not_sampled_active.group_code FK_abhab_notsampled_active_event R
abhab_notes_active.group_code FK_abhab_notes_active_field_event R
abhab_plot_habitat_info_active.group_code FK_abhab_plot_hab_info_active_fe R
abhab_plots_count_sizes_active.group_code FK_abhabplot_count_sizes_active_field_event R
abhab_plots_not_sampled_active.group_code FK_abhab_plot_notsampled_active_event R
abhab_plots_sampled_active.group_code FK_abhab_plot_sampled_active_event R
abhab_sampled_active.group_code FK_abhab_sampled_active_event R
abhab_segment_boundaries_active.group_code FK_abhab_seg_gps_active_fe R
abhab_segment_info_active.group_code FK_abhab_seg_info_active_fe R
abhab_segments_count_sizes_active.group_code FK_abhab_count_sizes_active_field_event R
checklist_entered_active.group_code FK_checklist_entered_active_event R
checklist_not_sampled_active.group_code FK_checklist_not_sampled_active_event R
checklist_sampled_active.group_code FK_checklist_sampled_active_event R
cryptochiton_count_sizes_active.group_code FK_cry_count_sizes_active_field_event R
field_event_bird_counts_active.group_code FK_field_event_bird_counts_active_field_events R
field_event_collections_active.group_code FK_field_event_collection_active_field_events R
field_event_conditions_active.group_code FK_field_event_conditions_active_field_event R
field_event_mammal_counts_active.group_code FK_field_event_mammal_counts_active_field_events R
field_event_mammal_disturbance_active.group_code FK_field_event_mammald_activefield_events R
field_event_non_native_active.group_code FK_field_event_nonnative_active_field_events R
field_event_participants_active.group_code FK_field_events_participants_active R
field_event_recon_active.group_code FK_field_event_recon_active_field_event R
katharina_count_sizes_active.group_code FK_kat_count_sizes_active_field_even R
lottia_count_sizes_active.group_code FK_lottia_count_sizes_active_field_event R
lottia_cover_active.group_code FK_lc_field_event_active R
lottia_notes_active.group_code FK_lottia_notes_active_field_event R
mussel_depths_active.group_code FK_md_active_field_event R
mussel_sizes_active.group_code FK_ms_active_field_event R
photo_plot_layers_active.group_code FK_photo_plot_layers_active_field_event R
photo_plot_layers_summary_active.group_code FK_photo_plot_layers_summary_active_field_event R
photo_plot_notes_active.group_code FK_photo_plot_notes_active_field_event R
photo_plot_photoquad_summary_active.group_code FK_photo_plot_pq_summary_active_field_event R
photo_plots_active.group_code FK_photo_plot_active_field_event R
postelsia_active.group_code FK_postelsia_active_field_event R
postelsia_notes_active.group_code FK_postelsia_notes_active_field_event R
recon_notes_active.group_code FK_recon_notes_active_field_event R
sea_star_disease_count_sizes_active.group_code FK_sea_star_disease_count_sizes_active_field_event R
sea_star_notes_active.group_code FK_sea_star_notes_active_field_event R
seagrass_conditions_active.group_code FK_seagrass_conditions_active_field_event R
seagrass_cover_active.group_code FK_sc_field_event_active R
seagrass_thickness_active.group_code FK_st_field_event_active R
transect_notes_active.group_code FK_transect_notes_active_field_event R
transects_active.group_code FK_transects_active_field_event R
urchin_count_sizes_active.group_code FK_urchin_count_sizes_active_field_event R
urchin_notes_active.group_code FK_urchin_notes_active_field_event R
monitoring_groups.group_code FK_field_events_group_code_active R
marine_common_season int unsigned 10
marine_common_seasons.marine_common_season FK_field_events_mcs_active R
marine_sample_type enum 10 standard
recorder varchar 10
marine_personnel.personnel_code FK_field_events_recorder_active R
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 0 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_active
marine_common_season Performance Asc FK_field_events_mcs_active
recorder Performance Asc FK_field_events_recorder_active

Close relationships  within of separation: