SchemaSpy - Table mgd.mgd.gxd

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

_structure_key

int4

all_cre_cache._structure_key	all_cre_cache__structure_key R
gxd_expression._structure_key	gxd_expression__structure_key R
gxd_gellanestructure._structure_key	gxd_gellanestructure__structure_key R
gxd_isresultstructure._structure_key	gxd_isresultstructure__structure_key R
gxd_structure._parent_key	gxd_structure__parent_key R
gxd_structureclosure._descendent_key	gxd_structureclosure__descendent_key R
gxd_structureclosure._structure_key	gxd_structureclosure__structure_key R
gxd_structurename._structure_key	gxd_structurename__structure_key R

_parent_key

int4

√

null

gxd_structure._structure_key

gxd_structure__parent_key R

_structurename_key

int4

gxd_structurename._structurename_key

gxd_structure__structurename_key R

_stage_key

int4

gxd_theilerstage._stage_key

gxd_structure__stage_key R

_system_key

int4

voc_term._term_key

gxd_structure__system_key R

edinburghkey

int4

√

null

printname

varchar

255

√

null

treedepth

int4

printstop

int2

toposort

int4

inheritsystem

int2

structurenote

varchar

255

√

null

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 17,394 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_structure_key	Primary key	Asc	gxd_structure_pkey
_structure_key	Must be unique	Asc	gxd_structure_idx_structure_key
_parent_key	Performance	Asc	gxd_structure_idx_parent_key
_stage_key	Performance	Asc	gxd_structure_idx_stage_key
_structurename_key	Performance	Asc	gxd_structure_idx_structurename_key
_system_key	Performance	Asc	gxd_structure_idx_system_key