Table marinedb.collection_projects
list of projects that have associated species collections

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
project_code varchar 8
field_event_collections.project_code FK_field_event_collection_project R
field_event_collections_active.project_code FK_field_event_collection_active_project R
project_description varchar 200
active_status enum 8
contact_name varchar 50
contact_email varchar 100

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

Indexes:
Column(s) Type Sort Constraint Name
project_code Primary key Asc PRIMARY

Close relationships  within of separation: