Table JiveCore700.public.jiveappalert 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
appalertid int8 19
jiveappalertack.appalertid jvappalertack_fk R
appid int8 19
jiveapp.appid jvappalert_fk R
code int8 19
notes varchar 1024  √  null
effectivedate int8 19  √  null
creatoruserid int8 19  √  null
creatorname varchar 1024  √  null
creationdate int8 19
modificationdate int8 19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
appalertid Primary key Asc jiveappalert_pk
appid Performance Asc jvappalert_app_idx

Close relationships  within of separation: