Table JiveCore900.public.jivetiletmplassoc 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
templateid int8 19
jivetiletemplate.templateid jivetiletp_tmpl_fk R
tileid int8 19
jivetile.tileid jivetiletp_tile_fk R
sortorder int4 10
tilecolumn int4 10 1

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

Column(s) Type Sort Constraint Name
templateid + sortorder + tileid + tilecolumn Primary key Asc/Asc/Asc/Asc jivetiletpassoc_pk
tileid Performance Asc jivetiletp_tile_ix

Close relationships  within of separation: