Table marinedb.non_native_species
MARINe non native invasive species list

 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
species_code varchar 6
field_event_non_native.species_code FK_field_event_non_native_active_species R
field_event_non_native_active.species_code FK_field_event_nonnative_active_species R
marine_species.species_code FK_non_native_species_code R
non_native_sort int 10
active_status enum 8
species varchar 40
common_name varchar 40
create_date date 10
modify_date timestamp 19 current_timestamp()

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

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

Close relationships  within of separation: