Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.mrk_label
A record in this table represents the cached value of a label (name, synonym, symbol) for a Marker. Examples: [priority = 1, label type = "MS", label name = "current symbol"], [priority = 2, label = "MN", label name = "current name"].
See mrkcacheload/mrklabel.csh for complete list.

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
_label_key int4 10
dag_label._label_key Implied Constraint R
primary key
_marker_key int4 10
mrk_marker._marker_key mrk_label__marker_key_fkey C
foreign key to MRK_Marker
_label_status_key int4 10 1 = current, 2 = old
_organism_key int4 10
mgi_organism._organism_key mrk_label__organism_key_fkey R
organism (foreign key to MGI_Organism)
_orthologorganism_key int4 10  √  null
mgi_organism._organism_key mrk_label__orthologorganism_key_fkey R
organism of ortholog (foreign key to MGI_Organism)
priority int4 10 an integer representing the priority of this record for sorting purposes. the higher the number, the higher the priority.
label text 2147483647 label (name, symbol, synonym)
labeltype text 2147483647 label type (N, S, Y)
labeltypename text 2147483647 specifies if label is current symbol, current name, allele symbol, allele name, etc.
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 3,881,155 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_label_key Primary key, Used to cluster data Asc mrk_label_pkey
lower(label) Performance Asc mrk_label_0
_marker_key + priority + _orthologorganism_key + labeltype + label Performance Asc/Asc/Asc/Asc/Asc mrk_label_idx_clustered
label + _organism_key + _marker_key Performance Asc/Asc/Asc mrk_label_idx_label
_label_status_key Performance Asc mrk_label_idx_label_status_key
_organism_key Performance Asc mrk_label_idx_organism_key
priority Performance Asc mrk_label_idx_priority

Close relationships  within of separation: