controlled_vocabs

0 rows


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 bigserial 19 √ nextval('controlled_vocabs_controlled_vocab_id_seq'::regclass)
controlled_vocab_entries.controlled_vocab_id controlled_vocab_entries_controlled_vocab_id_foreignC
symbolic varchar 64 null
assoc_type int8 19 '0'::bigint
assoc_id int8 19 '0'::bigint

Indexes

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