Table marinedb.marine_lumping_codes
MARINe lumping codes table

 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
lumping_code varchar 10
marine_species_lumping.nps_photo_lump_1999_present FK_marine_species_lump_nps_photo_1999 R
marine_species_lumping.nps_photo_lump_2004_present FK_marine_species_lump_nps_photo_2004 R
marine_species_lumping.nps_photo_lump_all_years FK_marine_species_lump_nps_photo_allyrs R
marine_species_lumping.nps_transect_lump_2003_present FK_marine_species_lump_nps_tran_2003 R
marine_species_lumping.nps_transect_lump_all_years FK_marine_species_lump_nps_tran_allyrs R
marine_species_lumping.primary_species_lump_photo FK_marine_species_lump_primary_lump_photo R
marine_species_lumping.primary_species_lump_transects FK_marine_species_lump_primary_lump_tran R
marine_species_lumping.red_turf_lump FK_marine_species_lump_red_turf_lump R
marine_species_lumping.target_lump FK_marine_species_lump_target_lump R
marine_species_lumping.web_graph_lump FK_marine_species_lump_web_graph_lump R
lumping_name varchar 50
comments varchar 100  √  null
create_date date 10
modify_date timestamp 19 current_timestamp()

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

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

Close relationships  within of separation: