Table srdb.srdb.timeseries_values_view
This is a materialised view that organises the timeseries into separate columns.

 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
assessid varchar 200  √  null
assessment.assessid Implied Constraint R
tsyear int4 10  √  null
pt_avail int8 19  √  null
ssb float8 17,17  √  null
r float8 17,17  √  null
total float8 17,17  √  null
f float8 17,17  √  null
cpue float8 17,17  √  null
catch_landings float8 17,17  √  null

Table contained 16,308 rows at Fri Dec 09 15:00 PST 2011


Close relationships: