SchemaSpy - Table mgd.mgd.voc

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

_annot_key

int4

voc_evidence._annot_key

voc_evidence__annot_key R

_annottype_key

int4

voc_annottype._annottype_key

voc_annot__annottype_key R

_object_key

int4

_term_key

int4

voc_term._term_key

voc_annot__term_key R

_qualifier_key

int4

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 663,344 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_annot_key	Primary key	Asc	voc_annot_pkey
_annot_key	Must be unique	Asc	voc_annot_idx_annot_key
_object_key + _term_key + _annottype_key + _qualifier_key	Performance	Asc/Asc/Asc/Asc	voc_annot_idx_annotation
_annottype_key	Performance	Asc	voc_annot_idx_annottype_key
_qualifier_key	Performance	Asc	voc_annot_idx_qualifier_key
_term_key + _annottype_key + _qualifier_key + _object_key	Performance	Asc/Asc/Asc/Asc	voc_annot_idx_term_key