Table JiveCore800.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
jiveappsecurity.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
installorigin varchar 4 'mkt'::character varying
creationdate int8 19
modificationdate int8 19

Analyzed at Mon Apr 27 15:32 PDT 2015

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  
installorigin Performance Asc jiveapp_origin_idx  
refreshcompleted + refreshrequested Performance Asc/Asc jiveapp_refcmp_idx  
syslicenseurlmd5 Performance Asc jiveapp_sysurl_idx  

Close relationships  within of separation: