Table sbs6a.public.jivegrantedpermlvl 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
permlevelid int8 19
jivepermlevel.permlevelid jgrntprmlvl_prmid_fk R
grantedobjecttype int4 10
grantedid int8 19
targetobjecttype int4 10
targetobjectid int8 19

Table contained 29 rows at Fri Aug 24 10:15 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
grantedid + grantedobjecttype Performance Asc/Asc jgrntpmlvl_gob_idx
targetobjectid + targetobjecttype Performance Asc/Asc jgrntpmlvl_tob_idx

Close relationships  within of separation: