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

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 Mon Apr 27 15:39 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
day_ts + content_id + content_type	Primary key	Asc/Asc/Asc	jivedw_con_u_glb_sum_pk
content_id + content_type	Performance	Asc/Asc	jivedw_con_u_glb_con_idx