Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.voc_term
A record in this table represents a Vocabulary Term for a specific Vocabulary. There is one big bucket of Terms for each Vocabulary. A Term can appear in 0 or more DAGS within the same Vocabulary. Remember that a Term is an accessionable object, so there is a corresponding entry for this table in ACC_MGIType.

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
_term_key int4 10
all_allele._allele_status_key all_allele__allele_status_key_fkey R
all_allele._allele_type_key all_allele__allele_type_key_fkey R
all_allele._collection_key all_allele__collection_key_fkey R
all_allele._markerallele_status_key all_allele__markerallele_status_key_fkey R
all_allele._mode_key all_allele__mode_key_fkey R
all_allele._transmission_key all_allele__transmission_key_fkey R
all_allele_mutation._mutation_key all_allele_mutation__mutation_key_fkey R
all_cellline._cellline_type_key all_cellline__cellline_type_key_fkey R
all_cellline_derivation._creator_key all_cellline_derivation__creator_key_fkey R
all_cellline_derivation._derivationtype_key all_cellline_derivation__derivationtype_key_fkey R
all_cellline_derivation._vector_key all_cellline_derivation__vector_key_fkey R
all_cellline_derivation._vectortype_key all_cellline_derivation__vectortype_key_fkey R
all_cre_cache._allele_type_key all_cre_cache__allele_type_key_fkey C
all_cre_cache._emapa_term_key all_cre_cache__emapa_term_key_fkey C
bib_refs._referencetype_key bib_refs__referencetype_key_fkey R
gxd_allelepair._compound_key gxd_allelepair__compound_key_fkey R
gxd_allelepair._pairstate_key gxd_allelepair__pairstate_key_fkey R
gxd_assay._reportergene_key gxd_assay__reportergene_key_fkey R
gxd_expression._emapa_term_key gxd_expression__emapa_term_key_fkey C
gxd_gellanestructure._emapa_term_key gxd_gellanestructure__emapa_term_key_fkey R
gxd_genotype._existsas_key gxd_genotype__existsas_key_fkey R
gxd_htexperiment._curationstate_key gxd_htexperiment__curationstate_key_fkey R
gxd_htexperiment._evaluationstate_key gxd_htexperiment__evaluationstate_key_fkey R
gxd_htexperiment._experimenttype_key gxd_htexperiment__experimenttype_key_fkey R
gxd_htexperiment._source_key gxd_htexperiment__source_key_fkey R
gxd_htexperiment._studytype_key gxd_htexperiment__studytype_key_fkey R
gxd_htexperimentvariable._term_key gxd_htexperimentvariable__term_key_fkey R
gxd_htsample._emapa_key gxd_htsample__emapa_key_fkey R
gxd_htsample._relevance_key gxd_htsample__relevance_key_fkey R
gxd_htsample._sex_key gxd_htsample__sex_key_fkey R
gxd_index._priority_key gxd_index__priority_key_fkey R
gxd_index_stages._indexassay_key gxd_index_stages__indexassay_key_fkey R
gxd_index_stages._stageid_key gxd_index_stages__stageid_key_fkey R
gxd_isresultstructure._emapa_term_key gxd_isresultstructure__emapa_term_key_fkey R
img_image._imageclass_key img_image__imageclass_key_fkey R
img_image._imagetype_key img_image__imagetype_key_fkey R
map_coordinate._maptype_key map_coordinate__maptype_key_fkey R
map_coordinate._units_key map_coordinate__units_key_fkey R
mgi_property._propertyterm_key mgi_property__propertyterm_key_fkey R
mgi_relationship._evidence_key mgi_relationship__evidence_key_fkey R
mgi_relationship._qualifier_key mgi_relationship__qualifier_key_fkey R
mgi_relationship._relationshipterm_key mgi_relationship__relationshipterm_key_fkey R
mgi_relationship_property._propertyname_key mgi_relationship_property__propertyname_key_fkey R
mgi_roletask._role_key mgi_roletask__role_key_fkey R
mgi_roletask._task_key mgi_roletask__task_key_fkey R
mgi_user._group_key mgi_user__group_key_fkey R
mgi_user._userstatus_key mgi_user__userstatus_key_fkey R
mgi_user._usertype_key mgi_user__usertype_key_fkey R
mgi_userrole._role_key mgi_userrole__role_key_fkey R
mrk_biotypemapping._biotypeterm_key mrk_biotypemapping__biotypeterm_key_fkey R
mrk_biotypemapping._mcvterm_key mrk_biotypemapping__mcvterm_key_fkey R
mrk_cluster._clustersource_key mrk_cluster__clustersource_key_fkey R
mrk_cluster._clustertype_key mrk_cluster__clustertype_key_fkey R
mrk_do_cache._term_key mrk_do_cache__term_key_fkey C
prb_probe._segmenttype_key prb_probe__segmenttype_key_fkey R
prb_probe._vector_key prb_probe__vector_key_fkey R
prb_source._cellline_key prb_source__cellline_key_fkey R
prb_source._gender_key prb_source__gender_key_fkey R
prb_source._segmenttype_key prb_source__segmenttype_key_fkey R
prb_source._vector_key prb_source__vector_key_fkey R
prb_strain._species_key prb_strain__species_key_fkey R
prb_strain._straintype_key prb_strain__straintype_key_fkey R
prb_strain_genotype._qualifier_key prb_strain_genotype__qualifier_key_fkey R
prb_strain_marker._qualifier_key prb_strain_marker__qualifier_key_fkey R
seq_allele_assoc._qualifier_key seq_allele_assoc__qualifier_key_fkey R
seq_genetrap._reversecomp_key seq_genetrap__reversecomp_key_fkey R
seq_genetrap._tagmethod_key seq_genetrap__tagmethod_key_fkey R
seq_genetrap._vectorend_key seq_genetrap__vectorend_key_fkey R
seq_marker_cache._biotypeconflict_key seq_marker_cache__biotypeconflict_key_fkey C
seq_marker_cache._qualifier_key seq_marker_cache__qualifier_key_fkey C
seq_marker_cache._sequenceprovider_key seq_marker_cache__sequenceprovider_key_fkey C
seq_marker_cache._sequencetype_key seq_marker_cache__sequencetype_key_fkey C
seq_sequence._sequenceprovider_key seq_sequence__sequenceprovider_key_fkey R
seq_sequence._sequencequality_key seq_sequence__sequencequality_key_fkey R
seq_sequence._sequencestatus_key seq_sequence__sequencestatus_key_fkey R
seq_sequence._sequencetype_key seq_sequence__sequencetype_key_fkey R
seq_sequence_assoc._qualifier_key seq_sequence_assoc__qualifier_key_fkey R
voc_allele_cache._term_key voc_allele_cache__term_key_fkey R
voc_annot._qualifier_key voc_annot__qualifier_key_fkey R
voc_annot._term_key voc_annot__term_key_fkey R
voc_annot_count_cache._term_key voc_annot_count_cache__term_key_fkey R
voc_annotheader._term_key voc_annotheader__term_key_fkey R
voc_evidence._evidenceterm_key voc_evidence__evidenceterm_key_fkey R
voc_evidence_property._propertyterm_key voc_evidence_property__propertyterm_key_fkey R
voc_go_cache._term_key voc_go_cache__term_key_fkey C
voc_marker_cache._term_key voc_marker_cache__term_key_fkey R
voc_term_emapa._defaultparent_key voc_term_emapa__defaultparent_key_fkey C
voc_term_emapa._term_key voc_term_emapa__term_key_fkey C
voc_term_emaps._defaultparent_key voc_term_emaps__defaultparent_key_fkey C
voc_term_emaps._emapa_term_key voc_term_emaps__emapa_term_key_fkey C
voc_term_emaps._term_key voc_term_emaps__term_key_fkey C
voc_text._term_key voc_text__term_key_fkey C
primary key
_vocab_key int4 10
voc_vocab._vocab_key voc_term__vocab_key_fkey R
foreign key to VOC_Vocab
term text 2147483647  √  null term
abbreviation text 2147483647  √  null abbervated term
sequencenum int4 10  √  null enables us to define an ordered list of Terms for a Vocabulary which contains 0 DAGS. for structured vocabularies, the sequenceNum is null
isobsolete int2 5  √  null if 1, the term is obsolete and cannot be used in future annotations
_createdby_key int4 10 1001
mgi_user._user_key voc_term__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key voc_term__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 227,222 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_term_key Primary key Asc voc_term_pkey
lower(term) Performance Asc voc_term_0
_vocab_key + sequencenum + term + _term_key Performance Asc/Asc/Asc/Asc voc_term_idx_clustered
_createdby_key Performance Asc voc_term_idx_createdby_key
_modifiedby_key Performance Asc voc_term_idx_modifiedby_key
term + _term_key + _vocab_key Performance Asc/Asc/Asc voc_term_idx_term
_vocab_key Performance Asc voc_term_idx_vocab_key

Close relationships  within of separation: