Table marinedb.checklist_supplemental_sitewide
other activities done at the site that are not plot specific

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_site_code R
survey_type_code varchar 30
survey_type_codes.survey_type_code FK_checklist_supplemental_sitewide_survey_type R
active_status enum 8 active
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 833 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_survey_type

Close relationships  within of separation: