reviews

7749 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
review_images.review_id review_images_review_id_fkey R
review_replies.review_id review_replies_review_id_fkey R
user_id INT 10 null
users.id reviews_user_id_fkey R
product_id INT 10 √ null
products.id reviews_product_id_fkey N
streamer_id INT 10 √ null
users.id reviews_streamer_id_fkey N
rating TINYINT 3 null
comment TEXT 65535 √ null
status enum('PENDING', 'APPROVED', 'REJECTED') 8 null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null
product_variant_id INT 10 √ null
product_variants.id reviews_product_variant_id_fkey N

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_reviews_product_id Performance Asc product_id
idx_reviews_user_id Performance Asc user_id
reviews_product_variant_id_fkey Performance Asc product_variant_id
reviews_streamer_id_fkey Performance Asc streamer_id

Relationships

Close relationships within degrees of separation