Table zfindb.public.htp_dataset_category_tag 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
hdct_pk_id bigserial 19  √  nextval('htp_dataset_category_tag_hdct_pk_id_seq'::regclass)
hdct_dataset_zdb_id text 2147483647
htp_dataset.hd_zdb_id hdct_dataset_zdb_id_fk R
hdct_category_tag text 2147483647
htp_category_tag.hct_zdb_id hdct_category_tag_fk R

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

Indexes:
Column(s) Type Sort Constraint Name
hdct_pk_id Primary key Asc htp_dataset_category_tag_pkey
hdct_dataset_zdb_id + hdct_category_tag Must be unique Asc/Asc hdct_ak_index
hdct_category_tag Performance Asc hdct_dataset_category_tag_fk_index
hdct_dataset_zdb_id Performance Asc hdct_dataset_zdb_id_fk_index
hdct_dataset_zdb_id + hdct_category_tag Must be unique Asc/Asc htp_dataset_category_unique

Close relationships  within of separation: