SchemaSpy - Table pub.mgd.mrk

A record in this table represents a Marker (gene, dna segment, complex/cluster). Mouse Markers have MGI Accession IDs. Non-mouse Markers (human, rat, etc.) are also stored in this table.

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

all_allele._marker_key	all_allele__marker_key_fkey R
all_knockout_cache._marker_key	all_knockout_cache__marker_key_fkey C
crs_matrix._marker_key	crs_matrix__marker_key_fkey R
crs_references._marker_key	crs_references__marker_key_fkey R
go_tracking._marker_key	go_tracking__marker_key_fkey C
gxd_allelegenotype._marker_key	gxd_allelegenotype__marker_key_fkey R
gxd_allelepair._marker_key	gxd_allelepair__marker_key_fkey R
gxd_antibodymarker._marker_key	gxd_antibodymarker__marker_key_fkey R
gxd_assay._marker_key	gxd_assay__marker_key_fkey R
gxd_expression._marker_key	gxd_expression__marker_key_fkey R
gxd_index._marker_key	gxd_index__marker_key_fkey R
mld_concordance._marker_key	mld_concordance__marker_key_fkey R
mld_expt_marker._marker_key	mld_expt_marker__marker_key_fkey R
mld_mc2point._marker_key_1	mld_mc2point__marker_key_1_fkey R
mld_mc2point._marker_key_2	mld_mc2point__marker_key_2_fkey R
mld_ri2point._marker_key_1	mld_ri2point__marker_key_1_fkey R
mld_ri2point._marker_key_2	mld_ri2point__marker_key_2_fkey R
mld_ridata._marker_key	mld_ridata__marker_key_fkey R
mld_statistics._marker_key_1	mld_statistics__marker_key_1_fkey R
mld_statistics._marker_key_2	mld_statistics__marker_key_2_fkey R
mrk_alias._alias_key	mrk_alias__alias_key_fkey C
mrk_alias._marker_key	mrk_alias__marker_key_fkey C
mrk_anchors._marker_key	mrk_anchors__marker_key_fkey C
mrk_classes._marker_key	mrk_classes__marker_key_fkey C
mrk_clustermember._marker_key	mrk_clustermember__marker_key_fkey R
mrk_current._current_key	mrk_current__current_key_fkey C
mrk_current._marker_key	mrk_current__marker_key_fkey C
mrk_do_cache._marker_key	mrk_do_cache__marker_key_fkey C
mrk_history._history_key	mrk_history__history_key_fkey C
mrk_history._marker_key	mrk_history__marker_key_fkey C
mrk_label._marker_key	mrk_label__marker_key_fkey C
mrk_location_cache._marker_key	mrk_location_cache__marker_key_fkey C
mrk_mcv_cache._marker_key	mrk_mcv_cache__marker_key_fkey C
mrk_notes._marker_key	mrk_notes__marker_key_fkey C
mrk_offset._marker_key	mrk_offset__marker_key_fkey C
mrk_reference._marker_key	mrk_reference__marker_key_fkey C
prb_marker._marker_key	prb_marker__marker_key_fkey R
prb_rflv._marker_key	prb_rflv__marker_key_fkey R
prb_strain_marker._marker_key	prb_strain_marker__marker_key_fkey R
ri_summary._marker_key	ri_summary__marker_key_fkey R
seq_marker_cache._marker_key	seq_marker_cache__marker_key_fkey C
voc_marker_cache._marker_key	voc_marker_cache__marker_key_fkey C
wks_rosetta._marker_key	wks_rosetta__marker_key_fkey R

primary key

_organism_key

int4

mgi_organism._organism_key

mrk_marker__organism_key_fkey R

foreign key to MGI_Organism

_marker_status_key

int4

mrk_status._marker_status_key

mrk_marker__marker_status_key_fkey R

foreign key to MRK_Status

_marker_type_key

int4

mrk_types._marker_type_key

mrk_marker__marker_type_key_fkey R

foreign key to MRK_Types

symbol

text

2147483647

official symbol of marker

name

text

2147483647

official name of marker

chromosome

text

2147483647

chromosome

cytogeneticoffset

text

2147483647

√

null

cytogenetic band

_createdby_key

int4

1001

mgi_user._user_key

mrk_marker__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

1001

mgi_user._user_key

mrk_marker__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 753,331 rows at Thu Dec 21 05:31 EST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
_marker_key	Primary key, Used to cluster data	Asc	mrk_marker_pkey
_marker_key + _organism_key	Must be unique	Asc/Asc	mrk_marker_idx_marker_key
chromosome	Performance	Asc	mrk_marker_idx_clustered
_createdby_key	Performance	Asc	mrk_marker_idx_createdby_key
_marker_status_key	Performance	Asc	mrk_marker_idx_marker_status_key
_marker_type_key + _marker_key	Performance	Asc/Asc	mrk_marker_idx_marker_type_key
_modifiedby_key	Performance	Asc	mrk_marker_idx_modifiedby_key
_organism_key	Performance	Asc	mrk_marker_idx_organism_key
symbol	Performance	Asc	mrk_marker_idx_symbol