Table zfindb.public.phenotype_observation_generated 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 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 144,872 rows at Mon Sep 03 04:09 PDT 2018

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