Table JiveCore800.public.jivemobilepushregistration 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
id int8 19
jivewfentry.id Implied Constraint R
devicetype int4 10
devicetoken varchar 256
deviceapilevel int4 10 1
userid int8 19
jiveuser.userid push_user_fk_id R
pushpreference varchar 20  √  null
devicefeatureflags int4 10 1

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc pushregistrationkey_idx
devicetype + devicetoken + userid Must be unique Asc/Asc/Asc unique_push_device

Close relationships  within of separation: