Database Schema

Users

column name	data type	details
id	integer	not null, primary key
username	string	not null, unique
email	string	not null, unique
hashed_password	string	not null

Products

column name	data type	details
id	integer	not null, primary key
title	string	not null
price	float	not null
details	text	not null
description	text	not null
quantity	integer	not null
user_id	integer	not null, foreign key
product_type_id	integer	not null, foreign key
pet_type_id	integer	not null, foreign key

• user_id references Users table
• product_type_id references ProductTypes table
• pet_type_id references PetTypes table

ProductTypes

column name	data type	details
id	integer	not null, primary key
title	string	not null, unique
url	string

Images

column name	data type	details
id	integer	not null, primary key
product_id	integer	not null, foreign key
url	string	not null

• product_id references Products table

PetTypes

column name	data type	details
id	integer	not null, primary key
title	string	not null, unique
icon	string

Reviews

column name	data type	details
id	integer	not null, primary key
content	text
rating	integer	not null
user_id	integer	not null, foreign key
product_id	integer	not null, foreign key
created_at	date	not null
updated_at	date	not null
url	string

• product_id references Products table
• user_id references Users table

Purchases

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, foreign key
product_id	integer	not null, foreign key
purchase_date	date	not null
quantity	integer	not null

• product_id references Products table
• user_id references Users table