SchemaSpy - Table zfindb.public.experiment_condition

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

expcond_zdb_id

text

2147483647

zdb_active_data.zactvd_zdb_id

expcond_zdb_id_fk_odc C

expcond_exp_zdb_id

text

2147483647

experiment.exp_zdb_id

experiment_zdb_id_foreign_key C

expcond_cdt_zdb_id

text

2147483647

√

null

expcond_zeco_term_zdb_id

text

2147483647

expcond_ao_term_zdb_id

text

2147483647

√

null

term.term_zdb_id

expcond_ao_term_zdb_id_fk R

expcond_go_cc_term_zdb_id

text

2147483647

√

null

term.term_zdb_id

expcond_go_cc_term_zdb_id_fk R

expcond_chebi_term_zdb_id

text

2147483647

√

null

term.term_zdb_id

expcond_chebi_term_zdb_id_fk R

expcond_taxon_term_zdb_id

text

2147483647

√

null

term.term_zdb_id

expcond_taxon_term_zdb_id_fk R

expcond_spatial_term_zdb_id

text

2147483647

√

null

term.term_zdb_id

expcond_spatial_term_zdb_id_fk R

Table contained 22,684 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
expcond_ao_term_zdb_id	Performance	Asc	expcond_ao_term_zdb_id_fk_index
expcond_chebi_term_zdb_id	Performance	Asc	expcond_chebi_term_zdb_id_fk_index
expcond_exp_zdb_id	Performance	Asc	expcond_exp_zdb_id_foreign_key_index
expcond_go_cc_term_zdb_id	Performance	Asc	expcond_go_cc_term_zdb_id_fk_index
expcond_spatial_term_zdb_id	Performance	Asc	expcond_spatial_term_zdb_id_fk_index
expcond_taxon_term_zdb_id	Performance	Asc	expcond_taxon_term_zdb_id_fk_index
expcond_exp_zdb_id + expcond_zeco_term_zdb_id + expcond_ao_term_zdb_id + expcond_go_cc_term_zdb_id + expcond_chebi_term_zdb_id + expcond_taxon_term_zdb_id	Must be unique	Asc/Asc/Asc/Asc/Asc/Asc	experiment_condition_alternate_key
expcond_cdt_zdb_id	Performance	Asc	experiment_condition_cdt_fk_index
expcond_zeco_term_zdb_id	Performance	Asc	experiment_condition_zeco_term_zdb_id_foreign_key_index