SchemaSpy - Table db_700clean.public.jiveinstanceapp

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

instanceappid

int8

19

jiveappinstalert.instanceappid	jvappalert_inst_fk R
jiveappview.instanceappid	jvappview_inst_fk R
jiveinstapppref.instanceappid	jivepref_app_fk R
jiveoauthstore.instanceappid	jiveoauth_appid_fk R
jiveocbmetadata.instanceappid	Implied Constraint R

appinstanceuuid

varchar

128

appid

int8

19

jiveapp.appid

jiveinstapp_app_fk R

appurl

varchar

1024

appurlmd5

varchar

127

userid

int8

19

jiveuser.userid

Implied Constraint R

locallymanaged

int2

5

1

creationdate

int8

19

modificationdate

int8

19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
instanceappid	Primary key	Asc	jiveinstncapp_pk
appinstanceuuid	Must be unique	Asc	jiveinstanceapp_appinstanceuuid_key
appurlmd5	Performance	Asc	jvinstapp_url_idx
userid	Performance	Asc	jvinstapp_user_idx