Table marinedb.field_event_conditions
field event conditions

 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.site_code FK_field_event_conditions_field_event R
survey_date date 10
field_events.survey_date FK_field_event_conditions_field_event R
group_code varchar 8
field_events.group_code FK_field_event_conditions_field_event R
start_time time 8
end_time time 8
swell_surge varchar 3
condition_codes.condition_code FK_field_event_conditions_swell_surge R
wind_speed varchar 3
wind_speeds.wind_speed FK_field_event_conditions_wind_speed R
rain_amount varchar 3
condition_codes.condition_code FK_field_event_conditions_rain_amount R
rain_recent varchar 3
condition_codes.condition_code FK_field_event_conditions_rain_recent R
sediment_level varchar 3
condition_codes.condition_code FK_field_event_conditions_sediment_level R
scoured_reef varchar 3
condition_codes.condition_code FK_field_event_conditions_scoured_reef R
rock_movement varchar 3
condition_codes.condition_code FK_field_event_conditions_rock_movement R
plant_wrack varchar 3
condition_codes.condition_code FK_field_event_conditions_plant_wrack R
driftwood varchar 3
condition_codes.condition_code FK_field_event_conditions_driftwood R
shell_debris varchar 3
condition_codes.condition_code FK_field_event_conditions_shell_debris R
dead_animals varchar 3
condition_codes.condition_code FK_field_event_conditions_dead_animals R
trash varchar 3
condition_codes.condition_code FK_field_event_conditions_trash R
oil_tar varchar 3
condition_codes.condition_code FK_field_event_conditions_oil_tar R
humans_reef varchar 3
reef_sand_people_count_values.reef_sand_people_count_value FK_field_event_conditions_reef_people R
humans_sand varchar 3
reef_sand_people_count_values.reef_sand_people_count_value FK_field_event_conditions_sand_people R
humans_notes text 65535  √  null
physical_notes text 65535  √  null
other_notes text 65535  √  null
plot_notes text 65535  √  null
bird_mammal_notes text 65535  √  null
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 3,087 rows at Thu Nov 06 11:53 PST 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_dead_animals
driftwood Performance Asc FK_field_event_conditions_driftwood
oil_tar Performance Asc FK_field_event_conditions_oil_tar
plant_wrack Performance Asc FK_field_event_conditions_plant_wrack
rain_amount Performance Asc FK_field_event_conditions_rain_amount
rain_recent Performance Asc FK_field_event_conditions_rain_recent
humans_reef Performance Asc FK_field_event_conditions_reef_people
rock_movement Performance Asc FK_field_event_conditions_rock_movement
humans_sand Performance Asc FK_field_event_conditions_sand_people
scoured_reef Performance Asc FK_field_event_conditions_scoured_reef
sediment_level Performance Asc FK_field_event_conditions_sediment_level
shell_debris Performance Asc FK_field_event_conditions_shell_debris
swell_surge Performance Asc FK_field_event_conditions_swell_surge
trash Performance Asc FK_field_event_conditions_trash
wind_speed Performance Asc FK_field_event_conditions_wind_speed

Close relationships  within of separation: