Table zfindb.public.htp_dataset_publication 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
hdp_pk_id bigserial 19  √  nextval('htp_dataset_publication_hdp_pk_id_seq'::regclass)
hdp_dataset_zdb_id text 2147483647
htp_dataset.hd_zdb_id hdp_dataset_zdb_id_fk C
hdp_pub_zdb_id text 2147483647
publication.zdb_id hdp_pub_zdb_id_fk C

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

Indexes:
Column(s) Type Sort Constraint Name
hdp_pk_id Primary key Asc htp_dataset_publication_pkey
hdp_dataset_zdb_id + hdp_pub_zdb_id Must be unique Asc/Asc hdp_ak_index
hdp_dataset_zdb_id + hdp_pub_zdb_id Must be unique Asc/Asc hdp_dataset_pub_unique
hdp_dataset_zdb_id Performance Asc hdp_dataset_zdb_id_fk_index
hdp_pub_zdb_id Performance Asc hdp_pub_zdb_id_fk_index

Close relationships  within of separation: