SchemaSpy - Table marinedb.survey_type

survey type 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

survey_type_code

varchar

abhab_not_sampled.survey_type_code	FK_abhab_notsampled_survey_type R
abhab_not_sampled_active.survey_type_code	FK_abhab_notsampled_active_survey_type R
abhab_sampled.survey_type_code	FK_abhab_sampled_survey_type R
abhab_sampled_active.survey_type_code	FK_abhab_sampled_active_survey_type R
checklist_entered.survey_type_code	FK_checklist_entered_survey_type_code R
checklist_not_sampled.survey_type_code	FK_checklist_not_sampled_survey_type_code R
checklist_quatraplots_active.survey_type_code	FK_checklist_quatraplots_survey_type_code R
checklist_sampled.survey_type_code	FK_checklist_sampled_survey_type_code R
checklist_supplemental_sitewide.survey_type_code	FK_checklist_supplemental_sitewide_survey_type R
checklist_supplemental_sitewide_active.survey_type_code	FK_checklist_supplemental_sitewide_active_survey_type R
field_event_data_collectors.survey_type_code	FK_field_event_data_collectors_survey R
field_event_data_collectors_active.survey_type_code	FK_field_event_data_collectors_active_survey R
nps_entered.survey_type_code	FK_nps_entered_survey_type_code R
secondary_plot_info.survey_type_code	FK_secondary_plot_info_survey_type R
secondary_plot_info_active.survey_type_code	FK_secondary_plot_info_active_survey_type R
subsampled_plot_info.survey_type_code	FK_subsampled_plot_info_survey_type R

survey_category

enum

√

null

survey_description

varchar

300

survey_group

enum

sitewide

create_date

date

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

Indexes:

Column(s)	Type	Sort	Constraint Name
survey_type_code + survey_group	Primary key	Asc/Asc	PRIMARY