amz_categories

740721 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
amz_book_categories_history.category_id amz_book_categories__category_id_3f2b739b_fk_amz_categ R
amz_book_category_in_bsr.category_id amz_book_category_in_category_id_673a47b9_fk_amz_categ R
amz_book_category_in_bsr_history.category_id amz_book_category_in_category_id_9396f2c6_fk_amz_categ R
amz_books_category_in_product_head.amzcategory_id amz_books_category_i_amzcategory_id_5540b316_fk_amz_categ R
amz_category_books.category_id amz_category_books_category_id_9813c0f7_fk_amz_categories_id R
amz_category_books_history.category_id amz_category_books_h_category_id_ed3ace94_fk_amz_categ R
amz_listing_categories.category_id amz_listing_categori_category_id_76d3a1c6_fk_amz_categ R
amz_search_filters.category_id amz_search_filters_category_id_ed84a4f4_fk_amz_categories_id R
category_url_id int8 19 null
name varchar 255 null
path_link varchar 255 √ null
parent_category_name varchar 255 √ null
updated_at timestamptz 35,6 null
created_at timestamptz 35,6 null
tag_id int8 19 √ null
amz_category_tags.id amz_categories_tag_id_bfd49953_fk_amz_category_tags_id R
country_id int8 19 null
amz_countries.id amz_categories_country_id_52b3e250_fk_amz_countries_id R
check_by_validation bool 1 null
in_data_validation bool 1 null
status_data_validation jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
amz_categories_pkey Primary key Asc id
amz_categories_country_id_52b3e250 Performance Asc country_id
amz_categories_tag_id_bfd49953 Performance Asc tag_id
idx_parent_category_name Performance Asc parent_category_name
idx_tag_id Performance Asc tag_id
idx_url_category Performance Asc category_url_id

Relationships

Close relationships within degrees of separation