SchemaSpy - Table marinedb.photo_plot

photo plots information

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

photo_plot_layers.site_code	FK_photo_plot_layers_info R
photo_plot_layers_onp.site_code	FK_photo_plot_layers_onp_info R
photo_plot_layers_summary.site_code	FK_photo_plot_layers_summary_info R
photo_plot_notes.site_code	FK_photo_plot_notes_photo_plot_target R
photo_plot_photoquad_summary.site_code	FK_photo_plot_pq_summary_info R
photo_plot_understory_layers_summary.site_code	FK_photo_plot_ulayers_summary_info R
photo_plots.site_code	FK_photo_plot_info R

marine_sites.site_code

FK_photo_plot_info_site_code R

target_assemblage

varchar

photo_plot_layers.target_assemblage	FK_photo_plot_layers_info R
photo_plot_layers_onp.target_assemblage	FK_photo_plot_layers_onp_info R
photo_plot_layers_summary.target_assemblage	FK_photo_plot_layers_summary_info R
photo_plot_notes.target_assemblage	FK_photo_plot_notes_photo_plot_target R
photo_plot_photoquad_summary.target_assemblage	FK_photo_plot_pq_summary_info R
photo_plot_understory_layers_summary.target_assemblage	FK_photo_plot_ulayers_summary_info R
photo_plots.target_assemblage	FK_photo_plot_info R

photo_plot_target_assemblages.target_assemblage

photo_plot_info_ibfk_1 R

quadrat_code

varchar

photo_plot_layers.quadrat_code	FK_photo_plot_layers_info R
photo_plot_layers_onp.quadrat_code	FK_photo_plot_layers_onp_info R
photo_plot_layers_summary.quadrat_code	FK_photo_plot_layers_summary_info R
photo_plot_photoquad_summary.quadrat_code	FK_photo_plot_pq_summary_info R
photo_plot_understory_layers_summary.quadrat_code	FK_photo_plot_ulayers_summary_info R
photo_plots.quadrat_code	FK_photo_plot_info R

photo_plot_quadrat_codes.quadrat_code

FK_photo_plot_into_quadrat_code R

photo_plot_area

float

7,3

established_date

date

end_date

date

√

null

active_status

enum

comments

varchar

100

√

null

create_date

date

modify_date

timestamp

current_timestamp()

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

Indexes:

Column(s)	Type	Sort	Constraint Name
site_code + target_assemblage + quadrat_code	Primary key	Asc/Asc/Asc	PRIMARY
quadrat_code	Performance	Asc	FK_photo_plot_into_quadrat_code
target_assemblage	Performance	Asc	target_assemblage