Table zfindb.public.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
atb_zdb_id text 2147483647
expression_experiment2.xpatex_atb_zdb_id xpatex2_atb_zdb_id_foreign_key C
marker.mrkr_zdb_id atb_mrkr_foreign_key_odc C
atb_type text 2147483647  √  null
antibody_type.atbtype_name ant_type_foreign_key R
atb_hviso_name text 2147483647  √  null
heavy_chain_isotype.hviso_name atb_hviso_name_foreign_key R
atb_ltiso_name text 2147483647  √  null
light_chain_isotype.ltiso_name atb_ltiso_name_foreign_key R
atb_immun_organism text 2147483647  √  null
organism.organism_common_name atb_immun_organism_foreign_key R
atb_host_organism text 2147483647  √  null
organism.organism_common_name atb_host_organism_foreign_key R

Table contained 3,818 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
atb_zdb_id Primary key Asc antibody_primary_key
atb_host_organism Performance Asc atb_host_organism
atb_hviso_name Performance Asc atb_hviso_name_index
atb_immun_organism Performance Asc atb_immun_organism
atb_ltiso_name Performance Asc atb_ltiso_name_index
atb_type Performance Asc atb_type_index

Close relationships  within of separation: