Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.gxd_specimen
Defines an In Situ Assay Specimen. A Specimen is described in terms of its genotype, sex, age and the methods used to prepare the sample. If multiple animals within one reference have identical genotypes and preparation procedures, then they can be collectively represented by a single Specimen object.

See GXD_Assay, GXD_EmbeddingMethod, GXD_FixationMethod, GXD_Genotype.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_specimen_key serial 10  √  nextval('gxd_specimen_seq'::regclass)
gxd_expression
gxd_insituresult
primary key
_assay_key int4 10
gxd_assay
foreign key to GXD_Assay
_embedding_key int4 10
voc_term
foreign key to GXD_EmbeddingMethod
_fixation_key int4 10
voc_term
foreign key to GXD_FixationMethod
_genotype_key int4 10
gxd_genotype
foreign key to GXD_Genotype
sequencenum int4 10 sequence number for ordering records
specimenlabel text 2147483647  √  null specimen label
sex text 2147483647 sex of specimen (Female, Male, Pooled)
age text 2147483647 age of embryo or animal
agemin numeric 131089  √  null minimum age range determined by age field; system calculated
agemax numeric 131089  √  null maximum age range determined by age field; system calculated
agenote text 2147483647  √  null age notes
hybridization text 2147483647 probe hybridized to? (sections, whole mount, section from whole mount)
specimennote text 2147483647  √  null specimen note
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 526,764 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort
_specimen_key Primary key Asc
_assay_key Performance Asc
_embedding_key Performance Asc
_fixation_key Performance Asc
_genotype_key Performance Asc

Close relationships  within of separation: