controlled_vocab_entries


Description

The order that a word or phrase used in a controlled vocabulary should appear. For example, the order of keywords in a publication.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
controlled_vocab_entry_id BIGINT 19 √ null
controlled_vocab_entry_settings.controlled_vocab_entry_id c_v_e_s_entry_idC
user_interests.controlled_vocab_entry_id user_interests_controlled_vocab_entry_id_foreignC
controlled_vocab_id BIGINT 19 null
controlled_vocabs.controlled_vocab_id controlled_vocab_entries_controlled_vocab_id_foreignC
seq DOUBLE 8,2 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc controlled_vocab_entry_id
controlled_vocab_entries_controlled_vocab_id Performance Asc controlled_vocab_id
controlled_vocab_entries_cv_id Performance Asc/Asc controlled_vocab_id + seq

Relationships

Close relationships within degrees of separation