Table JiveCore900.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
spremotedoctranslation.objectid Implied Constraint R
userid int8 19  √  null
jiveuser.userid Implied Constraint R
name varchar 255
jivepermmask.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

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

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: