SchemaSpy - Table marinedb.photo_plot_group

photo plots group and species junction table

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

group_code

char

photo_plot_layers.group_code	FK_photo_plot_layers_top_group_species R
photo_plot_layers_onp.group_code	FK_photo_plot_layers_species2_species R
photo_plot_layers_summary.group_code	FK_photo_plot_layers_summary_group_species R
photo_plot_photoquad_summary.group_code	FK_photo_plot_pq_summary_group_species R
photo_plot_understory_layers_summary.group_code	FK_photo_plot_ulayers_summary_group_species R
photo_plots.group_code	FK_photo_plot_group_species R

FK_photo_plot_group_species_ppgroups R

species_code

char

photo_plot_layers.bottom_layer	FK_photo_plot_layers_bottom_group_species R
photo_plot_layers.top_layer	FK_photo_plot_layers_top_group_species R
photo_plot_layers_onp.taxon_1	FK_photo_plot_layers_species1_species R
photo_plot_layers_onp.taxon_2	FK_photo_plot_layers_species2_species R
photo_plot_layers_summary.species_code	FK_photo_plot_layers_summary_group_species R
photo_plot_photoquad_summary.species_code	FK_photo_plot_pq_summary_group_species R
photo_plot_understory_layers_summary.species_code	FK_photo_plot_ulayers_summary_group_species R
photo_plots.species_code	FK_photo_plot_group_species R

marine_species.species_code

photo_plot_group_species_ibfk_2 R

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

Indexes:

Column(s)	Type	Sort	Constraint Name
group_code + species_code	Primary key	Asc/Asc	PRIMARY
species_code	Performance	Asc	species_code