Table zfindb.informix.xpat_exp_details_generated Generated by
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
xedg_pk_id int8 19
xedg_zdb_id varchar 50
xedg_fig_zdb_id varchar 50
xedg_assay_name varchar 40
xedg_probe_feature_zdb_id varchar 50  √  null
xedg_gene_zdb_id varchar 50  √  null
xedg_direct_submission_date datetime year to day 10 current
xedg_dblink_zdb_id varchar 50  √  null
xedg_genox_zdb_id varchar 50  √  null
xedg_atb_zdb_id varchar 50  √  null

Table contained 142,611 rows at Thu Jun 22 08:42 PDT 2017

Column(s) Type Sort Constraint Name
xedg_fig_zdb_id + xedg_genox_zdb_id + xedg_assay_name + xedg_probe_feature_zdb_id + xedg_gene_zdb_id + xedg_dblink_zdb_id + xedg_atb_zdb_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc xedg_alternate_ky_index
xedg_assay_name Performance Asc xedg_assay_name_foreign_ky_index
xedg_atb_zdb_id Performance Asc xedg_atb_zdb_id_index
xedg_dblink_zdb_id Performance Asc xedg_dblink_foreign_ky
xedg_genox_zdb_id Performance Asc xedg_featexp_zdb_id_foreign_ky_index
xedg_gene_zdb_id Performance Asc xedg_gene_zdb_id_foreign_ky_index
xedg_probe_feature_zdb_id Performance Asc xedg_marker_foreign_ky_index
xedg_pk_id Must be unique Asc xedg_primary_ky_index
xedg_fig_zdb_id Performance Asc xedg_source_foreign_ky_index