SchemaSpy - Table zfindb.informix.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	serial8	19		√
psg_pg_id	int8	19	√		null
psg_mrkr_zdb_id	varchar	50	√		null
psg_mrkr_abbrev	varchar	255	√		null
psg_mrkr_relation	varchar	30	√		null
psg_e1a_zdb_id	varchar	50	√		null
psg_e1a_name	varchar	255	√		null
psg_e1_relation_name	varchar	30	√		null
psg_e1b_zdb_id	varchar	50	√		null
psg_e1b_name	varchar	255	√		null
psg_e2a_zdb_id	varchar	50	√		null
psg_e2a_name	varchar	255	√		null
psg_e2_relation_name	varchar	50	√		null
psg_e2b_zdb_id	varchar	50	√		null
psg_e2b_name	varchar	255	√		null
psg_tag	varchar	40	√		null
psg_quality_zdb_id	varchar	50	√		null
psg_quality_name	varchar	255	√		null
psg_short_name	varchar	255	√		null
psg_pre_eap_phenotype	boolean	1	√		f

Table contained 124,496 rows at Thu Jun 22 08:42 PDT 2017