Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.mrk_location_cache
A record in this table represents the cached value of a Marker and its genetic and physical location. See mrkcacheload/mrklocation.csh.

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
_cache_key int4 10
seq_marker_cache._cache_key Implied Constraint R
primary key
_marker_key int4 10
mrk_marker._marker_key mrk_location_cache__marker_key_fkey C
foreign key to MRK_Marker
_marker_type_key int4 10
mrk_types._marker_type_key Implied Constraint R
foreign key to MRK_Types
_organism_key int4 10
mgi_organism._organism_key mrk_location_cache__organism_key_fkey R
foreign key to MGI_Organism
chromosome text 2147483647 chromosome
sequencenum int4 10 chromosome order
cytogeneticoffset text 2147483647  √  null cytogenetic cmOffset
cmoffset float8 17,17  √  null cytogenetic cmOffset
genomicchromosome text 2147483647  √  null chromosome
startcoordinate float8 17,17  √  null start genome coordinate
endcoordinate float8 17,17  √  null end genome coordinate
strand bpchar 1  √  null strand for genome coordinate
mapunits text 2147483647  √  null units of genome coordinates
provider text 2147483647  √  null data provider of genome coordinates
version text 2147483647  √  null genome build version for genome coordinates
_createdby_key int4 10 1001
mgi_user._user_key mrk_location_cache__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key mrk_location_cache__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 259,009 rows at Mon Nov 20 05:26 EST 2017

Column(s) Type Sort Constraint Name
_cache_key Primary key, Used to cluster data Asc mrk_location_cache_pkey
lower(chromosome) Performance Asc mrk_location_cache_0
chromosome + cmoffset Performance Asc/Asc mrk_location_cache_idx_chromosome_cmoffset
chromosome + startcoordinate + endcoordinate Performance Asc/Asc/Asc mrk_location_cache_idx_clustered
_marker_key Performance Asc mrk_location_cache_idx_marker_key
_marker_type_key Performance Asc mrk_location_cache_idx_marker_type_key
_organism_key Performance Asc mrk_location_cache_idx_organism_key

Close relationships  within of separation: