Database diagram
| Column | Constraints |
|---|---|
| display_name | NOT NULL |
| NOT NULL, UNIQUE | |
| password_hash | NOT NULL |
| Column | Constraints |
|---|---|
| seller_id | NOT NULL, FOREIGN KEY |
| name | NOT NULL |
| price | NOT NULL |
| Column | Constraints |
|---|---|
| product_id | NOT NULL, FOREIGN KEY |
| url | NOT NULL |
| preview | NOT NULL |
| Column | Constraints |
|---|---|
| product_id | NOT NULL, FOREIGN KEY |
| category_id | NOT NULL, FOREIGN KEY |
| Column | Constraints |
|---|---|
| name | NOT NULL |
| Column | Constraints |
|---|---|
| buyer_id | NOT NULL, FOREIGN KEY |
| seller_id | (allow null during development), FOREIGN KEY |
| product_id | NOT NULL, FOREIGN KEY |
| rating | NOT NULL |
| review | NOT NULL |
| Column | Constraints |
|---|---|
| review_id | NOT NULL, FOREIGN KEY |
| url | NOT NULL |
| Column | Constraints |
|---|---|
| buyer_id | NOT NULL, FOREIGN KEY |
| Column | Constraints |
|---|---|
| order_id | NOT NULL |
| buyer_id | NOT NULL, FOREIGN KEY |
| seller_id | NOT NULL, FOREIGN KEY |
| product_id | NOT NULL, FOREIGN KEY |
| price | NOT NULL |
| quantity | NOT NULL |
| Column | Constraints |
|---|---|
| created_at | NOT NULL |