Table zfindb.public.htp_dataset_sample 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
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.fish_zdb_id hds_fish_zdb_id_fk_odc C
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.hd_zdb_id hds_hd_zdb_id_fk_odc C
hds_abundance text 2147483647  √  null
hds_assembly text 2147483647  √  null
hds_notes text 2147483647  √  null
hds_stage_term_zdb_id text 2147483647  √  null
term.term_zdb_id hds_stage_term_zdb_id_fk_odc R

Table contained 169 rows at Tue Sep 15 16:40 PDT 2020

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

Close relationships  within of separation: