SchemaSpy - Table pub.mgd.gxd

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:

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

√

nextval('gxd_antibodyprep_seq'::regclass)

gxd_assay._antibodyprep_key

gxd_assay__antibodyprep_key_fkey R

primary key

_antibody_key

int4

gxd_antibody._antibody_key

gxd_antibodyprep__antibody_key_fkey R

foreign key to GXD_Antibody

_secondary_key

int4

voc_term._term_key

gxd_antibodyprep__secondary_key_fkey R

foreign key to GXD_Antibody

_label_key

int4

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

Indexes:

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