SchemaSpy - Table dba800.public.jivefieldvalue

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

internaldocid

int8

19

jivedocument.internaldocid

Implied Constraint R

versionid

int4

10

fieldid

int8

19

jiveprofilefield.fieldid

Implied Constraint R

numvalue

int8

19

√

null

strvalue

varchar

3500

√

null

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
internaldocid + versionid + fieldid	Performance	Asc/Asc/Asc	jfv_id_idx
numvalue	Performance	Asc	jfv_nval_idx