DB Schema & Backend Routes

First Two Features DB

users

• id integer [primary key]
• first_name varchar
• last_name varchar
• email varchar
• username varchar
• hashed_password varchar

products

• id integer [primary key]
• user_id integer
• name varchar
• image varchar
• price decimal
• description text
• created_at timestamp
• updated_at timestamp

user_id REF -> user.id

reviews

• id integer [primary key]
• user_id integer
• product_id integer
• body text
• rating integer
• created_at timestamp
• updated_at timestamp

user_id REF -> user.id product_id REF -> product.id

---

Expanded DB