SchemaSpy - Table pub.mgd.gxd

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:

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

√

nextval('gxd_probeprep_seq'::regclass)

gxd_assay._probeprep_key

gxd_assay__probeprep_key_fkey R

primary key

_probe_key

int4

prb_probe._probe_key

gxd_probeprep__probe_key_fkey R

foreign key to PRB_Probe

_sense_key

int4

voc_term._term_key

gxd_probeprep__sense_key_fkey R

foreign key to GXD_ProbeSense

_label_key

int4

voc_term._term_key

gxd_probeprep__label_key_fkey R

foreign key to GXD_Label

_visualization_key

int4

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

Indexes:

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