Table marinedb.condition_codes
condition codes for field log entries

 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
condition_code varchar 3
abhab_plot_habitat_info.mussel_encroachment FK_abhab_plot_info_encroach R
abhab_plot_habitat_info_active.mussel_encroachment FK_abhab_plot_info_active_active_encroach R
field_event_conditions.dead_animals FK_field_event_conditions_dead_animals R
field_event_conditions.driftwood FK_field_event_conditions_driftwood R
field_event_conditions.oil_tar FK_field_event_conditions_oil_tar R
field_event_conditions.plant_wrack FK_field_event_conditions_plant_wrack R
field_event_conditions.rain_amount FK_field_event_conditions_rain_amount R
field_event_conditions.rain_recent FK_field_event_conditions_rain_recent R
field_event_conditions.rock_movement FK_field_event_conditions_rock_movement R
field_event_conditions.scoured_reef FK_field_event_conditions_scoured_reef R
field_event_conditions.sediment_level FK_field_event_conditions_sediment_level R
field_event_conditions.shell_debris FK_field_event_conditions_shell_debris R
field_event_conditions.swell_surge FK_field_event_conditions_swell_surge R
field_event_conditions.trash FK_field_event_conditions_trash R
field_event_conditions_active.dead_animals FK_field_event_conditions_active_dead_animals R
field_event_conditions_active.driftwood FK_field_event_conditions_active_driftwood R
field_event_conditions_active.oil_tar FK_field_event_conditions_active_oil_tar R
field_event_conditions_active.plant_wrack FK_field_event_conditions_active_plant_wrack R
field_event_conditions_active.rain_amount FK_field_event_conditions_active_rain_amount R
field_event_conditions_active.rain_recent FK_field_event_conditions_active_rain_recent R
field_event_conditions_active.rock_movement FK_field_event_conditions_active_rock_movement R
field_event_conditions_active.scoured_reef FK_field_event_conditions_active_scoured_reef R
field_event_conditions_active.sediment_level FK_field_event_conditions_active_sediment_level R
field_event_conditions_active.shell_debris FK_field_event_conditions_active_shell_debris R
field_event_conditions_active.swell_surge FK_field_event_conditions_active_swell_surge R
field_event_conditions_active.trash FK_field_event_conditions_active_trash R
seagrass_conditions.abraded FK_seagrass_conditions_abraded R
seagrass_conditions.bleached_brown FK_seagrass_conditions_bleached_brown R
seagrass_conditions.flowers FK_seagrass_conditions_flowers R
seagrass_conditions.melobesia FK_seagrass_conditions_melobsia R
seagrass_conditions.smithora FK_seagrass_conditions_smithora R
seagrass_conditions_active.abraded FK_seagrass_conditions_active_abraded R
seagrass_conditions_active.bleached_brown FK_seagrass_conditions_active_bleached_brown R
seagrass_conditions_active.flowers FK_seagrass_conditions_active_flowers R
seagrass_conditions_active.melobesia FK_seagrass_conditions_active_melobsia R
seagrass_conditions_active.smithora FK_seagrass_conditions_active_smithora R
condition_sort int 10  √  null
condition_description varchar 8
create_date date 10

Table contained 5 rows at Thu Apr 03 16:08 PDT 2025

Indexes:
Column(s) Type Sort Constraint Name
condition_code Primary key Asc PRIMARY

Close relationships  within of separation: