Table zfindb.informix.mutation_detail_controlled_vocabulary 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
mdcv_term_zdb_id varchar 50
feature_dna_mutation_detail.fdmd_dna_mutation_term_zdb_id fdmd_mdcv_fk R
feature_protein_mutation_detail.fpmd_protein_consequence_term_zdb_id fpmd_mdcv_fk R
feature_transcript_mutation_detail.ftmd_transcript_consequence_term_zdb_id ftmd_mdcv_fk R
term.term_zdb_id mdcv_term_zdb_id_fk R
mdcv_term_display_name varchar 255
mdcv_term_abbreviation varchar 255  √  null
mdcv_term_order int8 19  √  null
mdcv_used_in varchar 100

Table contained 70 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
mdcv_term_zdb_id Must be unique Asc mdcv_zdb_id_pk_index

Close relationships  within of separation: