Table marinedb.photo_plot_layer_rules
photo plot layer rules table to compare with historic photo

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
top_layer varchar 6
marine_species.species_code FK_photo_plot_layer_rules_top_species_codes R
bottom_layer varchar 6
marine_species.species_code FK_photo_plot_layer_rules_bottom_species_codes R
layer_to_use enum 12
comments varchar 500  √  null
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 2,580 rows at Thu Apr 03 16:08 PDT 2025

Indexes:
Column(s) Type Sort Constraint Name
top_layer + bottom_layer Primary key Asc/Asc PRIMARY
bottom_layer Performance Asc FK_photo_plot_layer_rules_bottom_codes

Close relationships  within of separation: