Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.gxd_antibody 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
_antibody_key int4 10
gxd_antibodyalias._antibody_key gxd_antibodyalias__antibody_key R
gxd_antibodymarker._antibody_key gxd_antibodymarker__antibody_key R
gxd_antibodyprep._antibody_key gxd_antibodyprep__antibody_key R
_antibodyclass_key int4 10
gxd_antibodyclass._antibodyclass_key gxd_antibody__antibodyclass_key R
_antibodytype_key int4 10
gxd_antibodytype._antibodytype_key gxd_antibody__antibodytype_key R
_organism_key int4 10
mgi_organism._organism_key gxd_antibody__organism_key R
_antigen_key int4 10
gxd_antigen._antigen_key gxd_antibody__antigen_key R
antibodyname varchar 255
antibodynote varchar 255  √  null
recogwestern varchar 15
recogimmunprecip varchar 15
recognote varchar 255  √  null
_createdby_key int4 10
mgi_user._user_key gxd_antibody__createdby_key R
_modifiedby_key int4 10
mgi_user._user_key gxd_antibody__modifiedby_key R
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 3,910 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_antibody_key Primary key Asc gxd_antibody_pkey
_antibody_key Must be unique Asc gxd_antibody_idx_antibody_key
_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

Close relationships  within of separation: