Database Schema - Heba11-22/kiddos GitHub Wiki

Database Schema Diagram

Users

Column name Data type Details
id Integer not null, primary key
username String not null
email String not null, unique
avatar_url String
hashed_password String not null
created_at Datetime not null
updated_at Datetime not null

MainCategories

Column name Data type Details
id Integer not null, primary key
main-categoryName String not null
created_at Datetime not null
updated_at Datetime not null

Categories

Column name Data type Details
id Integer not null, primary key
categoryName String not null
mainCategoryId Integer not null
created_at Datetime not null
updated_at Datetime not null

Ref: MainCategories.id > Categories.mainCategoryId

Items

Column name Data type Details
id Integer not null, primary key
itemName String not null
sizes Integer not null
photoURL String not null
colors String not null
material String not null
numberOfItems Integer not null
detail Text not null
categoryId Integer not null
created_at Datetime not null
updated_at Datetime not null

Ref: categories.id > items.categoryId

ItemReviews

Column name Data type Details
id Integer not null, primary key
rating Integer
review Text not null
userId Integer
itemId Integer not null
created_at Datetime not null
updated_at Datetime not null

Ref: users.id > ItemReviews.userId

Ref: items.id > ItemReviews.itemId

Carts

Column name Data type Details
id Integer not null, primary key
userId Integer
itemId Integer not null
created_at Datetime not null
updated_at Datetime not null

Ref: users.id > carts.userId

Ref: items.id > carts.itemId

SavedItems

Column name Data type Details
id Integer not null, primary key
userId Integer not null
itemId Integer not null
created_at Datetime not null
updated_at Datetime not null

Ref: users.id > usersItems.userId

Ref: items.id > usersItems.itemId