SchemaSpy - Table db_700clean.public.jiveuserrel

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

relationshipid

int8

19

jiveusrrellistmap.relationshipid

jvurlstlm_fk_relid R

userid

int8

19

jiveuser.userid

jvusrrel_fk_usrid R

relateduserid

int8

19

jiveuser.userid

jvusrrel_fk_rlusid R

relnshiptypeid

int4

10

2

state

varchar

20

'pending_approval'::character varying

creationdate

int8

19

retirementdate

int8

19

√

0

graphid

int8

19

jiveuserrelgraph.graphid

jvusrrel_fk_rlgrid R

workflowid

int8

19

√

null

modificationdate

int8

19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
relationshipid	Primary key	Asc	jiveusrrel_pk
relateduserid	Performance	Asc	jvusrrel_relid_idx
userid + relateduserid + creationdate + graphid	Must be unique	Asc/Asc/Asc/Asc	jvusrrel_uk_idx