SchemaSpy - Table pub.mgd.gxd

Defines an accessionable Antibody object. An antibody is a protein produced by cells of the immune system that binds to an antigen.

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

_antibody_key

serial

√

nextval('gxd_antibody_seq'::regclass)

gxd_antibodyalias._antibody_key	gxd_antibodyalias__antibody_key_fkey C
gxd_antibodymarker._antibody_key	gxd_antibodymarker__antibody_key_fkey C
gxd_antibodyprep._antibody_key	gxd_antibodyprep__antibody_key_fkey R

primary key

_antibodyclass_key

int4

voc_term._term_key

gxd_antibody__antibodyclass_key_fkey R

foreign key to GXD_AntibodyClass

_antibodytype_key

int4

voc_term._term_key

gxd_antibody__antibodytype_key_fkey R

foreign key to GXD_AntibodyType

_organism_key

int4

mgi_organism._organism_key

gxd_antibody__organism_key_fkey R

organism (foreign key to MGI_Organism)

_antigen_key

int4

gxd_antigen._antigen_key

gxd_antibody__antigen_key_fkey R

foreign key to GXD_Antigen

antibodyname

text

2147483647

name of Antibody

antibodynote

text

2147483647

√

null

note

_createdby_key

int4

1001

mgi_user._user_key

gxd_antibody__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

1001

mgi_user._user_key

gxd_antibody__modifiedby_key_fkey R

user who last modified the record

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 15,135 rows at Mon Nov 14 06:18 EST 2022

Indexes:

Column(s)	Type	Sort	Constraint Name
_antibody_key	Primary key	Asc	gxd_antibody_pkey
_antibodyclass_key	Performance	Asc	gxd_antibody_idx_antibodyclass_key
_antibodytype_key	Performance	Asc	gxd_antibody_idx_antibodytype_key
_antigen_key	Performance	Asc	gxd_antibody_idx_antigen_key
_organism_key	Performance	Asc	gxd_antibody_idx_organism_key