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
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
_probeprep_key int4 10
gxd_assay._probeprep_key gxd_assay__probeprep_key_fkey R
gxd_assay_view._probeprep_key Implied Constraint R
gxd_probeprep_view._probeprep_key Implied Constraint 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
gxd_probesense._sense_key gxd_probeprep__sense_key_fkey R
foreign key to GXD_ProbeSense
_label_key int4 10
gxd_label._label_key gxd_probeprep__label_key_fkey R
foreign key to GXD_Label
_visualization_key int4 10
gxd_visualizationmethod._visualization_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 65,852 rows at Mon Nov 20 05:26 EST 2017

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