Table zfindb.informix.go_term 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
goterm_zdb_id varchar 50
zdb_active_data.zactvd_zdb_id goterm_zdb_id_foreign_key C
goterm_go_id varchar 10
goterm_name varchar 255
goterm_ontology varchar 30  √  null
go_ontology.gont_ontology_name goterm_ontology_foreign_key R
goterm_is_obsolete boolean 1 f
goterm_is_secondary boolean 1 f

Table contained 33,559 rows at Thu Jun 22 08:42 PDT 2017

Column(s) Type Sort Constraint Name
goterm_is_obsolete + goterm_is_secondary + goterm_zdb_id Must be unique Asc/Asc/Asc go_term_primary_key_index
goterm_is_obsolete + goterm_is_secondary + goterm_go_id Must be unique Asc/Asc/Asc goterm_go_id_index
goterm_is_obsolete + goterm_is_secondary + goterm_ontology Performance Asc/Asc/Asc goterm_ontology_index

Close relationships  within of separation: