Table zfindb.informix.sequence_feature_chromosome_location 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
sfcl_zdb_id varchar 50
zdb_active_data.zactvd_zdb_id sfcl_zdb_id_fk_odc C
sfcl_feature_zdb_id varchar 50
feature.feature_zdb_id sfcl_feature_zdb_id_fk_odc C
sfcl_start_position int 10  √  null
sfcl_end_position int 10  √  null
sfcl_assembly varchar 10  √  null
sfcl_chromosome varchar 2
chromosome.chrom_name sfcl_chromosome_fk_odc R

Table contained 34,464 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
sfcl_feature_zdb_id + sfcl_start_position + sfcl_end_position + sfcl_chromosome + sfcl_assembly Must be unique Asc/Asc/Asc/Asc/Asc sfcl_alternate_key_index
sfcl_chromosome Performance Asc sfcl_chromosome_fk_index
sfcl_feature_zdb_id Performance Asc sfcl_feature_fk_index
sfcl_zdb_id Must be unique Asc sfcl_zdb_id_primary_key_index

Close relationships  within of separation: