Table setoopifeae.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

Table contained 0 rows at Fri Jan 13 12:19 PST 2017

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