SchemaSpy - Table mgd.mgd.mrk_homology

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

_cache_key

int4

all_cre_cache._cache_key

Implied Constraint R

_class_key

int4

hmd_class._class_key

Implied Constraint R

_homology_key

int4

hmd_homology._homology_key

Implied Constraint R

_refs_key

int4

bib_refs._refs_key

Implied Constraint R

_marker_key

int4

mrk_marker._marker_key

mrk_homology_cache__marker_key R

_organism_key

int4

mgi_organism._organism_key

Implied Constraint R

Table contained 143,854 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_class_key + _organism_key + _marker_key + _refs_key + _homology_key	Primary key	Asc/Asc/Asc/Asc/Asc	mrk_homology_cache_pkey
_class_key + _homology_key	Performance	Asc/Asc	mrk_homology_cache_idx_class_homology_key
_class_key + _marker_key	Performance	Asc/Asc	mrk_homology_cache_idx_class_marker_key
_marker_key + _class_key + _organism_key	Performance	Asc/Asc/Asc	mrk_homology_cache_idx_marker_key
_class_key + _organism_key	Performance	Asc/Asc	mrk_homology_cache_idx_primary
_refs_key + _class_key + _organism_key	Performance	Asc/Asc/Asc	mrk_homology_cache_idx_refs_key