amz_audible_star_history

-1 rows


Description

Sure, I’d be happy to help with that. This table contains a list of stars earned by users on Amazon’s online shopping platform.

The fields in this table are as follows:

  • id: A unique identifier for each row in the data set.
  • total_review: The total number of reviews submitted by a user to rate a product using AMZN’s star rating system (i.e., 5 stars, 4 stars, 3 stars, 2 stars, or 1 star).
  • total_rating: The sum of all the individual ratings given to a particular product on Amazon. This corresponds to the total score awarded to that product by users who have rated it using the same five-star rating system (1 = poor, 5 = excellent) as suggested in the name.
  • star_1

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
total_review float8 17,17 √ null
total_rating int4 10 √ null
star_1 int4 10 √ null
star_2 int4 10 √ null
star_3 int4 10 √ null
star_4 int4 10 √ null
star_5 int4 10 √ null
created_at timestamptz 35,6 null
star_id int8 19 null
amz_audible_stars.id amz_audible_star_his_star_id_81df7cc1_fk_amz_audib 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_audible_star_history_pkey Primary key Asc id
amz_audible_star_history_star_id_81df7cc1 Performance Asc star_id

Relationships

Close relationships within degrees of separation