Table JiveCore800.public.jivetiletemplate 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
templateid int8 19
jivetemplatecategory.templateid Implied Constraint R
jivetilepage.templateid Implied Constraint R
jivetiletmplassoc.templateid jivetiletp_tmpl_fk R
extensionuuid varchar 48 'none'::character varying
templatename varchar 127
displayname varchar 255  √  null
userid int8 19
jiveuser.userid Implied Constraint R
subtitle varchar 127  √  null
blurb varchar 400  √  null
description varchar 4000  √  null
backgroundimageurl varchar 1024  √  null
bgcolor varchar 64  √  null
textcolor varchar 64  √  null
bgrepeat varchar 64  √  null
bgposition varchar 64  √  null
grouptype int4 10  √  null
externallyaccessible int2 5  √  null
contenttypes varchar 1500  √  null
global int4 10 0
state varchar 64 'PUBLISHED'::character varying
creationdate int8 19
modificationdate int8 19

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
templateid Primary key Asc jivetiletmpl_pk
templatename + extensionuuid Must be unique Asc/Asc jivetiletp_name_ext_ix
userid Performance Asc jivetiletp_styl_ix
displayname + userid + extensionuuid Must be unique Asc/Asc/Asc jivetiletp_usr_dnm_ext_ix

Close relationships  within of separation: