SchemaSpy - Table zfindb.public.htp

Generated by
SchemaSpy

Legend:

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 Wed Sep 15 00:41 PDT 2021

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