Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.gxd_specimen Generated by
SchemaSpy
Legend: SourceForge.net
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
_specimen_key int4 10
gxd_insituresult._specimen_key gxd_insituresult__specimen_key R
_assay_key int4 10
gxd_assay._assay_key gxd_specimen__assay_key R
_embedding_key int4 10
gxd_embeddingmethod._embedding_key gxd_specimen__embedding_key R
_fixation_key int4 10
gxd_fixationmethod._fixation_key gxd_specimen__fixation_key R
_genotype_key int4 10
gxd_genotype._genotype_key gxd_specimen__genotype_key R
sequencenum int4 10
specimenlabel varchar 255  √  null
sex varchar 15
age varchar 50
agemin float8 17,17  √  null
agemax float8 17,17  √  null
agenote varchar 255  √  null
hybridization varchar 255
specimennote varchar 255  √  null
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 227,885 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_specimen_key Primary key Asc gxd_specimen_pkey
_specimen_key Must be unique Asc gxd_specimen_idx_specimen_key
_assay_key Performance Asc gxd_specimen_idx_assay_key
_embedding_key Performance Asc gxd_specimen_idx_embedding_key
_fixation_key Performance Asc gxd_specimen_idx_fixation_key
_genotype_key Performance Asc gxd_specimen_idx_genotype_key

Close relationships  within of separation: