Table JiveCore900.public.jiveuserperm 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
objecttype int4 10
objectid int8 19
spremotedoctranslation.objectid Implied Constraint R
userid int8 19
jiveuser.userid Implied Constraint R
permissiontype int4 10
permission int4 10

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

Column(s) Type Sort Constraint Name
objecttype + objectid Performance Asc/Asc jvusrprm_objct_idx
userid Performance Asc jvusrprm_usrid_idx

Close relationships: