Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.voc_term_emaps
A record in this table represents additional information about EMAPS (Theiler stage specific) structured vocabulary terms. Each term has a Theiler stage, an EMAPA term and a default parent (or null if root term).
See VOC_Term._Vocab_key = 91

 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_subtype_view._term_key Implied Constraint R
prb_strain_attribute_view._term_key Implied Constraint R
prb_strain_needsreview_view._term_key Implied Constraint R
voc_annot_view._term_key Implied Constraint R
voc_term_repqualifier_view._term_key Implied Constraint R
voc_term_view._term_key Implied Constraint R
voc_termfamily_view._term_key Implied Constraint R
voc_term._term_key voc_term_emaps__term_key_fkey C
The EMAPS term
_stage_key int4 10
gxd_theilerstage._stage_key voc_term_emaps__stage_key_fkey R
The theiler stage for this EMAPS term
_defaultparent_key int4 10  √  null
voc_term._term_key voc_term_emaps__defaultparent_key_fkey C
An EMAPS term can have multiple parents, this defines the single default.
_emapa_term_key int4 10
voc_term._term_key voc_term_emaps__emapa_term_key_fkey C
The EMAPA term
_createdby_key int4 10 1001
mgi_user._user_key voc_term_emaps__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key voc_term_emaps__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 35,964 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort Constraint Name
_term_key Primary key Asc voc_term_emaps_pkey
_createdby_key Performance Asc voc_term_emaps_idx_createdby_key
_emapa_term_key Performance Asc voc_term_emaps_idx_emapa
_modifiedby_key Performance Asc voc_term_emaps_idx_modifiedby_key
_defaultparent_key Performance Asc voc_term_emaps_idx_parent
_stage_key Performance Asc voc_term_emaps_idx_stage_key

Close relationships  within of separation: