SchemaSpy - Table dba8c1cmrana.public.jivedw_user_rel

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

relationship_id

int8

19

jivedw_user_rel_stage.relationship_id

Implied Constraint R

user_id

int8

19

jivedw_user_stage.user_id

Implied Constraint R

related_user_id

int8

19

relnship_type_id

int4

10

state

varchar

20

'pending_approval'::character varying

creation_ts

timestamp

29,6

modification_ts

timestamp

29,6

retirement_ts

timestamp

29,6

√

null

graph_id

int8

19

Analyzed at Fri May 09 11:35 PDT 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
relationship_id	Primary key	Asc	jivedw_usrrel_pk
user_id + related_user_id + creation_ts + graph_id	Must be unique	Asc/Asc/Asc/Asc	jvdw_usrrel_uk_idx