Table zfindb.public.variant_flanking_sequence 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
vfseq_data_zdb_id text 2147483647
zdb_active_data.zactvd_zdb_id variant_sequence_zdb_active_data_foreign_key C
vfseq_type text 2147483647
vfseq_offset_start int4 10  √  null
vfseq_offset_stop int4 10  √  null
vfseq_sequence text 2147483647  √  null
vfseq_five_prime_flanking_sequence text 2147483647  √  null
vfseq_three_prime_flanking_sequence text 2147483647  √  null
vfseq_flanking_sequence_type text 2147483647  √  null
vfseq_flanking_sequence_origin text 2147483647  √  null
vfseq_variation text 2147483647  √  null
vfseq_zdb_id text 2147483647

Table contained 36,923 rows at Fri Oct 04 14:43 PDT 2019

Indexes:
Column(s) Type Sort Constraint Name
vfseq_zdb_id Primary key Asc variant_flanking_sequence_pkey
vfseq_data_zdb_id + vfseq_flanking_sequence_type Must be unique Asc/Asc vfseq_alternate_key
vfseq_variation Performance Asc vfseq_variantion_index

Close relationships  within of separation: