Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.mrk_biotypemapping
Translations : raw biotype->feature type/MCV, raw biotype->marker type

Generated by
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
_biotypemapping_key int4 10 primary key
_biotypevocab_key int4 10
voc_vocab._vocab_key mrk_biotypemapping__biotypevocab_key_fkey R
fk to voc_vocab; 1 of 3 provider biotype vocabs (103,104,105)
_biotypeterm_key int4 10
voc_term._term_key mrk_biotypemapping__biotypeterm_key_fkey R
fk to voc_term
_mcvterm_key int4 10
voc_term._term_key mrk_biotypemapping__mcvterm_key_fkey R
fk to voc_term where _vocab_key = 79 (Marker Category aka MCV term)
_marker_type_key int4 10
mrk_types._marker_type_key mrk_biotypemapping__marker_type_key_fkey R
fk to mrk_types
usemcvchildren int4 10 0 use feature type/MCV children to determine raw biotype conflicts
_createdby_key int4 10 1001
mgi_user._user_key mrk_biotypemapping__createdby_key_fkey R
_modifiedby_key int4 10 1001
mgi_user._user_key mrk_biotypemapping__modifiedby_key_fkey R
creation_date timestamp 29,6 now()
modification_date timestamp 29,6 now()

Table contained 226 rows at Mon May 07 06:18 EDT 2018

Column(s) Type Sort Constraint Name
_biotypemapping_key Primary key, Used to cluster data Asc mrk_biotypemapping_pkey
_biotypeterm_key Performance Asc mrk_biotypemapping_idx_biotypeterm_key
_biotypevocab_key Performance Asc mrk_biotypemapping_idx_biotypevocab_key
_createdby_key Performance Asc mrk_biotypemapping_idx_createdby_key
_marker_type_key Performance Asc mrk_biotypemapping_idx_marker_type_key
_mcvterm_key Performance Asc mrk_biotypemapping_idx_mcvterm_key
_modifiedby_key Performance Asc mrk_biotypemapping_idx_modifiedby_key

Close relationships  within of separation: