SchemaSpy - Table pub.mgd.mrk

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
SchemaSpy

Legend:

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

dag_label._label_key

Implied Constraint R

primary key

_marker_key

int4

mrk_marker._marker_key

mrk_label__marker_key_fkey C

foreign key to MRK_Marker

_label_status_key

int4

1 = current, 2 = old

_organism_key

int4

mgi_organism._organism_key

mrk_label__organism_key_fkey R

organism (foreign key to MGI_Organism)

_orthologorganism_key

int4

√

null

mgi_organism._organism_key

mrk_label__orthologorganism_key_fkey R

organism of ortholog (foreign key to MGI_Organism)

priority

int4

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

Indexes:

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