SchemaSpy - Table zfindb.public.phenotype_observation_generated

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default
psg_id	bigserial	19		√	nextval('phenotype_observation_generated_temp_psg_id_seq'::regclass)
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