Table JiveCore900.public.jiveuuid 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
uuid varchar 128
jivebridgedcont.uuid Implied Constraint R
jivebridgeuser.uuid Implied Constraint R
jivermtbridgedcont.uuid Implied Constraint R
jiveuuidext.uuid Implied Constraint R
objectid int8 19  √  null
spremotedoctranslation.objectid Implied Constraint R
objecttype int4 10  √  null
version int4 10  √  null
longid int8 19

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

Column(s) Type Sort Constraint Name Anomalies
uuid Primary key Asc jiveuuid_pk  
objectid + objecttype + version Must be unique Asc/Asc/Asc jiveuuid_jo_uk These unique columns are also nullable
longid Must be unique Asc jiveuuid_longid_key  

Close relationships: