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
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
_antibodyprep_key int4 10
gxd_antibodyprep_view._antibodyprep_key Implied Constraint R
gxd_assay._antibodyprep_key gxd_assay__antibodyprep_key_fkey R
gxd_assay_view._antibodyprep_key Implied Constraint 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
gxd_secondary._secondary_key gxd_antibodyprep__secondary_key_fkey R
foreign key to GXD_Antibody
_label_key int4 10
gxd_label._label_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 13,619 rows at Mon Nov 20 05:26 EST 2017

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