Table marinedb.temperature_loggers_active
temperature loggers 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
group_code varchar 8
transect_groups_active.group_code Implied Constraint R
serial_number varchar 25
local_code char 3
logger_codes.local_code FK_loggers_active_local_code R
purchase_date date 10
active_status enum 8
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 8 rows at Thu Nov 06 11:53 PST 2025

Indexes:
Column(s) Type Sort Constraint Name
group_code + serial_number + local_code Primary key Asc/Asc/Asc PRIMARY
local_code Performance Asc FK_loggers_active_local_code

Close relationships  within of separation: