Table JiveCore700.public.jiveuuid 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
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
objecttype int4 10  √  null
version int4 10  √  null
longid int8 19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
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: