Table JiveCore700.public.jiveapp 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
appid int8 19
jiveappaction.appid jiveappact_appid_fk R
jiveappalert.appid jvappalert_fk R
jiveapperror.appid Implied Constraint R
jiveinstanceapp.appid jiveinstapp_app_fk R
appuuid varchar 127
apppath varchar 127  √  null
systemlicenseurl varchar 1024  √  null
syslicenseurlmd5 varchar 127  √  null
gadgethash varchar 127  √  null
internalname varchar 255  √  null
developmentapp int2 5 0
refreshrequested int8 19 (-1)
refreshstarted int8 19 (-1)
refreshcompleted int8 19 (-1)
refreshstate varchar 5 'never'::character varying
extensionuuid varchar 127  √  null
installtype int2 5 0
creationdate int8 19
modificationdate int8 19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name Anomalies
appid Primary key Asc jiveapp__pk  
apppath Must be unique Asc jiveapp_apppath_key This unique column is also nullable
appuuid Must be unique Asc jiveapp_appuuid_key  
refreshcompleted + refreshrequested Performance Asc/Asc jiveapp_refcmp_idx  

Close relationships  within of separation: