Table topp.deprecated.session 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
sessionid int4 10
best_file_name_table.sessionid Implied Constraint R
bestsessionstable.sessionid Implied Constraint R
daylocationdatagf.sessionid Implied Constraint R
daylocationdatagl.sessionid Implied Constraint R
daylocationdatalf.sessionid Implied Constraint R
daylogdata.sessionid Implied Constraint R
dctimeseriesdata.sessionid Implied Constraint R
depthtemperaturedatadt.sessionid Implied Constraint R
files.sessionid Implied Constraint R
pendata.sessionid Implied Constraint R
updates.sessionid Implied Constraint R
tagprocessingeventid int4 10  √  null
dataprocessing.tagprocessingeventid Implied Constraint R
toppid text 2147483647  √  null
tagnumber text 2147483647  √  null

Table contained 758 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
sessionid Primary key Asc session_pkey  
tagprocessingeventid + toppid + tagnumber Must be unique Asc/Asc/Asc sessionuniqueattributes These unique columns are also nullable

Close relationships: