Table zfindb.informix.phenotype_source_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
pg_id int8 19  √  null
pg_genox_zdb_id varchar 50  √  null
pg_fig_zdb_id varchar 50  √  null
pg_start_stg_zdb_id varchar 50  √  null
pg_end_stg_zdb_id varchar 50  √  null

Table contained 50,742 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
pg_fig_zdb_id Performance Asc phenotype_source_generated_fig_index  
pg_genox_zdb_id Performance Asc phenotype_source_generated_genox_index  
pg_id Must be unique Asc phenotype_source_generated_pk_index This unique column is also nullable