Table marinedb.tided_temperature_utc_active
temperature data combined with tides and detided value used for daily seawater means from loggers in Coordinated Universal Time (UTC) for new data loading

 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
pisco_code char 6
temperature_sites.pisco_code FK_temperature_sites_tide_active R
zonetype char 3
zonetype.zonetype FK_temperature_zones_tide_active R
replicate char 3
date_utc date 10
time_utc varchar 11
temp_celsius decimal 4,2
tide_f decimal 4,2
air20_water0 enum 3
cutoff_ft varchar 10  √  null
flag int 10 0
time_format enum 4
qc_complete enum 4
create_date date 10
modify_date timestamp 19 current_timestamp()

Table contained 10,562,539 rows at Thu Apr 03 16:08 PDT 2025

Indexes:
Column(s) Type Sort Constraint Name
pisco_code + replicate + zonetype + date_utc + time_utc + temp_celsius Primary key Asc/Asc/Asc/Asc/Asc/Asc PRIMARY
zonetype Performance Asc FK_temperature_zones_tide_active

Close relationships  within of separation: