SchemaSpy - Table marinedb.checklist_quatraplots

List of plots for all target assemblages for data entry

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

abhab_plots_not_sampled_active.site_code	FK_abhab_plot_notsampled_active_quatraplots R
abhab_plots_sampled_active.site_code	FK_abhab_plot_sampled_active_quatraplots R
checklist_entered_active.site_code	FK_checklist_entered_active_quatraplots R
checklist_not_sampled_active.site_code	FK_checklist_not_sampled_active_quatraplots R
checklist_sampled_active.site_code	FK_checklist_sampled_active_quatraplots R

marine_sites.site_code

FK_checklist_quatraplots_site_code R

survey_type_code

varchar

abhab_plots_not_sampled_active.survey_type_code	FK_abhab_plot_notsampled_active_quatraplots R
abhab_plots_sampled_active.survey_type_code	FK_abhab_plot_sampled_active_quatraplots R
checklist_entered_active.survey_type_code	FK_checklist_entered_active_quatraplots R
checklist_not_sampled_active.survey_type_code	FK_checklist_not_sampled_active_quatraplots R
checklist_sampled_active.survey_type_code	FK_checklist_sampled_active_quatraplots R

survey_type_codes.survey_type_code

FK_checklist_quatraplots_survey_type_code R

target_assemblage

varchar

abhab_plots_not_sampled_active.target_assemblage	FK_abhab_plot_notsampled_active_quatraplots R
abhab_plots_sampled_active.target_assemblage	FK_abhab_plot_sampled_active_quatraplots R
checklist_entered_active.target_assemblage	FK_checklist_entered_active_quatraplots R
checklist_not_sampled_active.target_assemblage	FK_checklist_not_sampled_active_quatraplots R
checklist_sampled_active.target_assemblage	FK_checklist_sampled_active_quatraplots R

target_assemblages.target_assemblage

FK_checklist_quatraplots_target_assemblage R

quatraplot_code

varchar

abhab_plots_not_sampled_active.quatraplot_code	FK_abhab_plot_notsampled_active_quatraplots R
abhab_plots_sampled_active.quatraplot_code	FK_abhab_plot_sampled_active_quatraplots R
checklist_entered_active.quatraplot_code	FK_checklist_entered_active_quatraplots R
checklist_not_sampled_active.quatraplot_code	FK_checklist_not_sampled_active_quatraplots R
checklist_sampled_active.quatraplot_code	FK_checklist_sampled_active_quatraplots R

quatraplot_codes.quatraplot_code

FK_checklist_quatraplots_codes R

Table contained 6,228 rows at Thu Apr 03 16:08 PDT 2025

Indexes:

Column(s)	Type	Sort	Constraint Name
site_code + survey_type_code + target_assemblage + quatraplot_code	Primary key	Asc/Asc/Asc/Asc	PRIMARY
quatraplot_code	Performance	Asc	FK_checklist_quatraplots_codes
survey_type_code	Performance	Asc	FK_checklist_quatraplots_survey_type_code
target_assemblage	Performance	Asc	FK_checklist_quatraplots_target_assemblage