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

_vocab_key

int4

mgi_translationtype._vocab_key	mgi_translationtype__vocab_key R
mgi_vocassociationtype._vocab_key_1	mgi_vocassociationtype__vocab_key_1 R
mgi_vocassociationtype._vocab_key_2	mgi_vocassociationtype__vocab_key_2 R
voc_annottype._evidencevocab_key	voc_annottype__evidencevocab_key R
voc_annottype._qualifiervocab_key	voc_annottype__qualifiervocab_key R
voc_annottype._vocab_key	voc_annottype__vocab_key R
voc_term._vocab_key	voc_term__vocab_key R
voc_vocabdag._vocab_key	voc_vocabdag__vocab_key R

_refs_key

int4

bib_refs._refs_key

voc_vocab__refs_key R

_logicaldb_key

int4

acc_logicaldb._logicaldb_key

voc_vocab__logicaldb_key R

issimple

int2

isprivate

int2

√

null

name

varchar

255

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 79 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_vocab_key	Primary key	Asc	voc_vocab_pkey
name + _vocab_key	Must be unique	Asc/Asc	voc_vocab_idx_name
_vocab_key	Must be unique	Asc	voc_vocab_idx_vocab_key
_refs_key	Performance	Asc	voc_vocab_idx_refs_key