Table zfindb.public.sequence_feature_chromosome_location 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
sfcl_zdb_id text 2147483647
zdb_active_data.zactvd_zdb_id sfcl_zdb_id_fk_odc C
sfcl_feature_zdb_id text 2147483647
zdb_active_data.zactvd_zdb_id sfcl_feature_zdb_id_fk_odc C
sfcl_start_position int4 10  √  null
sfcl_end_position int4 10  √  null
sfcl_assembly text 2147483647  √  null
sfcl_chromosome text 2147483647
chromosome.chrom_name sfcl_chromosome_fk_odc R
sfcl_evidence_code text 2147483647
term.term_zdb_id evidence_code_fk R
sfcl_chromosome_reference_accession_number text 2147483647  √  null

Table contained 113,394 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
sfcl_zdb_id Primary key Asc sfcl_primary_key
sfcl_feature_zdb_id + sfcl_start_position + sfcl_end_position + sfcl_chromosome + sfcl_assembly Must be unique Asc/Asc/Asc/Asc/Asc sfcl_alternate_key_index
sfcl_chromosome Performance Asc sfcl_chromosome_fk_index
sfcl_feature_zdb_id Performance Asc sfcl_feature_fk_index

Close relationships  within of separation: