SchemaSpy - Table zfindb.public.antibody

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

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