amz_books_dv

33026 rows


Description

La tabla amz_books_dv contiene información detallada sobre libros disponibles en Amazon. Tiene numerosas columnas que guardan datos como el título del libro, la descripción, las calificaciones de revisión, y los detalles específicos del producto, por ejemplo, la duración del audiolibro, el narrador y las dimensiones del libro. Además, también incluye columnas para rastrear la validez de los datos, errores y el historial de actualizaciones. Esta tabla también almacena enlaces a medios relacionados con el libro y asociaciones con otras tablas mediante ids, como el país, la serie del libro y los ids de las imágenes de cubierta y contraportada.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
amz_audible_books_dv.book_id amz_audible_books_dv_book_id_cc8d2c83_fk_amz_books_dv_id R
amz_author_all_books_dv.book_id amz_author_all_books_dv_book_id_a4b74137_fk_amz_books_dv_id R
amz_author_best_titles_dv.book_id amz_author_best_titles_dv_book_id_e3adf47e_fk_amz_books_dv_id R
amz_best_sellers_dv.book_id amz_best_sellers_dv_book_id_deda0387_fk_amz_books_dv_id R
amz_book_a_plus_history_dv.book_id amz_book_a_plus_history_dv_book_id_cf991a55_fk_amz_books_dv_id R
amz_book_authors_dv.book_id amz_book_authors_dv_book_id_07d04ffe_fk_amz_books_dv_id R
amz_book_badge_history_dv.book_id amz_book_badge_history_dv_book_id_3e94ac8f_fk_amz_books_dv_id R
amz_book_badges_dv.book_id amz_book_badges_dv_book_id_00695762_fk_amz_books_dv_id R
amz_book_categories_history_dv.book_id amz_book_categories__book_id_36eb776e_fk_amz_books R
amz_book_category_in_bsr_dv.book_id amz_book_category_in_bsr_dv_book_id_b50bc766_fk_amz_books_dv_id R
amz_book_category_in_bsr_history_dv.book_id amz_book_category_in_book_id_2b779d31_fk_amz_books R
amz_book_cover_history_dv.book_id amz_book_cover_history_dv_book_id_41e9c297_fk_amz_books_dv_id R
amz_book_customer_also_viewed_dv.also_viewed_book_id amz_book_customer_al_also_viewed_book_id_c10f9eab_fk_amz_books R
amz_book_customer_also_viewed_dv.book_id amz_book_customer_al_book_id_cfd2dc71_fk_amz_books R
amz_book_description_history_dv.book_id amz_book_description_book_id_4f493137_fk_amz_books R
amz_book_frequently_bought_together_dv.book_id amz_book_frequently__book_id_d46bb38b_fk_amz_books R
amz_book_frequently_bought_together_dv.bought_together_book_id amz_book_frequently__bought_together_book_7210ad21_fk_amz_books R
amz_book_media_dv.book_id amz_book_media_dv_book_id_ce93de94_fk_amz_books_dv_id R
amz_book_more_items_to_explore_dv.book_id amz_book_more_items__book_id_6c5b7291_fk_amz_books R
amz_book_more_items_to_explore_dv.more_items_book_id amz_book_more_items__more_items_book_id_1b462952_fk_amz_books R
amz_book_price_history_dv.book_id amz_book_price_history_dv_book_id_196a99e1_fk_amz_books_dv_id R
amz_book_rating_history_dv.book_id amz_book_rating_history_dv_book_id_b1c8eb99_fk_amz_books_dv_id R
amz_book_related_ads_dv.ad_book_id amz_book_related_ads_dv_ad_book_id_2f297801_fk_amz_books_dv_id R
amz_book_related_ads_dv.book_id amz_book_related_ads_dv_book_id_92040fb7_fk_amz_books_dv_id R
amz_book_related_purchases_dv.book_id amz_book_related_pur_book_id_39b894d9_fk_amz_books R
amz_book_related_purchases_dv.related_purchase_book_id amz_book_related_pur_related_purchase_boo_20905fbe_fk_amz_books R
amz_book_review_history_dv.book_id amz_book_review_history_dv_book_id_35a3a879_fk_amz_books_dv_id R
amz_book_review_media_dv.book_id amz_book_review_media_dv_book_id_bb055626_fk_amz_books_dv_id R
amz_book_review_summary_history_dv.book_id amz_book_review_summ_book_id_9a30f019_fk_amz_books R
amz_book_reviews_dv.book_id amz_book_reviews_dv_book_id_6fa5b870_fk_amz_books_dv_id R
amz_book_star_history_dv.book_id amz_book_star_history_dv_book_id_ef1c3665_fk_amz_books_dv_id R
amz_books_dv_authors.dvamzbook_id amz_books_dv_authors_dvamzbook_id_5821305d_fk_amz_books_dv_id R
amz_books_dv_categories_in_bsr.dvamzbook_id amz_books_dv_categor_dvamzbook_id_594e2b5a_fk_amz_books R
amz_books_dv_category_in_product_head.dvamzbook_id amz_books_dv_categor_dvamzbook_id_429fb929_fk_amz_books R
amz_books_dv_providers.dvamzbook_id amz_books_dv_providers_dvamzbook_id_f657a3c2_fk_amz_books_dv_id R
amz_category_books_dv.book_id amz_category_books_dv_book_id_b90062f4_fk_amz_books_dv_id R
amz_category_books_history_dv.book_id amz_category_books_h_book_id_d27919ef_fk_amz_books R
amz_charts_read_dv.charts_read_dv amz_charts_read_dv_charts_read_dv_e55e7b0c_fk_amz_books_dv_id R
amz_charts_sold_dv.charts_sold_dv amz_charts_sold_dv_charts_sold_dv_c5f013aa_fk_amz_books_dv_id R
amz_gifted_dv.book_id amz_gifted_dv_book_id_eafbb0f6_fk_amz_books_dv_id R
amz_listing_books_dv.book_id amz_listing_books_dv_book_id_74ba6b51_fk_amz_books_dv_id R
amz_new_releases_dv.book_id amz_new_releases_dv_book_id_9d0698f6_fk_amz_books_dv_id R
amz_series_books_dv.book_id amz_series_books_dv_book_id_1e19773e_fk_amz_books_dv_id R
amz_series_dv_book.dvamzbook_id amz_series_dv_book_dvamzbook_id_e376824b_fk_amz_books_dv_id R
amz_wishlist_dv.book_id amz_wishlist_dv_book_id_f3b5f9c7_fk_amz_books_dv_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_dv.id amz_books_dv_country_id_04f5741b_fk_amz_countries_dv_id R
back_cover_media_id int8 19 √ null
amz_media_url_dv.id amz_books_dv_back_cover_media_id_d071a055_fk_amz_media R
cover_media_id int8 19 √ null
amz_media_url_dv.id amz_books_dv_cover_media_id_833f8071_fk_amz_media_url_dv_id R
series_id int8 19 √ null
amz_series_dv.id amz_books_dv_series_id_5bc67fbe_fk_amz_series_dv_id R
url_id int8 19 √ null
amz_urls_dv.id amz_books_dv_url_id_8b37f4ad_fk_amz_urls_dv_id R

Indexes

Constraint Name Type Sort Column(s)
amz_books_dv_pkey Primary key Asc id
amz_books_dv_back_cover_media_id_d071a055 Performance Asc back_cover_media_id
amz_books_dv_country_id_04f5741b Performance Asc country_id
amz_books_dv_cover_media_id_833f8071 Performance Asc cover_media_id
amz_books_dv_series_id_5bc67fbe Performance Asc series_id
amz_books_dv_url_id_8b37f4ad Performance Asc url_id

Relationships

Close relationships within degrees of separation