SchemaSpy - Table marinedb.photo_plot_layer

photo plot layer rules table to compare with historic photo

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

top_layer

varchar

marine_species.species_code

FK_photo_plot_layer_rules_top_species_codes R

bottom_layer

varchar

marine_species.species_code

FK_photo_plot_layer_rules_bottom_species_codes R

layer_to_use

enum

comments

varchar

500

√

null

create_date

date

modify_date

timestamp

current_timestamp()

Table contained 2,580 rows at Thu Nov 06 11:53 PST 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