amz_categories_df

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
amz_book_categories_history_df.category_id amz_book_categories__category_id_94fb2cf4_fk_amz_categ R
amz_book_category_in_bsr_df.category_id amz_book_category_in_category_id_6d43f72c_fk_amz_categ R
amz_book_category_in_bsr_history_df.category_id amz_book_category_in_category_id_50db4555_fk_amz_categ R
amz_books_df_category_in_product_head.dfamzcategory_id amz_books_df_categor_dfamzcategory_id_ea538365_fk_amz_categ R
amz_category_books_df.category_id amz_category_books_d_category_id_c36678c7_fk_amz_categ R
amz_category_books_history_df.category_id amz_category_books_h_category_id_c6573093_fk_amz_categ R
amz_listing_categories_df.category_id amz_listing_categori_category_id_b74954de_fk_amz_categ R
amz_search_filters_df.category_id amz_search_filters_d_category_id_039b8714_fk_amz_categ 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
source_id int4 10 √ null
is_valid bool 1 √ null
error_flag bool 1 √ null
simulated bool 1 √ null
validation_run_id int4 10 √ null
tag_id int8 19 √ null
amz_category_tags_df.id amz_categories_df_tag_id_0a6c5b90_fk_amz_category_tags_df_id R
country_id int8 19 null
amz_countries_df.id amz_categories_df_country_id_1f8cdc50_fk_amz_countries_df_id R

Indexes

Constraint Name Type Sort Column(s)
amz_categories_df_pkey Primary key Asc id
amz_categories_df_country_id_1f8cdc50 Performance Asc country_id
amz_categories_df_tag_id_0a6c5b90 Performance Asc tag_id

Relationships

Close relationships within degrees of separation