amz_books

2823656 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
amz_audible_books.book_id amz_audible_books_book_id_102b3c53_fk_amz_books_id R
amz_author_all_books.book_id amz_author_all_books_book_id_f1163b31_fk_amz_books_id R
amz_author_best_titles.book_id amz_author_best_titles_book_id_c0ba1906_fk_amz_books_id R
amz_best_sellers.book_id amz_best_sellers_book_id_3d4355b9_fk_amz_books_id R
amz_book_a_plus_history.book_id amz_book_a_plus_history_book_id_f9076726_fk_amz_books_id R
amz_book_authors.book_id amz_book_authors_book_id_51f88c4b_fk_amz_books_id R
amz_book_badge_history.book_id amz_book_badge_history_book_id_5a5a50c5_fk_amz_books_id R
amz_book_badges.book_id amz_book_badges_book_id_7d153889_fk_amz_books_id R
amz_book_categories_history.book_id amz_book_categories_history_book_id_87df0bb1_fk_amz_books_id R
amz_book_category_in_bsr.book_id amz_book_category_in_bsr_book_id_582c2599_fk_amz_books_id R
amz_book_category_in_bsr_history.book_id amz_book_category_in_book_id_626842d4_fk_amz_books R
amz_book_cover_history.book_id amz_book_cover_history_book_id_fe49a619_fk_amz_books_id R
amz_book_customer_also_viewed.also_viewed_book_id amz_book_customer_al_also_viewed_book_id_ec32de13_fk_amz_books R
amz_book_customer_also_viewed.book_id amz_book_customer_also_viewed_book_id_ae5dca48_fk_amz_books_id R
amz_book_description_history.book_id amz_book_description_history_book_id_a43753b7_fk_amz_books_id R
amz_book_frequently_bought_together.book_id amz_book_frequently__book_id_2926ac1f_fk_amz_books R
amz_book_frequently_bought_together.bought_together_book_id amz_book_frequently__bought_together_book_5f18cd99_fk_amz_books R
amz_book_media.book_id amz_book_media_book_id_aec9e987_fk_amz_books_id R
amz_book_more_items_to_explore.book_id amz_book_more_items_to_explore_book_id_33d9bd68_fk_amz_books_id R
amz_book_more_items_to_explore.more_items_book_id amz_book_more_items__more_items_book_id_7812d1f3_fk_amz_books R
amz_book_price_history.book_id amz_book_price_history_book_id_ca645c57_fk_amz_books_id R
amz_book_rating_history.book_id amz_book_rating_history_book_id_ae248c1f_fk_amz_books_id R
amz_book_related_ads.ad_book_id amz_book_related_ads_ad_book_id_2d4a25f6_fk_amz_books_id R
amz_book_related_ads.book_id amz_book_related_ads_book_id_9913ebbb_fk_amz_books_id R
amz_book_related_purchases.book_id amz_book_related_purchases_book_id_dd43892b_fk_amz_books_id R
amz_book_related_purchases.related_purchase_book_id amz_book_related_pur_related_purchase_boo_d73ccd89_fk_amz_books R
amz_book_review_history.book_id amz_book_review_history_book_id_889f3282_fk_amz_books_id R
amz_book_review_media.book_id amz_book_review_media_book_id_41ba54c9_fk_amz_books_id R
amz_book_review_summary_history.book_id amz_book_review_summ_book_id_a2da4c51_fk_amz_books R
amz_book_reviews.book_id amz_book_reviews_book_id_9897c496_fk_amz_books_id R
amz_book_star_history.book_id amz_book_star_history_book_id_7e1e8f58_fk_amz_books_id R
amz_books_authors.amzbook_id amz_books_authors_amzbook_id_43f6a1b6_fk_amz_books_id R
amz_books_categories_in_bsr.amzbook_id amz_books_categories_in_bsr_amzbook_id_de6eb948_fk_amz_books_id R
amz_books_category_in_product_head.amzbook_id amz_books_category_i_amzbook_id_7dbf7fe9_fk_amz_books R
amz_books_providers.amzbook_id amz_books_providers_amzbook_id_5c216a58_fk_amz_books_id R
amz_category_books.book_id amz_category_books_book_id_888d8409_fk_amz_books_id R
amz_category_books_history.book_id amz_category_books_history_book_id_ae9700a4_fk_amz_books_id R
amz_charts_read.charts_read amz_charts_read_charts_read_df54edca_fk_amz_books_id R
amz_charts_sold.charts_sold amz_charts_sold_charts_sold_80d71ee4_fk_amz_books_id R
amz_gifted.book_id amz_gifted_book_id_89778e3e_fk_amz_books_id R
amz_listing_books.book_id amz_listing_books_book_id_9e006f89_fk_amz_books_id R
amz_new_releases.book_id amz_new_releases_book_id_b081532e_fk_amz_books_id R
amz_series_book.amzbook_id amz_series_book_amzbook_id_be41cb2f_fk_amz_books_id R
amz_series_books.book_id amz_series_books_book_id_1e4790a7_fk_amz_books_id R
amz_wishlist.book_id amz_wishlist_book_id_e654bcf1_fk_amz_books_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
country_id int8 19 null
amz_countries.id amz_books_country_id_2f3114ca_fk_amz_countries_id R
back_cover_media_id int8 19 √ null
amz_media_url.id amz_books_back_cover_media_id_f8a4a1d2_fk_amz_media_url_id R
cover_media_id int8 19 √ null
amz_media_url.id amz_books_cover_media_id_de6da1b9_fk_amz_media_url_id R
url_id int8 19 √ null
amz_urls.id amz_books_url_id_b996e9e7_fk_amz_urls_id R
series_id int8 19 √ null
amz_series.id amz_books_series_id_e97ee3d7_fk_amz_series_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_books_pkey Primary key Asc id
amz_books_back_cover_media_id_f8a4a1d2 Performance Asc back_cover_media_id
amz_books_country_id_2f3114ca Performance Asc country_id
amz_books_cover_media_id_de6da1b9 Performance Asc cover_media_id
amz_books_series_id_e97ee3d7 Performance Asc series_id
amz_books_url_id_b996e9e7 Performance Asc url_id
FK_amz_books_amz_urls Performance Asc url_id

Relationships

Close relationships within degrees of separation