SchemaSpy - Table db_700clean.public.jivedemoreco

Generated by
SchemaSpy

Legend:

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

peoplescore

float8

17,17

topicsscore

float8

17,17

popularityscore

float8

17,17

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:

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