controlled_vocabs


Description

Every word or phrase used in a controlled vocabulary. Controlled vocabularies are used for submission metadata like keywords and subjects, reviewer interests, and wherever a similar dictionary of words or phrases is required. Each entry corresponds to a word or phrase like “cellular reproduction” and a type like “submissionKeyword”.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
controlled_vocab_id BIGINT 19 √ null
controlled_vocab_entries.controlled_vocab_id controlled_vocab_entries_controlled_vocab_id_foreignC
symbolic VARCHAR 64 null
assoc_type BIGINT 19 0
assoc_id BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc controlled_vocab_id
controlled_vocab_symbolic Must be unique Asc/Asc/Asc symbolic + assoc_type + assoc_id

Relationships

Close relationships within degrees of separation