amz_author_best_titles

185837 rows


Description

The table amz_author_best_titles contains information about the titles that an Amazon Bookseller API author wrote. This includes the title ID (which is a unique identifier for each title), the placement of the title on any best-sellers lists, the date the book was first published, and the IDs of the authors who wrote it, as well as the ID of the book the author has purchased from Amazon in the past few days. The fields provide a wealth of information about an author’s favorite books and can be used to gain insights into their reading habits and preferences. The table is updated regularly with new data to keep users informed on the latest news about their favorite authors.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
order int2 5 √ null
created_at timestamptz 35,6 √ null
author_id int8 19 null
amz_authors.id amz_author_best_titles_author_id_fb6a0048_fk_amz_authors_id R
book_id int8 19 √ null
amz_books.id amz_author_best_titles_book_id_c0ba1906_fk_amz_books_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_author_best_titles_pkey Primary key Asc id
amz_author_best_titles_author_id_fb6a0048 Performance Asc author_id
amz_author_best_titles_book_id_c0ba1906 Performance Asc book_id
idx_author_best_titles Performance Asc author_id
idx_book_best_titles Performance Asc book_id

Relationships

Close relationships within degrees of separation