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

_probeprep_key

int4

gxd_assay._probeprep_key

gxd_assay__probeprep_key R

_probe_key

int4

prb_probe._probe_key

gxd_probeprep__probe_key R

_sense_key

int4

gxd_probesense._sense_key

gxd_probeprep__sense_key R

_label_key

int4

gxd_label._label_key

gxd_probeprep__label_key R

_visualization_key

int4

gxd_visualizationmethod._visualization_key

gxd_probeprep__visualization_key R

type

varchar

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 48,208 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_probeprep_key	Primary key	Asc	gxd_probeprep_pkey
_probeprep_key	Must be unique	Asc	gxd_probeprep_idx_probeprep_key
_label_key	Performance	Asc	gxd_probeprep_idx_label_key
_probe_key	Performance	Asc	gxd_probeprep_idx_probe_key
_sense_key	Performance	Asc	gxd_probeprep_idx_sense_key
_visualization_key	Performance	Asc	gxd_probeprep_idx_visualization_key