amz_audible_books_df

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
amz_audible_author_reviews_df.book_id amz_audible_author_r_book_id_c1d80a8c_fk_amz_audib R
amz_audible_books_categories_df_m2m.dfamzaudiblebook_id amz_audible_books_ca_dfamzaudiblebook_id_1304a423_fk_amz_audib R
amz_audible_books_df_customers_rating.dfamzaudiblebook_id amz_audible_books_df_dfamzaudiblebook_id_fd9ae215_fk_amz_audib R
amz_audible_books_tags_df_m2m.dfamzaudiblebook_id amz_audible_books_ta_dfamzaudiblebook_id_1c6e744b_fk_amz_audib R
amz_audible_category_history_df.book_id amz_audible_category_book_id_d32f88e8_fk_amz_audib R
amz_audible_listeners_also_enjoyed_df.related_id amz_audible_listener_related_id_6c5b58e6_fk_amz_audib R
amz_audible_people_who_viewed_df.related_id amz_audible_people_w_related_id_1587ede4_fk_amz_audib R
amz_audible_rating_history_df.book_id amz_audible_rating_h_book_id_0201a272_fk_amz_audib R
amz_audible_related_to_this_df.related_id amz_audible_related__related_id_4b84f9ee_fk_amz_audib R
amz_audible_review_history_df.book_id amz_audible_review_h_book_id_dcc89ee3_fk_amz_audib R
amz_audible_stars_df.book_id amz_audible_stars_df_book_id_8557c9c2_fk_amz_audib R
amz_audible_tag_history_df.book_id amz_audible_tag_hist_book_id_8ca0972f_fk_amz_audib R
asin_audible varchar 10 √ null
total_review float8 17,17 √ null
total_rating int4 10 √ null
language varchar 32 √ null
duration varchar 64 √ null
md5_hash_categories varchar 32 √ null
md5_hash_tags varchar 32 √ null
scraped bool 1 null
error bool 1 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_audible_countries_df.id amz_audible_books_df_country_id_adfeb039_fk_amz_audib R
book_id int8 19 null
amz_books_df.id amz_audible_books_df_book_id_b4dc8e01_fk_amz_books_df_id R

Indexes

Constraint Name Type Sort Column(s)
amz_audible_books_df_pkey Primary key Asc id
amz_audible_books_df_book_id_b4dc8e01 Performance Asc book_id
amz_audible_books_df_country_id_adfeb039 Performance Asc country_id

Relationships

Close relationships within degrees of separation