Table JiveCore900.public.jiveapp Generated by
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'::integer
refreshstarted int8 19 '-1'::integer
refreshcompleted int8 19 '-1'::integer
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

Table contained 0 rows at Fri Jan 13 13:20 PST 2017

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: