SchemaSpy - Table dba800.public.jivedvrevartifact

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

instanceid

varchar

255

revisionid

int8

19

jivedvrevision.revisionid

jivedvrvar_fk R

artifacttype

varchar

20

page

int4

10

filename

varchar

255

√

null

filesize

int4

10

contenttype

varchar

100

√

null

creationdate

int8

19

modificationdate

int8

19

exstorageid

int8

19

√

null

jivestoragemember.exstorageid

Implied Constraint R

storagekeyversion

int4

10

1

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
revisionid + artifacttype + page	Must be unique	Asc/Asc/Asc	jivedvrvar_uk_idx