Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.voc_term 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 R
all_allele._allele_type_key all_allele__allele_type_key R
all_allele._mode_key all_allele__mode_key R
all_allele._transmission_key all_allele__transmission_key R
all_allele_mutation._mutation_key all_allele_mutation__mutation_key R
all_cellline._cellline_type_key all_cellline__cellline_type_key R
all_cellline_derivation._creator_key all_cellline_derivation__creator_key R
all_cellline_derivation._derivationtype_key all_cellline_derivation__derivationtype_key R
all_cellline_derivation._vector_key all_cellline_derivation__vector_key R
all_cellline_derivation._vectortype_key all_cellline_derivation__vectortype_key R
all_cre_cache._allele_type_key all_cre_cache__allele_type_key R
all_cre_cache._system_key all_cre_cache__system_key R
all_marker_assoc._qualifier_key all_marker_assoc__qualifier_key R
all_marker_assoc._status_key all_marker_assoc__status_key R
gxd_allelepair._compound_key gxd_allelepair__compound_key R
gxd_allelepair._pairstate_key gxd_allelepair__pairstate_key R
gxd_assay._reportergene_key gxd_assay__reportergene_key R
gxd_genotype._existsas_key gxd_genotype__existsas_key R
gxd_index._priority_key gxd_index__priority_key R
gxd_index_stages._indexassay_key gxd_index_stages__indexassay_key R
gxd_index_stages._stageid_key gxd_index_stages__stageid_key R
gxd_structure._system_key gxd_structure__system_key R
gxd_theilerstage._defaultsystem_key gxd_theilerstage__defaultsystem_key R
img_image._imageclass_key img_image__imageclass_key R
img_image._imagetype_key img_image__imagetype_key R
map_coordinate._maptype_key map_coordinate__maptype_key R
map_coordinate._units_key map_coordinate__units_key R
mgi_roletask._role_key mgi_roletask__role_key R
mgi_roletask._task_key mgi_roletask__task_key R
mgi_user._userstatus_key mgi_user__userstatus_key R
mgi_user._usertype_key mgi_user__usertype_key R
mgi_userrole._role_key mgi_userrole__role_key R
mgi_vocassociation._term_key_1 mgi_vocassociation__term_key_1 R
mgi_vocassociation._term_key_2 mgi_vocassociation__term_key_2 R
mrk_marker._curationstate_key mrk_marker__curationstate_key R
mrk_omim_cache._term_key mrk_omim_cache__term_key R
prb_probe._segmenttype_key prb_probe__segmenttype_key R
prb_probe._vector_key prb_probe__vector_key R
prb_source._cellline_key prb_source__cellline_key R
prb_source._gender_key prb_source__gender_key R
prb_source._segmenttype_key prb_source__segmenttype_key R
prb_source._vector_key prb_source__vector_key R
prb_strain._species_key prb_strain__species_key R
prb_strain._straintype_key prb_strain__straintype_key R
prb_strain_genotype._qualifier_key prb_strain_genotype__qualifier_key R
prb_strain_marker._qualifier_key prb_strain_marker__qualifier_key R
seq_allele_assoc._qualifier_key seq_allele_assoc__qualifier_key R
seq_genetrap._reversecomp_key seq_genetrap__reversecomp_key R
seq_genetrap._tagmethod_key seq_genetrap__tagmethod_key R
seq_genetrap._vectorend_key seq_genetrap__vectorend_key R
seq_marker_cache._biotypeconflict_key seq_marker_cache__biotypeconflict_key R
seq_marker_cache._qualifier_key seq_marker_cache__qualifier_key R
seq_marker_cache._sequenceprovider_key seq_marker_cache__sequenceprovider_key R
seq_marker_cache._sequencetype_key seq_marker_cache__sequencetype_key R
seq_sequence._sequenceprovider_key seq_sequence__sequenceprovider_key R
seq_sequence._sequencequality_key seq_sequence__sequencequality_key R
seq_sequence._sequencestatus_key seq_sequence__sequencestatus_key R
seq_sequence._sequencetype_key seq_sequence__sequencetype_key R
seq_sequence_assoc._qualifier_key seq_sequence_assoc__qualifier_key R
voc_allele_cache._term_key Implied Constraint R
voc_annot._term_key voc_annot__term_key R
voc_annot_count_cache._term_key Implied Constraint R
voc_annotheader._term_key voc_annotheader__term_key R
voc_evidence._evidenceterm_key voc_evidence__evidenceterm_key R
voc_evidence_property._propertyterm_key voc_evidence_property__propertyterm_key R
voc_go_cache._term_key voc_go_cache__term_key R
voc_marker_cache._term_key Implied Constraint R
voc_text._term_key voc_text__term_key R
_vocab_key int4 10
voc_vocab._vocab_key voc_term__vocab_key R
term varchar 255  √  null
abbreviation varchar 255  √  null
sequencenum int4 10  √  null
isobsolete int2 5
_createdby_key int4 10
mgi_user._user_key voc_term__createdby_key R
_modifiedby_key int4 10
mgi_user._user_key voc_term__modifiedby_key R
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 95,180 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_term_key Primary key Asc voc_term_pkey
_term_key Must be unique Asc voc_term_idx_term_key
lower(term) Performance Asc voc_term_0
_createdby_key Performance Asc voc_term_idx_createdby_key
_modifiedby_key Performance Asc voc_term_idx_modifiedby_key
_vocab_key + sequencenum + term + _term_key Performance Asc/Asc/Asc/Asc voc_term_idx_primary
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: