Table zfindb.public.htp_dataset_sample Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
hds_pk_id bigserial 19  √  nextval('htp_dataset_sample_hds_pk_id_seq'::regclass)
hds_sample_id text 2147483647  √  null
hds_sample_title text 2147483647  √  null
hds_sample_type text 2147483647
hds_fish_zdb_id text 2147483647  √  null
fish
hds_sex text 2147483647  √  null
hds_assay_type text 2147483647
hds_sequencing_format text 2147483647  √  null
hds_hd_zdb_id text 2147483647  √  null
htp_dataset
hds_abundance text 2147483647  √  null
hds_assembly text 2147483647  √  null
hds_notes text 2147483647  √  null
hds_stage_term_zdb_id text 2147483647  √  null
term

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

Indexes:
Column(s) Type Sort Anomalies
hds_pk_id Primary key Asc  
hds_sample_title + hds_sample_id + hds_stage_term_zdb_id Must be unique Asc/Asc/Asc These unique columns are also nullable
hds_fish_zdb_id Performance Asc  
hds_hd_zdb_id Performance Asc  
hds_sample_id + hds_sample_title + hds_stage_term_zdb_id Must be unique Asc/Asc/Asc These unique columns are also nullable
hds_stage_term_zdb_id Performance Asc  

Close relationships  within of separation: