Table marinedb.checklist_supplemental_sitewide_active
other activities done at the site that are not plot specific for data entry

Generated by
SchemaSpy
Legend: SourceForge.net
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 6
marine_sites.site_code FK_checklist_supplemental_sitewide_active_site_code R
survey_type_code varchar 30
survey_type_codes.survey_type_code FK_checklist_supplemental_sitewide_active_survey_type R

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

Indexes:
Column(s) Type Sort Constraint Name
site_code + survey_type_code Primary key Asc/Asc PRIMARY
survey_type_code Performance Asc FK_checklist_supplemental_sitewide_active_survey_type

Close relationships  within of separation: