Table zfindb.public.htp_dataset 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
hd_zdb_id text 2147483647
htp_dataset_category_tag
htp_dataset_publication
htp_dataset_sample
zdb_active_data
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 Wed Sep 15 00:41 PDT 2021

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

Close relationships  within of separation: