Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
View pub.mgd.mrk_mouse_view 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
_marker_key int4 10  √  null
go_tracking._marker_key Implied Constraint R
_organism_key int4 10  √  null
_marker_status_key int4 10  √  null
mrk_status._marker_status_key Implied Constraint R
_marker_type_key int4 10  √  null
mrk_types._marker_type_key Implied Constraint R
symbol text 2147483647  √  null
name text 2147483647  √  null
chromosome text 2147483647  √  null
cytogeneticoffset text 2147483647  √  null
cmoffset float8 17,17  √  null
_createdby_key int4 10  √  null
_modifiedby_key int4 10  √  null
creation_date timestamp 29,6  √  null
modification_date timestamp 29,6  √  null
organism text 2147483647  √  null
commonname text 2147483647  √  null
latinname text 2147483647  √  null
status text 2147483647  √  null
mgiid text 2147483647  √  null
prefixpart text 2147483647  √  null
acc_accessionmax.prefixpart Implied Constraint R
numericpart int4 10  √  null
_accession_key int4 10  √  null
acc_accession._accession_key Implied Constraint R
markertype text 2147483647  √  null

Analyzed at Mon Sep 11 06:12 EDT 2023


Close relationships: