Table JiveAnalytics900.public.jivedw_activity_agg_month Generated by
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
month_id int4 10
user_id int8 19
jivedw_userprofile_clear_stage.user_id Implied Constraint R
activity_type int4 10
direct_object_type int4 10
direct_dw_object_id int8 19
indirect_object_type int4 10  √  null
indirect_dw_object_id int8 19  √  null
dw_container_id int8 19  √  null
jivedw_container.dw_container_id Implied Constraint R
activity_count int4 10

Table contained 380 rows at Fri Jan 13 13:27 PST 2017

Column(s) Type Sort Constraint Name
activity_type Performance Asc jivedw_actaggmonth_acttype_idx
dw_container_id Performance Asc jivedw_actaggmonth_cont_idx
direct_dw_object_id Performance Asc jivedw_actaggmonth_doid_idx
direct_object_type Performance Asc jivedw_actaggmonth_dot_idx
indirect_dw_object_id Performance Asc jivedw_actaggmonth_ioid_idx
indirect_object_type Performance Asc jivedw_actaggmonth_iot_idx
month_id Performance Asc jivedw_actaggmonth_month_idx
user_id Performance Asc jivedw_actaggmonth_user_id_idx

Close relationships: