Table JiveCore700.public.jiveappinstalert Generated by
SchemaSpy
Legend: SourceForge.net
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
appinstalertid int8 19
instanceappid int8 19
jiveinstanceapp.instanceappid jvappalert_inst_fk R
code int8 19
notes varchar 1024  √  null
effectivedate int8 19  √  null
creatoruserid int8 19  √  null
creatorname varchar 1024  √  null
acknowledged int8 19
creationdate int8 19
modificationdate int8 19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
appinstalertid Primary key Asc jiveinstalert_pk
instanceappid + effectivedate Performance Asc/Asc jvinstalt_inst_ix

Close relationships  within of separation: