Table term
Terms in a taxonomy

Legend:
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
id int8 19
term.parent_id fk36446c4849bf4b R
term_attributes.term_id fka9f4ff0a7808d449 R
full_value varchar 4000  √  null
lft int4 10  √  null
rht int4 10  √  null
uuid varchar 40
value varchar 1024
value_hash varchar 32  √  null
parent_id int8 19  √  null
term.id fk36446c4849bf4b R
taxonomy_id int8 19
taxonomy.id fk36446c97aac22 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc term_pkey
lft Performance Asc term_left_position
parent_id Performance Asc term_parent
rht Performance Asc term_right_position
taxonomy_id Performance Asc term_taxonomy
taxonomy_id + parent_id + value_hash Must be unique Asc/Asc/Asc term_taxonomy_id_parent_id_value_hash_key
uuid Performance Asc termuuidindex

Close relationships  within of separation: