Table mob_odm2.odm2.categoricalresultvalues 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
valueid bigserial 19  √  nextval('odm2.categoricalresultvalues_valueid_seq'::regclass)
categoricalresultvalueannotations.valueid fk_categoricalresultvalueannotations_categoricalresultvalues C
resultid int8 19
categoricalresults.resultid fk_categoricalresultvalues_categoricalresults C
datavalue varchar 255
valuedatetime timestamp 29,6
valuedatetimeutcoffset int4 10

Table contained 0 rows at Fri Mar 08 15:58 PST 2019

Indexes:
Column(s) Type Sort Constraint Name
valueid Primary key Asc categoricalresultvalues_pkey
resultid + datavalue + valuedatetime + valuedatetimeutcoffset Must be unique Asc/Asc/Asc/Asc categoricalresultvalues_resultid_datavalue_valuedatetime_va_key

Close relationships  within of separation: