SchemaSpy - Table mgd.mgd.voc_marker

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

_term_key

int4

voc_term._term_key

Implied Constraint R

_marker_key

int4

mrk_marker._marker_key

voc_marker_cache__marker_key R

annottype

varchar

Table contained 982,580 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
annottype + _marker_key	Performance	Asc/Asc	voc_marker_cache_idx_annottype
_marker_key + _term_key	Performance	Asc/Asc	voc_marker_cache_idx_marker_key
_term_key + _marker_key	Performance	Asc/Asc	voc_marker_cache_idx_term_key