SchemaSpy - Table mgd.mgd.seq_marker_cache

	Schema Browser
Home \| About \| Help \| FAQ

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

10

all_cre_cache._cache_key

Implied Constraint R

_sequence_key

int4

10

seq_genetrap._sequence_key

Implied Constraint R

_marker_key

int4

10

mrk_marker._marker_key

seq_marker_cache__marker_key R

_organism_key

int4

10

mgi_organism._organism_key

Implied Constraint R

_refs_key

int4

10

bib_refs._refs_key

Implied Constraint R

_qualifier_key

int4

10

voc_term._term_key

seq_marker_cache__qualifier_key R

_sequenceprovider_key

int4

10

voc_term._term_key

seq_marker_cache__sequenceprovider_key R

_sequencetype_key

int4

10

voc_term._term_key

seq_marker_cache__sequencetype_key R

_logicaldb_key

int4

10

acc_logicaldb._logicaldb_key

Implied Constraint R

_marker_type_key

int4

10

mrk_types._marker_type_key

Implied Constraint R

_biotypeconflict_key

int4

10

voc_term._term_key

seq_marker_cache__biotypeconflict_key R

accid

varchar

30

rawbiotype

varchar

255

√

null

annotation_date

timestamp

29,6

_createdby_key

int4

10

mgi_user._user_key

seq_marker_cache__createdby_key R

_modifiedby_key

int4

10

mgi_user._user_key

seq_marker_cache__modifiedby_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 1,123,965 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_sequence_key + _marker_key + _refs_key + accid	Primary key	Asc/Asc/Asc/Asc	seq_marker_cache_pkey
accid	Performance	Asc	seq_marker_cache_idx_accid
annotation_date	Performance	Asc	seq_marker_cache_idx_annotation_date
_biotypeconflict_key	Performance	Asc	seq_marker_cache_idx_biotypeconflict_key
_logicaldb_key	Performance	Asc	seq_marker_cache_idx_logicaldb_key
_marker_key + _sequence_key	Performance	Asc/Asc	seq_marker_cache_idx_marker_key
_marker_type_key	Performance	Asc	seq_marker_cache_idx_marker_type_key
_organism_key	Performance	Asc	seq_marker_cache_idx_organism_key
_sequence_key + _marker_key + _refs_key	Performance	Asc/Asc/Asc	seq_marker_cache_idx_primary_key
_qualifier_key	Performance	Asc	seq_marker_cache_idx_qualifier_key
_refs_key	Performance	Asc	seq_marker_cache_idx_refs_key
_sequenceprovider_key	Performance	Asc	seq_marker_cache_idx_sequenceprovider_key
_sequencetype_key	Performance	Asc	seq_marker_cache_idx_sequencetype_key