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

container_id

int8

19

container_type

int4

10

view_count

int4

10

create_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 + container_id + container_type	Primary key	Asc/Asc/Asc/Asc/Asc	jivedw_plc_sum_pk
container_id + container_type	Performance	Asc/Asc	jivedw_plc_con_idx
user_id + username	Performance	Asc/Asc	jivedw_plc_usr_idx