SchemaSpy - Table dba800.public.jiveuserrelgraph

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

graphid

int8

19

jiveuserrel.graphid	jvusrrel_fk_rlgrid R
jiveusrrelgrapr.graphid	jvusrrelga_fk_grid R
jiveusrrelgrntf.graphid	jvusrrelnt_fk_grid R

graphtypeid

int4

10

1

name

varchar

255

jiveproperty.name

Implied Constraint R

enabled

int2

5

1

labelpeer

varchar

40

√

null

labelmanager

varchar

40

√

null

labeldirrpt

varchar

40

√

null

approvalsenabled

int2

5

0

peerchoiceallowed

int2

5

0

mgrchoiceallowed

int2

5

0

drptchoiceallowed

int2

5

0

reflexive

int2

5

1

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
graphid	Primary key	Asc	jiveusrrelgrph_pk