SchemaSpy - Table dba800a.public.jivedw_content_summary

Generated by
SchemaSpy

Legend:

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

day_ts

timestamp

29,6

jivedw_adoption_u_glb_summary.day_ts

Implied Constraint R

user_id

int8

19

jivedw_user_stage.user_id

Implied Constraint R

container_id

int8

19

container_type

int4

10

document_count

int8

19

thread_count

int8

19

blog_post_count

int8

19

poll_count

int8

19

idea_count

int8

19

video_count

int8

19

status_count

int8

19

question_count

int8

19

question_responded_count

int8

19

question_helped_count

int8

19

question_resolved_count

int8

19

Analyzed at Mon Apr 27 15:39 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
day_ts + user_id + container_id + container_type	Primary key	Asc/Asc/Asc/Asc	jivedw_content_sum_pk
container_id + container_type	Performance	Asc/Asc	jivedw_cont_cnt_idx
user_id	Performance	Asc	jivedw_cont_usr_idx