SchemaSpy - Table zfindb.public.phenotype_observation

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
psg_id	int8	19	√	null
psg_pg_id	int8	19	√	null
psg_mrkr_zdb_id	text	2147483647	√	null
psg_mrkr_abbrev	text	2147483647	√	null
psg_mrkr_relation	text	2147483647	√	null
psg_e1a_zdb_id	text	2147483647	√	null
psg_e1a_name	text	2147483647	√	null
psg_e1_relation_name	text	2147483647	√	null
psg_e1b_zdb_id	text	2147483647	√	null
psg_e1b_name	text	2147483647	√	null
psg_e2a_zdb_id	text	2147483647	√	null
psg_e2a_name	text	2147483647	√	null
psg_e2_relation_name	text	2147483647	√	null
psg_e2b_zdb_id	text	2147483647	√	null
psg_e2b_name	text	2147483647	√	null
psg_tag	text	2147483647	√	null
psg_quality_zdb_id	text	2147483647	√	null
psg_quality_name	text	2147483647	√	null
psg_short_name	text	2147483647	√	null
psg_pre_eap_phenotype	bool	1	√	false

Table contained 195,590 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
psg_e1a_zdb_id	Performance	Asc	phenotype_observation_generated_e1a_zdb_index
psg_e1b_zdb_id	Performance	Asc	phenotype_observation_generated_e1b_zdb_index
psg_e2a_zdb_id	Performance	Asc	phenotype_observation_generated_e2a_zdb_index
psg_e2b_zdb_id	Performance	Asc	phenotype_observation_generated_e2b_zdb_index
psg_mrkr_zdb_id	Performance	Asc	phenotype_observation_generated_mrkr_zdb_index
psg_pg_id	Performance	Asc	phenotype_observation_generated_psg_pg_id_index
psg_quality_zdb_id	Performance	Asc	phenotype_observation_generated_quality_zdb_index