Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
View pub.mgd.gxd_specimen_view 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  √  null
gxd_specimen._specimen_key Implied Constraint R
_assay_key int4 10  √  null
gxd_assay._assay_key Implied Constraint R
_embedding_key int4 10  √  null
gxd_embeddingmethod._embedding_key Implied Constraint R
_fixation_key int4 10  √  null
gxd_fixationmethod._fixation_key Implied Constraint R
_genotype_key int4 10  √  null
gxd_genotype._genotype_key Implied Constraint R
sequencenum int4 10  √  null
specimenlabel text 2147483647  √  null
sex text 2147483647  √  null
age text 2147483647  √  null
agemin numeric 131089  √  null
agemax numeric 131089  √  null
agenote text 2147483647  √  null
hybridization text 2147483647  √  null
specimennote text 2147483647  √  null
creation_date timestamp 29,6  √  null
modification_date timestamp 29,6  √  null
embeddingmethod text 2147483647  √  null
fixation text 2147483647  √  null
strain text 2147483647  √  null
mgiid text 2147483647  √  null

Analyzed at Mon Nov 20 05:26 EST 2017


Close relationships: