Table JiveCore900.public.jiveuserprofile 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
userprofileid int8 19
jiveuseraltemail.userprofileid Implied Constraint R
userid int8 19
jiveuser.userid Implied Constraint R
fieldid int8 19
jiveprofilefield.fieldid jiveup_fid_fk R
levelid int8 19  √  null
jiveprofileseclvl.levelid jiveup_lid_fk R
value varchar 3500  √  null
primaryval int2 5

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

Column(s) Type Sort Constraint Name
userprofileid Primary key Asc jiveuserprofile_pk
fieldid Performance Asc jup_fldid
userid + fieldid Performance Asc/Asc jup_uid_fid_idx

Close relationships  within of separation: