Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.gxd_antibodyprep
Defines the Antibody preparation for an expression assay. The Antibody preparation specifies the antibody and detection system used. The detection is a combination of a Secondary Antibody and a labelling material.

See GXD_Assay, GXD_Antibody, GXD_Secondary, GXD_Label.

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
_antibodyprep_key serial 10  √  nextval('gxd_antibodyprep_seq'::regclass)
gxd_assay._antibodyprep_key gxd_assay__antibodyprep_key_fkey R
primary key
_antibody_key int4 10
gxd_antibody._antibody_key gxd_antibodyprep__antibody_key_fkey R
foreign key to GXD_Antibody
_secondary_key int4 10
voc_term._term_key gxd_antibodyprep__secondary_key_fkey R
foreign key to GXD_Antibody
_label_key int4 10
voc_term._term_key gxd_antibodyprep__label_key_fkey R
foreign key to GXD_Label
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 30,227 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_antibodyprep_key Primary key Asc gxd_antibodyprep_pkey
_antibody_key Performance Asc gxd_antibodyprep_idx_antibody_key
_label_key Performance Asc gxd_antibodyprep_idx_label_key
_secondary_key Performance Asc gxd_antibodyprep_idx_secondary_key

Close relationships  within of separation: