amz_books_df

928 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
amz_audible_books_df.book_id amz_audible_books_df_book_id_b4dc8e01_fk_amz_books_df_id R
amz_author_all_books_df.book_id amz_author_all_books_df_book_id_a67e6191_fk_amz_books_df_id R
amz_author_best_titles_df.book_id amz_author_best_titles_df_book_id_22c30c23_fk_amz_books_df_id R
amz_best_sellers_df.book_id amz_best_sellers_df_book_id_786817f0_fk_amz_books_df_id R
amz_book_a_plus_history_df.book_id amz_book_a_plus_history_df_book_id_e5a2b82a_fk_amz_books_df_id R
amz_book_authors_df.book_id amz_book_authors_df_book_id_608c9ce7_fk_amz_books_df_id R
amz_book_badge_history_df.book_id amz_book_badge_history_df_book_id_1675ffa5_fk_amz_books_df_id R
amz_book_badges_df.book_id amz_book_badges_df_book_id_412d6102_fk_amz_books_df_id R
amz_book_categories_history_df.book_id amz_book_categories__book_id_5103e259_fk_amz_books R
amz_book_category_in_bsr_df.book_id amz_book_category_in_bsr_df_book_id_8e922328_fk_amz_books_df_id R
amz_book_category_in_bsr_history_df.book_id amz_book_category_in_book_id_791f50ee_fk_amz_books R
amz_book_cover_history_df.book_id amz_book_cover_history_df_book_id_6616cf56_fk_amz_books_df_id R
amz_book_customer_also_viewed_df.also_viewed_book_id amz_book_customer_al_also_viewed_book_id_838fe210_fk_amz_books R
amz_book_customer_also_viewed_df.book_id amz_book_customer_al_book_id_9b50493f_fk_amz_books R
amz_book_description_history_df.book_id amz_book_description_book_id_e1c8cd4f_fk_amz_books R
amz_book_frequently_bought_together_df.book_id amz_book_frequently__book_id_c0db6b95_fk_amz_books R
amz_book_frequently_bought_together_df.bought_together_book_id amz_book_frequently__bought_together_book_b9e9ae9d_fk_amz_books R
amz_book_media_df.book_id amz_book_media_df_book_id_d9e6f759_fk_amz_books_df_id R
amz_book_more_items_to_explore_df.book_id amz_book_more_items__book_id_1f588972_fk_amz_books R
amz_book_more_items_to_explore_df.more_items_book_id amz_book_more_items__more_items_book_id_e2af04ea_fk_amz_books R
amz_book_price_history_df.book_id amz_book_price_history_df_book_id_0a7a4a21_fk_amz_books_df_id R
amz_book_rating_history_df.book_id amz_book_rating_history_df_book_id_519a43c4_fk_amz_books_df_id R
amz_book_related_ads_df.ad_book_id amz_book_related_ads_df_ad_book_id_80b071e9_fk_amz_books_df_id R
amz_book_related_ads_df.book_id amz_book_related_ads_df_book_id_9c56df53_fk_amz_books_df_id R
amz_book_related_purchases_df.book_id amz_book_related_pur_book_id_79c8e8d7_fk_amz_books R
amz_book_related_purchases_df.related_purchase_book_id amz_book_related_pur_related_purchase_boo_4d4b39df_fk_amz_books R
amz_book_review_history_df.book_id amz_book_review_history_df_book_id_c11a6421_fk_amz_books_df_id R
amz_book_review_media_df.book_id amz_book_review_media_df_book_id_a6a802e0_fk_amz_books_df_id R
amz_book_review_summary_history_df.book_id amz_book_review_summ_book_id_fd688e30_fk_amz_books R
amz_book_reviews_df.book_id amz_book_reviews_df_book_id_f8bb99de_fk_amz_books_df_id R
amz_book_star_history_df.book_id amz_book_star_history_df_book_id_1b404bfe_fk_amz_books_df_id R
amz_books_df_authors.dfamzbook_id amz_books_df_authors_dfamzbook_id_cf1d239b_fk_amz_books_df_id R
amz_books_df_categories_in_bsr.dfamzbook_id amz_books_df_categor_dfamzbook_id_3d0c2243_fk_amz_books R
amz_books_df_category_in_product_head.dfamzbook_id amz_books_df_categor_dfamzbook_id_7141b9ca_fk_amz_books R
amz_books_df_providers.dfamzbook_id amz_books_df_providers_dfamzbook_id_a85cd6ea_fk_amz_books_df_id R
amz_category_books_df.book_id amz_category_books_df_book_id_18c12c7d_fk_amz_books_df_id R
amz_category_books_history_df.book_id amz_category_books_h_book_id_dc364b3e_fk_amz_books R
amz_charts_read_df.charts_read_df amz_charts_read_df_charts_read_df_d0d66136_fk_amz_books_df_id R
amz_charts_sold_df.charts_sold_df amz_charts_sold_df_charts_sold_df_04f2803f_fk_amz_books_df_id R
amz_gifted_df.book_id amz_gifted_df_book_id_04eebc3a_fk_amz_books_df_id R
amz_listing_books_df.book_id amz_listing_books_df_book_id_6b91c64f_fk_amz_books_df_id R
amz_new_releases_df.book_id amz_new_releases_df_book_id_6eb66466_fk_amz_books_df_id R
amz_series_books_df.book_id amz_series_books_df_book_id_fede6821_fk_amz_books_df_id R
amz_series_df_book.dfamzbook_id amz_series_df_book_dfamzbook_id_966e462c_fk_amz_books_df_id R
amz_wishlist_df.book_id amz_wishlist_df_book_id_470340ad_fk_amz_books_df_id R
title varchar 255 √ null
subtitle varchar 128 √ null
description text 2147483647 √ null
md5_hash_description varchar 32 √ null
variant varchar 36 √ null
variants jsonb 2147483647 √ null
total_review float8 17,17 √ null
total_rating int4 10 √ null
star_1 float8 17,17 √ null
star_2 float8 17,17 √ null
star_3 float8 17,17 √ null
star_4 float8 17,17 √ null
star_5 float8 17,17 √ null
md5_hash_star varchar 32 √ null
badge_value varchar 255 √ null
badge_type varchar 255 √ null
badge_link varchar 255 √ null
md5_hash_badge varchar 32 √ null
a_plus jsonb 2147483647 √ null
md5_hash_a_plus varchar 32 √ null
videos jsonb 2147483647 √ null
md5_hash_videos varchar 32 √ null
kindle_unlimited int4 10 √ null
kindle_prime int4 10 √ null
audiobook_duration text 2147483647 √ null
audiobook_narrator varchar 255 √ null
bsr int4 10 √ null
md5_hash_cover_and_back_cover varchar 32 √ null
customer_say_tags jsonb 2147483647 √ null
customer_say_summary text 2147483647 √ null
language varchar 32 √ null
dimensions varchar 255 √ null
publisher varchar 255 √ null
md5_hash_category_in_product_head varchar 32 √ null
isbn_13 varchar 20 √ null
isbn_10 varchar 20 √ null
root_category int8 19 √ null
scraped bool 1 null
error bool 1 null
price float8 17,17 √ null
weight varchar 10 √ null
publication_date timestamptz 35,6 √ null
updated_at_providers timestamptz 35,6 √ null
updated_at_reviews timestamptz 35,6 √ 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
country_id int8 19 null
amz_countries_df.id amz_books_df_country_id_839996c4_fk_amz_countries_df_id R
back_cover_media_id int8 19 √ null
amz_media_url_df.id amz_books_df_back_cover_media_id_0dda705c_fk_amz_media R
cover_media_id int8 19 √ null
amz_media_url_df.id amz_books_df_cover_media_id_0d4e6280_fk_amz_media_url_df_id R
series_id int8 19 √ null
amz_series_df.id amz_books_df_series_id_4456043a_fk_amz_series_df_id R
url_id int8 19 √ null
amz_urls_df.id amz_books_df_url_id_e7f1a68f_fk_amz_urls_df_id R

Indexes

Constraint Name Type Sort Column(s)
amz_books_df_pkey Primary key Asc id
amz_books_df_back_cover_media_id_0dda705c Performance Asc back_cover_media_id
amz_books_df_country_id_839996c4 Performance Asc country_id
amz_books_df_cover_media_id_0d4e6280 Performance Asc cover_media_id
amz_books_df_series_id_4456043a Performance Asc series_id
amz_books_df_url_id_e7f1a68f Performance Asc url_id

Relationships

Close relationships within degrees of separation