SchemaSpy - Table mgd.mgd.gxd_index

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

_index_key

int4

gxd_index._index_key

Implied Constraint R

_indexassay_key

int4

voc_term._term_key

gxd_index_stages__indexassay_key R

_stageid_key

int4

voc_term._term_key

gxd_index_stages__stageid_key R

_createdby_key

int4

mgi_user._user_key

gxd_index_stages__createdby_key R

_modifiedby_key

int4

mgi_user._user_key

gxd_index_stages__modifiedby_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 328,346 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_index_key + _indexassay_key + _stageid_key	Primary key	Asc/Asc/Asc	gxd_index_stages_pkey
_index_key + _indexassay_key + _stageid_key	Must be unique	Asc/Asc/Asc	gxd_index_stages_idx_primary_key
_indexassay_key	Performance	Asc	gxd_index_stages_idx_indexassay_key
_stageid_key	Performance	Asc	gxd_index_stages_idx_stageid_key