SchemaSpy - Table mgd.mgd.gxd_expression

	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

_expression_key

int4

10

_assay_key

int4

10

gxd_assay._assay_key

gxd_expression__assay_key R

_refs_key

int4

10

bib_refs._refs_key

gxd_expression__refs_key R

_assaytype_key

int4

10

gxd_assaytype._assaytype_key

gxd_expression__assaytype_key R

_genotype_key

int4

10

gxd_genotype._genotype_key

gxd_expression__genotype_key R

_marker_key

int4

10

mrk_marker._marker_key

gxd_expression__marker_key R

_structure_key

int4

10

gxd_structure._structure_key

gxd_expression__structure_key R

expressed

int2

5

age

varchar

50

agemin

float8

17,17

√

null

agemax

float8

17,17

√

null

isrecombinase

int2

5

isforgxd

int2

5

hasimage

int2

5

√

null

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 1,122,649 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_expression_key	Primary key	Asc	gxd_expression_pkey
_expression_key	Must be unique	Asc	gxd_expression_idx_expression_key
_assay_key	Performance	Asc	gxd_expression_idx_assay_key
_assaytype_key	Performance	Asc	gxd_expression_idx_assaytype_key
_genotype_key + isforgxd	Performance	Asc/Asc	gxd_expression_idx_genotype_key
_marker_key + _structure_key + isforgxd	Performance	Asc/Asc/Asc	gxd_expression_idx_marker_structure_key
_refs_key + _structure_key + isforgxd	Performance	Asc/Asc/Asc	gxd_expression_idx_refs_key
_structure_key + _expression_key + isforgxd	Performance	Asc/Asc/Asc	gxd_expression_idx_structure_key