controlled_vocab_entries

0 rows


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 bigserial 19 √ nextval('controlled_vocab_entries_controlled_vocab_entry_id_seq'::regclass)
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 int8 19 null
controlled_vocabs.controlled_vocab_id controlled_vocab_entries_controlled_vocab_id_foreignC
seq float8 17,17 √ null

Indexes

Constraint Name Type Sort Column(s)
controlled_vocab_entries_pkey 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