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_Strength, GXD_Pattern, GXD_InSituResultImage, GXD_ISResultStructure.

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
_result_key int4 10
gxd_insituresult_view._result_key Implied Constraint R
gxd_insituresultimage._result_key gxd_insituresultimage__result_key_fkey C
gxd_isresultimage_view._result_key Implied Constraint R
gxd_isresultstructure._result_key gxd_isresultstructure__result_key_fkey C
gxd_isresultstructure_view._result_key Implied Constraint R
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
gxd_strength._strength_key gxd_insituresult__strength_key_fkey R
foreign key to GXD_Strength
_pattern_key int4 10
gxd_pattern._pattern_key gxd_insituresult__pattern_key_fkey R
foreign key to GXD_Pattern
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,345,463 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_result_key Primary key, Used to cluster data 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: