Table JiveEAE700.public.jiveuserexclusions 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
id bigserial 19  √  nextval('jiveusrexcl_id_seq'::regclass)
objecttype int4 10
objectid int8 19
contexttype int4 10
contextid int8 19
sourcetype int4 10
sourceid int8 19
exclusiontype int4 10
time int8 19
userid int8 19

Analyzed at Fri Dec 20 10:15 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc jiveusrexc_pk
userid Performance Asc jiveusrexc_idx1
exclusiontype + objecttype + objectid Performance Asc/Asc/Asc jiveusrexc_idx2
exclusiontype + contexttype + contextid Performance Asc/Asc/Asc jiveusrexc_idx3
exclusiontype + sourcetype + sourceid Performance Asc/Asc/Asc jiveusrexc_idx4