Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.voc_vocab
A record in this table represents a Vocabulary. Different versions of the same Vocabulary are represented by records with different names (as in GO 1.0, GO 2.0, etc).

Generated by
SchemaSpy
Legend: SourceForge.net
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
_vocab_key int4 10
dag_node_view._vocab_key Implied Constraint R
mgi_propertytype._vocab_key mgi_propertytype__vocab_key_fkey R
mgi_relationship_category._evidencevocab_key mgi_relationship_category__evidencevocab_key_fkey R
mgi_relationship_category._qualifiervocab_key mgi_relationship_category__qualifiervocab_key_fkey R
mgi_relationship_category._relationshipvocab_key mgi_relationship_category__relationshipvocab_key_fkey R
mgi_translationtype._vocab_key mgi_translationtype__vocab_key_fkey R
mrk_biotypemapping._biotypevocab_key mrk_biotypemapping__biotypevocab_key_fkey R
voc_annot_view._vocab_key Implied Constraint R
voc_annottype._evidencevocab_key voc_annottype__evidencevocab_key_fkey R
voc_annottype._qualifiervocab_key voc_annottype__qualifiervocab_key_fkey R
voc_annottype._vocab_key voc_annottype__vocab_key_fkey C
voc_term._vocab_key voc_term__vocab_key_fkey R
voc_term_cellline_view._vocab_key Implied Constraint R
voc_term_mcv_view._vocab_key Implied Constraint R
voc_term_repqualifier_view._vocab_key Implied Constraint R
voc_term_strainallele_view._vocab_key Implied Constraint R
voc_term_strainspecies_view._vocab_key Implied Constraint R
voc_term_view._vocab_key Implied Constraint R
voc_text_view._vocab_key Implied Constraint R
voc_vocab_view._vocab_key Implied Constraint R
voc_vocabdag._vocab_key voc_vocabdag__vocab_key_fkey C
voc_vocabdag_view._vocab_key Implied Constraint R
primary key
_refs_key int4 10
bib_refs._refs_key voc_vocab__refs_key_fkey R
foreign key to BIB_Refs
_logicaldb_key int4 10
acc_logicaldb._logicaldb_key voc_vocab__logicaldb_key_fkey R
foreign key to ACC_LogicalDB; identifies the logical DB for the Accession IDs of the Vocabulary Terms
issimple int2 5  √  null if 1, the Vocabulary is a simple vocabulary (no DAG), else the Vocabulary is structured (has 1 or more DAGS)
isprivate int2 5  √  null if 1, then the Accession IDs of the Vocabulary Terms are private, else they are public
name text 2147483647 vocabulary name
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 117 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_vocab_key Primary key Asc voc_vocab_pkey
name + _vocab_key Must be unique Asc/Asc voc_vocab_idx_name
_refs_key Performance Asc voc_vocab_idx_refs_key

Close relationships  within of separation: