SchemaSpy - Table mgd.mgd.gxd_assay

	Schema Browser
Home \| About \| Help \| FAQ

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

_assay_key

int4

10

all_cre_cache._assay_key	all_cre_cache__assay_key R
gxd_assaynote._assay_key	gxd_assaynote__assay_key R
gxd_expression._assay_key	gxd_expression__assay_key R
gxd_gellane._assay_key	gxd_gellane__assay_key R
gxd_gelrow._assay_key	gxd_gelrow__assay_key R
gxd_specimen._assay_key	gxd_specimen__assay_key R
hmd_assay._assay_key	Implied Constraint R

_assaytype_key

int4

10

gxd_assaytype._assaytype_key

gxd_assay__assaytype_key R

_refs_key

int4

10

bib_refs._refs_key

gxd_assay__refs_key R

_marker_key

int4

10

mrk_marker._marker_key

gxd_assay__marker_key R

_probeprep_key

int4

10

√

null

gxd_probeprep._probeprep_key

gxd_assay__probeprep_key R

_antibodyprep_key

int4

10

√

null

gxd_antibodyprep._antibodyprep_key

gxd_assay__antibodyprep_key R

_imagepane_key

int4

10

√

null

img_imagepane._imagepane_key

gxd_assay__imagepane_key R

_reportergene_key

int4

10

√

null

voc_term._term_key

gxd_assay__reportergene_key R

_createdby_key

int4

10

mgi_user._user_key

gxd_assay__createdby_key R

_modifiedby_key

int4

10

mgi_user._user_key

gxd_assay__modifiedby_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 55,699 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_assay_key	Primary key	Asc	gxd_assay_pkey
_assay_key	Must be unique	Asc	gxd_assay_idx_assay_key
_antibodyprep_key	Performance	Asc	gxd_assay_idx_antibodyprep_key
_assaytype_key	Performance	Asc	gxd_assay_idx_assaytype_key
_createdby_key	Performance	Asc	gxd_assay_idx_createdby_key
_imagepane_key	Performance	Asc	gxd_assay_idx_imagepane_key
_marker_key	Performance	Asc	gxd_assay_idx_marker_key
_modifiedby_key	Performance	Asc	gxd_assay_idx_modifiedby_key
_probeprep_key	Performance	Asc	gxd_assay_idx_probeprep_key
_refs_key	Performance	Asc	gxd_assay_idx_refs_key
_reportergene_key	Performance	Asc	gxd_assay_idx_reportergene_key