Table marinedb.temperature_loggers
temperature loggers

 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
temperature_log.group_code FK_log_local_code R
transect_groups_active.group_code Implied Constraint R
serial_number varchar 25
temperature_log.serial_number FK_log_local_code R
local_code char 3
temperature_log.local_code FK_log_local_code R
logger_codes.local_code FK_loggers_local_code R
purchase_date date 10
active_status enum 8 active
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 88 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_local_code

Close relationships  within of separation: