Table JiveCore800.public.jivei18ntext 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
textid int8 19
objecttype int4 10
objectid int8 19
objectattribute int4 10
locale varchar 100
text varchar 2000
custom int2 5
creationdate int8 19
modificationdate int8 19
aliaskey varchar 2000  √  null
defaulttext varchar 2000  √  null

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
textid Primary key Asc jivei18ntext_pk
objecttype + objectid + objectattribute + locale Must be unique Asc/Asc/Asc/Asc jvi18ntxt_uq_idx