SchemaSpy - Table marinedb.photo_plot

MARINe photo plot qualifiers

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

qualifier_code

varchar

photo_plot_layers.qualifier_code	FK_photo_plot_layers_qualifier R
photo_plot_layers_active.qualifier_code	FK_photo_plot_layers_active_qualifier R
photo_plot_layers_onp.qualifier_code	FK_photo_plot_layers_onp_qualifier R
photo_plot_layers_summary.qualifier_code	FK_photo_plot_layers_summary_qualifier R
photo_plot_layers_summary_active.qualifier_code	FK_photo_plot_layers_summary_active_qualifier R
photo_plot_photoquad_summary.qualifier_code	FK_photo_plot_pq_summary_qualifier R
photo_plot_photoquad_summary_active.qualifier_code	FK_photo_plot_pq_summary_active_qualifier R
photo_plot_understory_layers_summary.qualifier_code	FK_photo_plot_ulayers_summary_qualifier R
photo_plots.photo_plot_qualifier_code	FK_photo_plot_qualifier R
photo_plots_active.qualifier_code	FK_photo_plot_active_qualifier R

qualifier_codes.qualifier_code

FK_photo_plot_qualifiers_code R

Table contained 3 rows at Thu Apr 03 16:08 PDT 2025

Indexes:

Column(s)	Type	Sort	Constraint Name
qualifier_code	Primary key	Asc	PRIMARY