Table zfindb.public.mutation_detail_controlled_vocabulary 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
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 Tue Sep 15 16:40 PDT 2020

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

Close relationships  within of separation: