SchemaSpy - Table mgd.mgd.mrk

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 R
all_knockout_cache._marker_key	all_knockout_cache__marker_key R
all_marker_assoc._marker_key	all_marker_assoc__marker_key R
crs_matrix._marker_key	crs_matrix__marker_key R
crs_references._marker_key	crs_references__marker_key R
go_tracking._marker_key	go_tracking__marker_key R
gxd_allelegenotype._marker_key	gxd_allelegenotype__marker_key R
gxd_allelepair._marker_key	gxd_allelepair__marker_key R
gxd_antibodymarker._marker_key	gxd_antibodymarker__marker_key R
gxd_assay._marker_key	gxd_assay__marker_key R
gxd_expression._marker_key	gxd_expression__marker_key R
gxd_index._marker_key	gxd_index__marker_key R
hmd_homology_marker._marker_key	hmd_homology_marker__marker_key R
mlc_marker._marker_key	mlc_marker__marker_key1 R
mlc_marker._marker_key_2	mlc_marker__marker_key_2 R
mlc_reference._marker_key	mlc_reference__marker_key1 R
mlc_text._marker_key	mlc_text__marker_key R
mld_concordance._marker_key	mld_concordance__marker_key R
mld_distance._marker_key_1	mld_distance__marker_key_1 R
mld_distance._marker_key_2	mld_distance__marker_key_2 R
mld_expt_marker._marker_key	mld_expt_marker__marker_key R
mld_mc2point._marker_key_1	mld_mc2point__marker_key_1 R
mld_mc2point._marker_key_2	mld_mc2point__marker_key_2 R
mld_ri2point._marker_key_1	mld_ri2point__marker_key_1 R
mld_ri2point._marker_key_2	mld_ri2point__marker_key_2 R
mld_ridata._marker_key	mld_ridata__marker_key R
mld_statistics._marker_key_1	mld_statistics__marker_key_1 R
mld_statistics._marker_key_2	mld_statistics__marker_key_2 R
mrk_alias._alias_key	mrk_alias__alias_key R
mrk_alias._marker_key	mrk_alias__marker_key R
mrk_anchors._marker_key	mrk_anchors__marker_key R
mrk_classes._marker_key	mrk_classes__marker_key R
mrk_current._current_key	mrk_current__current_key R
mrk_current._marker_key	mrk_current__marker_key R
mrk_history._history_key	mrk_history__history_key R
mrk_history._marker_key	mrk_history__marker_key R
mrk_homology_cache._marker_key	mrk_homology_cache__marker_key R
mrk_label._marker_key	mrk_label__marker_key R
mrk_location_cache._marker_key	mrk_location_cache__marker_key R
mrk_mcv_cache._marker_key	mrk_mcv_cache__marker_key R
mrk_notes._marker_key	mrk_notes__marker_key R
mrk_offset._marker_key	mrk_offset__marker_key R
mrk_omim_cache._marker_key	mrk_omim_cache__marker_key R
mrk_reference._marker_key	mrk_reference__marker_key R
prb_marker._marker_key	prb_marker__marker_key R
prb_rflv._marker_key	prb_rflv__marker_key R
prb_strain_marker._marker_key	prb_strain_marker__marker_key R
ri_summary._marker_key	ri_summary__marker_key R
seq_marker_cache._marker_key	seq_marker_cache__marker_key R
voc_marker_cache._marker_key	voc_marker_cache__marker_key R
wks_rosetta._marker_key	wks_rosetta__marker_key R

_organism_key

int4

mgi_organism._organism_key

mrk_marker__organism_key R

_marker_status_key

int4

mrk_status._marker_status_key

mrk_marker__marker_status_key R

_marker_type_key

int4

mrk_types._marker_type_key

mrk_marker__marker_type_key R

_curationstate_key

int4

voc_term._term_key

mrk_marker__curationstate_key R

symbol

varchar

name

varchar

255

chromosome

varchar

cytogeneticoffset

varchar

√

null

_createdby_key

int4

mgi_user._user_key

mrk_marker__createdby_key R

_modifiedby_key

int4

mgi_user._user_key

mrk_marker__modifiedby_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 318,837 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_marker_key	Primary key	Asc	mrk_marker_pkey
_marker_key + _organism_key	Must be unique	Asc/Asc	mrk_marker_idx_marker_key
chromosome	Performance	Asc	mrk_marker_idx_chromosome
_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