Table zfindb.public.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 text 2147483647
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 text 2147483647
mdcv_term_abbreviation text 2147483647  √  null
mdcv_term_order int8 19  √  null
mdcv_used_in text 2147483647

Table contained 68 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
mdcv_term_zdb_id Primary key Asc mdcv_pk

Close relationships  within of separation: