SchemaSpy - Table dba8c1cmrana.public.jivedw_activity_fact

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

activity_ts

timestamp

29,6

day_id

int4

10

user_id

int8

19

jivedw_user_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

metadata

text

2147483647

√

null

Analyzed at Fri May 09 11:35 PDT 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
activity_type	Performance	Asc	jivedw_activity_acttype_idx
dw_container_id	Performance	Asc	jivedw_activity_cont_idx
day_id	Performance	Asc	jivedw_activity_day_idx
direct_dw_object_id	Performance	Asc	jivedw_activity_doid_idx
direct_object_type	Performance	Asc	jivedw_activity_dot_idx
indirect_dw_object_id	Performance	Asc	jivedw_activity_ioid_idx
indirect_object_type	Performance	Asc	jivedw_activity_iot_idx
activity_ts	Performance	Asc	jivedw_activity_ts_idx
user_id	Performance	Asc	jivedw_activity_user_id_idx