SchemaSpy - Table dba8c1cmrana.public.jivedw_user_status

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

user_status_id

int8

19

jivedw_user_status_stage.user_status_id

Implied Constraint R

user_id

int8

19

jivedw_user_stage.user_id

Implied Constraint R

creation_ts

timestamp

29,6

container_id

int8

19

(-1)

container_type

int4

10

(-1)

modification_ts

timestamp

29,6

status

int4

10

2

status_type

int4

10

0

Analyzed at Fri May 09 11:35 PDT 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
user_status_id	Primary key	Asc	jivedw_user_status_pk
container_id	Performance	Asc	jvdw_usr_stts_c_id_idx
container_type	Performance	Asc	jvdw_usr_stts_c_tpe_idx
creation_ts	Performance	Asc	jvdw_usr_stts_c_ts_idx
modification_ts	Performance	Asc	jvdw_usr_stts_m_ts_idx
status_type	Performance	Asc	jvdw_usr_stts_stg_sty_idx
status	Performance	Asc	jvdw_usr_stts_sts_idx
user_id	Performance	Asc	jvdw_usr_stts_usr_id_idx