Table zfindb.public.htp_dataset 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
hd_zdb_id text 2147483647
htp_dataset_category_tag.hdct_dataset_zdb_id hdct_dataset_zdb_id_fk R
htp_dataset_publication.hdp_dataset_zdb_id hdp_dataset_zdb_id_fk C
htp_dataset_sample.hds_hd_zdb_id hds_hd_zdb_id_fk_odc C
zdb_active_data.zactvd_zdb_id hd_zdb_id_fk_odc C
hd_title text 2147483647  √  null
hd_summary text 2147483647  √  null
hd_date_curated timestamp 29,6 now()
hd_subseries_id text 2147483647  √  null
hd_original_dataset_id text 2147483647

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
hd_zdb_id Primary key Asc htp_dataset_pkey  
hd_title + hd_summary Must be unique Asc/Asc hd_id_unique These unique columns are also nullable
hd_title + hd_summary Must be unique Asc/Asc hd_title_summary_unique_index These unique columns are also nullable
hd_zdb_id Must be unique Asc ht_zdb_id_unique_index  

Close relationships  within of separation: