Table marinedb.photo_plot_layer_rules_onp
photo plot layer rules table for onp data to compare with historic photo plots

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

Table contained 366 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_onp_bottom_codes

Close relationships  within of separation: