Table: reviews
updated_at (ascending)
Total: 17 records
Loading relationships diagram...
| Column | Value |
|---|
| Column | Type | Nullable | Default | Primary Key |
|---|---|---|---|---|
| id | integer | No | NULL |
Yes |
| product_id | integer | No | NULL |
No |
| customer_id | integer | No | NULL |
No |
| rating | integer | Yes | NULL |
No |
| comment | text | Yes | NULL |
No |
| created_at | datetime | No | NULL |
No |
| updated_at | datetime | No | NULL |
No |
| Name | Columns | Unique |
|---|---|---|
| index_reviews_on_customer_id | customer_id | No |
| index_reviews_on_product_id | product_id | No |
| index_reviews_on_product_id_and_rating | product_id, rating | No |
| index_reviews_on_rating | rating | No |