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

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

Column(s) Type Sort Constraint Name
id Primary key Asc pushregistrationkey_idx
devicetype + devicetoken Performance Asc/Asc jivempr_dtype_dtoken_idx
userid Performance Asc pushregistrationbyuserid

Close relationships  within of separation: