SchemaSpy - Table db_700clean.public.jiveuserprofile

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

userprofileid

int8

19

userid

int8

19

jiveuser.userid

Implied Constraint R

fieldid

int8

19

jiveprofilefield.fieldid

jiveup_fid_fk R

levelid

int8

19

√

null

jiveprofileseclvl.levelid

jiveup_lid_fk R

value

varchar

3500

√

null

primaryval

int2

5

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
userprofileid	Primary key	Asc	jiveuserprofile_pk
fieldid	Performance	Asc	jup_fldid
userid + fieldid	Performance	Asc/Asc	jup_uid_fid_idx