SchemaSpy - Table marinedb.quatraplot

list of quadrat transect and plot codes

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

quatraplot_code

varchar

abalone_notes.plot_code	FK_abalone_notes_quatraplot R
abalone_notes_active.plot_code	FK_abalone_notes_active_quatraplot R
abhab_notes.plot_code	FK_abhab_notes_quatraplot R
abhab_notes_active.plot_code	FK_abhab_notes_active_quatraplot R
abhab_plots_not_sampled.quatraplot_code	FK_abhab_plot_notsampled_codes R
abhab_plots_sampled.quatraplot_code	FK_abhab_plot_sampled_codes R
checklist_entered.quatraplot_code	FK_checklist_entered_codes R
checklist_not_sampled.quatraplot_code	FK_checklist_not_sampled_codes R
checklist_quatraplots_active.quatraplot_code	FK_checklist_quatraplots_codes R
checklist_sampled.quatraplot_code	FK_checklist_sampled_codes R
lottia_notes.plot_code	FK_lottia_notes_quatraplot R
lottia_notes_active.plot_code	FK_lottia_notes_active_quatraplot R
nps_entered.quatraplot_code	FK_nps_entered_codes R
photo_plot_notes.quadrat_code	FK_photo_plot_notes_quatraplot R
photo_plot_notes_active.quadrat_code	FK_photo_plot_notes_active_quatraplot R
photo_plot_photoquad.quadrat_code	FK_photo_plot_pq_summary_plots R
photo_plot_photoquad_active.quadrat_code	FK_photo_plot_pq_summary_active_plots R
postelsia_notes.plot_code	FK_postelsia_notes_quatraplot R
postelsia_notes_active.plot_code	FK_postelsia_notes_active_quatraplot R
sea_star_notes.plot_code	FK_sea_star_notes_quatraplot R
sea_star_notes_active.plot_code	FK_sea_star_notes_active_quatraplot R
secondary_plot_info.quatraplot_code	FK_secondary_plot_info_plot_code R
secondary_plot_info_active.quatraplot_code	FK_secondary_plot_info_active_plot_code R
subsampled_plot_info.quatraplot_code	FK_subsampled_plot_info_plot_code R
subsampled_plot_info.sub_plot_code	FK_subsampled_plot_info_sub_plot_code R
transect_notes.transect_code	FK_transect_notes_quatraplot R
transect_notes_active.transect_code	FK_transect_notes_active_quatraplot R
urchin_notes.plot_code	FK_urchin_notes_quatraplot R
urchin_notes_active.plot_code	FK_urchin_notes_active_quatraplot R

create_date

date

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

Indexes:

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