SchemaSpy - Table zfindb.public.expression_phenotype

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

ept_pk_id

bigserial

√

nextval('expression_phenotype_term_ept_pk_id_seq'::regclass)

ept_relational_term

text

2147483647

'expressed_in'::text

ept_quality_term_zdb_id

text

2147483647

term.term_zdb_id

ept_term_foreign_key_odc C

ept_tag

text

2147483647

'abnormal'::text

ept_xpatres_id

int8

expression_result2.xpatres_pk_id

ept_xpatres_foreign_key_odc C

Table contained 31,948 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
ept_pk_id	Primary key	Asc	ept_pk_constraint
ept_quality_term_zdb_id	Performance	Asc	ept_quality_term_zdb_id_fk_index
ept_xpatres_id	Performance	Asc	ept_xpatres_zdb_id_fk_index
ept_xpatres_id + ept_quality_term_zdb_id	Must be unique	Asc/Asc	expression_phenotype_alternate_key