amz_book_reviews

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
amz_book_review_media.review_id amz_book_review_media_review_id_da686680_fk_amz_book_reviews_id R
review_id varchar 20 null
profile_name varchar 255 √ null
country_code varchar 2 √ null
title varchar 255 √ null
review_helpful int4 10 √ null
description text 2147483647 √ null
verified_purchase bool 1 √ null
rating float8 17,17 √ null
publication_date timestamptz 35,6 √ null
md5_hash varchar 32 √ null
updated_at timestamptz 35,6 null
created_at timestamptz 35,6 null
book_id int8 19 √ null
amz_books.id amz_book_reviews_book_id_9897c496_fk_amz_books_id R
profile_photo_id int8 19 √ null
amz_media_url.id amz_book_reviews_profile_photo_id_8323214e_fk_amz_media_url_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_book_reviews_pkey Primary key Asc id
amz_book_reviews_book_id_9897c496 Performance Asc book_id
amz_book_reviews_profile_photo_id_8323214e Performance Asc profile_photo_id
amz_book_reviews_review_id_647de45b_like Performance Asc review_id
amz_book_reviews_review_id_key Must be unique Asc review_id
idx_book_reviews Performance Asc book_id
idx_profile_reviews Performance Asc review_id

Relationships

Close relationships within degrees of separation