Table JiveAnalytics800.public.jivedw_document_stats_fact 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
activity_date timestamp 29,6
content_id int8 19
views int4 10
likes int4 10
unlikes int4 10
bookmarks int4 10
unbookmarks int4 10
comments int4 10
uncomments int4 10
shares int4 10
viewers text 2147483647  √  null
unique_viewers int4 10

Analyzed at Mon Apr 27 15:39 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
content_id Performance Asc jivedw_doc_stats_ctnt_id_idx
activity_date Performance Asc jivedw_doc_stats_date_idx