SchemaSpy - Table marinedb.field_event_conditions

field event conditions

Generated by
SchemaSpy

Legend:

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 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_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