Table zfindb.public.htp_dataset_sample_detail 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
hdsd_pk_id bigserial 19  √  nextval('htp_dataset_sample_detail_hdsd_pk_id_seq'::regclass)
hdsd_hds_id int8 19
hdsd_anatomy_super_term_zdb_id text 2147483647
term.term_zdb_id hdsd_anatomy_super_term_zdb_id_fk R
hdsd_anatomy_sub_term_zdb_id text 2147483647  √  null
term.term_zdb_id hdsd_anatomy_sub_term_zdb_id_fk R
hdsd_anatomy_sub_term_qualifier_zdb_id text 2147483647  √  null
term.term_zdb_id hdsd_anatomy_sub_term_qualifier_zdb_id_fk R
hdsd_anatomy_super_term_qualifier_zdb_id text 2147483647  √  null
term.term_zdb_id hdsd_anatomy_super_term_qualifier_zdb_id_fk R
hdsd_cellular_component_term_zdb_id text 2147483647  √  null
term.term_zdb_id hdsd_cellular_component_term_zdb_id_fk R
hdsd_cellular_component_term_qualifier_zdb_id text 2147483647  √  null
term.term_zdb_id hdsd_cellular_component_qualifier_term_zdb_id_fk R

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

Indexes:
Column(s) Type Sort Constraint Name
hdsd_pk_id Primary key Asc htp_dataset_sample_detail_pkey
hdsd_hds_id + hdsd_anatomy_super_term_zdb_id + hdsd_anatomy_sub_term_zdb_id + hdsd_anatomy_super_term_qualifier_zdb_id + hdsd_anatomy_sub_term_qualifier_zdb_id + hdsd_cellular_component_term_zdb_id + hdsd_cellular_component_term_qualifier_zdb_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc hdsd_alternate_key
hdsd_cellular_component_term_qualifier_zdb_id Performance Asc hdsd_anatomy_cellular_component_term_qualifier_zdb_id_fk_index
hdsd_cellular_component_term_zdb_id Performance Asc hdsd_anatomy_cellular_component_term_zdb_id_fk_index
hdsd_anatomy_sub_term_qualifier_zdb_id Performance Asc hdsd_anatomy_sub_term_qualifier_zdb_id_fk_index
hdsd_anatomy_sub_term_zdb_id Performance Asc hdsd_anatomy_sub_term_zdb_id_fk_index
hdsd_anatomy_super_term_qualifier_zdb_id Performance Asc hdsd_anatomy_super_term_qualifier_zdb_id_fk_index
hdsd_anatomy_super_term_zdb_id Performance Asc hdsd_anatomy_super_term_zdb_id_fk_index
hdsd_hds_id + hdsd_anatomy_super_term_zdb_id + hdsd_anatomy_sub_term_zdb_id + hdsd_anatomy_super_term_qualifier_zdb_id + hdsd_anatomy_sub_term_qualifier_zdb_id + hdsd_cellular_component_term_zdb_id + hdsd_cellular_component_term_qualifier_zdb_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc hdsd_hds_id_ak_index

Close relationships  within of separation: