Table JiveCore900.public.jivedemoreco Generated by
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
demorecoid int8 19
recotype int4 10
recoindex int4 10
userid int8 19
jiveuser.userid Implied Constraint R
objecttype int4 10
objectid int8 19
spremotedoctranslation.objectid Implied Constraint R
peoplescore float8 17,17
topicsscore float8 17,17
popularityscore float8 17,17

Table contained 0 rows at Fri Jan 13 13:20 PST 2017

Column(s) Type Sort Constraint Name
demorecoid Primary key Asc jivedr_pk
userid + recotype + recoindex Performance Asc/Asc/Asc jivedr_typeindex_idx

Close relationships: