SchemaSpy - Table dba8c1cmrana.public.jivedw_content_glb_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

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 Fri May 09 11:35 PDT 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
day_ts + user_id + username + content_id + content_type	Primary key	Asc/Asc/Asc/Asc/Asc	jivedw_con_glb_sum_pk
content_id + content_type	Performance	Asc/Asc	jivedw_con_glb_con_idx
user_id + username	Performance	Asc/Asc	jivedw_con_glb_usr_idx