SchemaSpy - Table marinedb.photo_plot

verified photo plot data uploaded from photoquad after reformatting

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

marine_sites.site_code

FK_photo_plot_pq_summary_site_code R

marine_season_code

char

photo_target_code

char

photo_target_codes.photo_target_code

FK_photo_plot_pq_summary_targets R

quadrat_code

varchar

quatraplot_codes.quatraplot_code

FK_photo_plot_pq_summary_plots R

marine_species_name

varchar

percent_cover

int unsigned

method_code

varchar

photo_plot_methods.method_code

FK_photo_plot_pq_method R

create_date

date

√

null

modify_date

timestamp

current_timestamp()

Table contained 1,475 rows at Thu Apr 03 16:08 PDT 2025

Indexes:

Column(s)	Type	Sort	Constraint Name
site_code + marine_season_code + photo_target_code + quadrat_code + marine_species_name	Primary key	Asc/Asc/Asc/Asc/Asc	PRIMARY
method_code	Performance	Asc	FK_photo_plot_pq_method
quadrat_code	Performance	Asc	FK_photo_plot_pq_summary_plots
photo_target_code	Performance	Asc	FK_photo_plot_pq_summary_targets