SchemaSpy - Table setoopifan.public.jivedw_activity_agg_user

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

month_id

int4

activity_type

int4

direct_object_type

int4

direct_dw_object_id

int8

indirect_object_type

int4

√

null

indirect_dw_object_id

int8

√

null

dw_container_id

int8

√

null

jivedw_container.dw_container_id

Implied Constraint R

activity_count

int4

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

Indexes:

Column(s)	Type	Sort	Constraint Name
activity_type	Performance	Asc	jivedw_actaggusrm_acttype_idx
dw_container_id	Performance	Asc	jivedw_actaggusrm_cont_idx
direct_dw_object_id	Performance	Asc	jivedw_actaggusrm_doid_idx
direct_object_type	Performance	Asc	jivedw_actaggusrm_dot_idx
indirect_dw_object_id	Performance	Asc	jivedw_actaggusrm_ioid_idx
indirect_object_type	Performance	Asc	jivedw_actaggusrm_iot_idx
month_id	Performance	Asc	jivedw_actaggusrm_month_idx