Table zfindb.public.phenotype_observation_generated_temp Generated by
SchemaSpy
Legend: SourceForge.net
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
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