Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.gxd_probeprep
Defines the Probe preparation for an expression assay. The Probe preparation specifies the probe used, final type (DNA, RNA) and the label used to visualize the probe.

See GXD_Assay, PRB_Probe, GXD_ProbeSense, GXD_Label, GXD_LabelCoverage, GXD_Visualization.

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
_probeprep_key serial 10  √  nextval('gxd_probeprep_seq'::regclass)
gxd_assay._probeprep_key gxd_assay__probeprep_key_fkey R
primary key
_probe_key int4 10
prb_probe._probe_key gxd_probeprep__probe_key_fkey R
foreign key to PRB_Probe
_sense_key int4 10
voc_term._term_key gxd_probeprep__sense_key_fkey R
foreign key to GXD_ProbeSense
_label_key int4 10
voc_term._term_key gxd_probeprep__label_key_fkey R
foreign key to GXD_Label
_visualization_key int4 10
voc_term._term_key gxd_probeprep__visualization_key_fkey R
foreign key to GXD_VisualizationMethod
type text 2147483647 final type of probe segment (DNA, RNA, Not Specified)
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 95,542 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_probeprep_key Primary key Asc gxd_probeprep_pkey
_label_key Performance Asc gxd_probeprep_idx_label_key
_probe_key Performance Asc gxd_probeprep_idx_probe_key
_sense_key Performance Asc gxd_probeprep_idx_sense_key
_visualization_key Performance Asc gxd_probeprep_idx_visualization_key

Close relationships  within of separation: