Table zfindb.informix.construct_component_search | Generated by SchemaSpy |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
ccs_coding_all_names + ccs_engineered_region_all_names + ccs_promoter_all_names + ccs_cons_id | Performance | Asc/Asc/Asc/Asc | ccs_cons_id_foreign_key_index |
ccs_coding_all_names + ccs_engineered_region_all_names + ccs_promoter_all_names + ccs_gene_zdb_id | Performance | Asc/Asc/Asc/Asc | ccs_gene_zdb_id_index |
ccs_coding_all_names + ccs_engineered_region_all_names + ccs_promoter_all_names + ccs_pk_id | Must be unique | Asc/Asc/Asc/Asc | ccs_primary_key_index |
ccs_coding_all_names + ccs_engineered_region_all_names + ccs_promoter_all_names | Performance | Asc/Asc/Asc | construct_component_search_all_coding_names_bts_index |
ccs_coding_all_names + ccs_engineered_region_all_names + ccs_promoter_all_names | Performance | Asc/Asc/Asc | construct_component_search_all_engineered_names_bts_index |
ccs_coding_all_names + ccs_engineered_region_all_names + ccs_promoter_all_names | Performance | Asc/Asc/Asc | construct_component_search_all_promoter_names_bts_index |