Table JiveCore900.public.jiveevent 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
eventid int8 19
eapisartifactupdateevents.eventid Implied Constraint R
userid int8 19
jiveuser.userid Implied Constraint R
containerid int8 19
jivecarouselcontainer.containerid Implied Constraint R
containertype int4 10
name text 2147483647
tagline text 2147483647  √  null
description text 2147483647  √  null
host text 2147483647  √  null
location text 2147483647  √  null
street text 2147483647  √  null
city text 2147483647  √  null
phone varchar 200  √  null
email varchar 200  √  null
url varchar 200  √  null
country text 2147483647  √  null
locale varchar 30  √  null
starttime int8 19
endtime int8 19
eventtype int4 10
eventaccess int4 10
creationdate int8 19
modificationdate int8 19
status int4 10
icsuid varchar 200
maxattendees int4 10  √  null
editpolicy int4 10 3

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

Indexes:
Column(s) Type Sort Constraint Name
eventid Primary key Asc jiveevent_pk
containertype + containerid Performance Asc/Asc jiveevent_cont_idx
status Performance Asc jiveevent_sts_idx
userid Performance Asc jiveevent_user_idx

Close relationships: