Table JiveCore900.public.jivedoctype 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
typeid int8 19
jiveapprovalwrkflw.typeid Implied Constraint R
jiveattachsettings.typeid jatts_typeid_fk R
jiveattachtypes.typeid jattt_typeid_fk R
jivedocbodyconfig.typeid jdbc_typeid_fk R
jivedocbodytypes.typeid jdbt_typeid_fk R
jivedoctypeelement.documenttypeid jdte_dtid_fk R
jivedoctypeprop.typeid jdtprp_tid_fk R
jivedocument.typeid jd_typeid_fk R
jivetypevldtrprop.typeid jtvprp_tid_fk R
name varchar 100
description varchar 1000  √  null
presenterid int8 19  √  null
jivepresenter.presenterid Implied Constraint R
validator varchar 255  √  null
typeindex int4 10

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

Indexes:
Column(s) Type Sort Constraint Name
typeid Primary key Asc jivedoctype_pk

Close relationships  within of separation: