SchemaSpy - Table pub.mgd.mrk

A record in this table represents a unique association between a Marker and a Reference. This is a cache table that is rebuilt nightly by the mrkcacheload product. It represents a union of unique Marker/Reference associations from all data sets in MGI (Expression, Mapping, Alleles, GO Annotations, etc.).

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

_marker_key

int4

mrk_marker._marker_key

mrk_reference__marker_key_fkey C

foreign key to MRK_Marker

_refs_key

int4

bib_refs._refs_key

mrk_reference__refs_key_fkey C

foreign key to BIB_Refs

mgiid

text

2147483647

MGI accession id of the reference (MGI:xxxx)

jnumid

text

2147483647

J: accession id of the reference (J:xxxx)

pubmedid

text

2147483647

√

null

pubmed accession id of the reference (xxxx)

jnum

int4

J: accession id of the reference without the prefix; integer (xxxx)

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 2,317,020 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_marker_key + _refs_key	Primary key, Used to cluster data	Asc/Asc	mrk_reference_pkey
_refs_key	Performance	Asc	mrk_reference_idx_refs_key