Table JiveCore800.public.jivepoll 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
pollid int8 19
jivepolloption.pollid jivepllop_pid_fk R
objecttype int4 10
objectid int8 19
userid int8 19  √  null
jiveuser.userid Implied Constraint R
name varchar 255
jiveproperty.name Implied Constraint R
description text 2147483647  √  null
pollmode int8 19
creationdate int8 19
modificationdate int8 19
startdate int8 19
enddate int8 19
expiredate int8 19
status int4 10

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
pollid Primary key Asc jivepoll_pk
creationdate Performance Asc jivepoll_cdate_idx
enddate Performance Asc jivepoll_edate_idx
modificationdate Performance Asc jivepoll_mdate_idx
startdate Performance Asc jivepoll_sdate_idx
objectid + objecttype Performance Asc/Asc jvpll_id_type_idx
status Performance Asc jvpoll_status_idx
userid Performance Asc jvpoll_userid_idx

Close relationships  within of separation: