Table marinedb.field_event_conditions_active
field event conditions 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
field_events_active.site_code FK_field_event_conditions_active_field_event R
survey_date date 10
field_events_active.survey_date FK_field_event_conditions_active_field_event R
group_code varchar 8
field_events_active.group_code FK_field_event_conditions_active_field_event R
start_time time 8
end_time time 8
swell_surge varchar 3
condition_codes.condition_code FK_field_event_conditions_active_swell_surge R
wind_speed varchar 3
wind_speeds.wind_speed FK_field_event_conditions_active_wind_speed R
rain_amount varchar 3
condition_codes.condition_code FK_field_event_conditions_active_rain_amount R
rain_recent varchar 3
condition_codes.condition_code FK_field_event_conditions_active_rain_recent R
sediment_level varchar 3
condition_codes.condition_code FK_field_event_conditions_active_sediment_level R
scoured_reef varchar 3
condition_codes.condition_code FK_field_event_conditions_active_scoured_reef R
rock_movement varchar 3
condition_codes.condition_code FK_field_event_conditions_active_rock_movement R
plant_wrack varchar 3
condition_codes.condition_code FK_field_event_conditions_active_plant_wrack R
driftwood varchar 3
condition_codes.condition_code FK_field_event_conditions_active_driftwood R
shell_debris varchar 3
condition_codes.condition_code FK_field_event_conditions_active_shell_debris R
dead_animals varchar 3
condition_codes.condition_code FK_field_event_conditions_active_dead_animals R
trash varchar 3
condition_codes.condition_code FK_field_event_conditions_active_trash R
oil_tar varchar 3
condition_codes.condition_code FK_field_event_conditions_active_oil_tar R
humans_reef varchar 3
reef_sand_people_count_values.reef_sand_people_count_value FK_field_event_conditions_active_reef_people R
humans_sand varchar 3
reef_sand_people_count_values.reef_sand_people_count_value FK_field_event_conditions_active_sand_people R
humans_notes varchar 2000  √  null
physical_notes varchar 2000  √  null
other_notes varchar 2000  √  null
plot_notes varchar 2000  √  null
bird_mammal_notes varchar 2000  √  null
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
dead_animals Performance Asc FK_field_event_conditions_active_dead_animals
driftwood Performance Asc FK_field_event_conditions_active_driftwood
oil_tar Performance Asc FK_field_event_conditions_active_oil_tar
plant_wrack Performance Asc FK_field_event_conditions_active_plant_wrack
rain_amount Performance Asc FK_field_event_conditions_active_rain_amount
rain_recent Performance Asc FK_field_event_conditions_active_rain_recent
humans_reef Performance Asc FK_field_event_conditions_active_reef_people
rock_movement Performance Asc FK_field_event_conditions_active_rock_movement
humans_sand Performance Asc FK_field_event_conditions_active_sand_people
scoured_reef Performance Asc FK_field_event_conditions_active_scoured_reef
sediment_level Performance Asc FK_field_event_conditions_active_sediment_level
shell_debris Performance Asc FK_field_event_conditions_active_shell_debris
swell_surge Performance Asc FK_field_event_conditions_active_swell_surge
trash Performance Asc FK_field_event_conditions_active_trash
wind_speed Performance Asc FK_field_event_conditions_active_wind_speed

Close relationships  within of separation: