SchemaSpy - Table dba800a.public.jivedw_content_grp_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

username

varchar

100

content_id

int8

19

content_type

int4

10

container_id

int8

19

view_count

int4

10

response_count

int4

10

modify_count

int4

10

like_count

int4

10

rate_count

int4

10

mention_count

int4

10

follow_count

int4

10

bookmark_count

int4

10

Analyzed at Mon Apr 27 15:39 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
day_ts + user_id + username + content_id + content_type + container_id	Primary key	Asc/Asc/Asc/Asc/Asc/Asc	jivedw_con_grp_sum_pk
container_id	Performance	Asc	jivedw_con_grp_cnt_idx
content_id + content_type	Performance	Asc/Asc	jivedw_con_grp_con_idx
user_id + username	Performance	Asc/Asc	jivedw_con_grp_usr_idx