Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.gxd_insituresult
Defines an In Situ Specimen Result. For each Specimen defined, one or more results can be recorded. Each result contains the anatomical structure(s), signal strength, pattern of expression within the structure(s) and optional notes. One or more
Image Panes may also be associated with a result.

See GXD_Specimen, GXD_InSituResultImage, GXD_ISResultStructure.

Generated by
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
_result_key serial 10  √  nextval('gxd_insituresult_seq'::regclass)
gxd_insituresultimage._result_key gxd_insituresultimage__result_key_fkey C
gxd_isresultcelltype._result_key gxd_isresultcelltype__result_key_fkey C
gxd_isresultstructure._result_key gxd_isresultstructure__result_key_fkey C
primary key
_specimen_key int4 10
gxd_specimen._specimen_key gxd_insituresult__specimen_key_fkey C
foreign key to GXD_Specimen
_strength_key int4 10
voc_term._term_key gxd_insituresult__strength_key_fkey R
foreign key to VOC_Term
_pattern_key int4 10
voc_term._term_key gxd_insituresult__pattern_key_fkey R
foreign key to VOC_Term
sequencenum int4 10 sequence number for ordering records
resultnote text 2147483647  √  null textual information
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 1,565,117 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_result_key Primary key Asc gxd_insituresult_pkey
_pattern_key Performance Asc gxd_insituresult_idx_pattern_key
_specimen_key Performance Asc gxd_insituresult_idx_specimen_key
_strength_key Performance Asc gxd_insituresult_idx_strength_key

Close relationships  within of separation: