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/FeatureType term)
_primarymcvterm_key int4 10
voc_term._term_key mrk_biotypemapping__primarymcvterm_key_fkey R
fk to voc_term where _vocab_key = 79 (Primary MCV/FeatureType 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
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key mrk_biotypemapping__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 191 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_biotypemapping_key Primary key 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
_primarymcvterm_key Performance Asc mrk_biotypemapping_idx_primarymcvterm_key

Close relationships  within of separation: