Project ERD

The following ERD was made using app.eraser.io diagram maker

Script

// title
title YourShop Data Model

// define tables
admin [icon: user, color: red] {
  id string pk
  email string
  password string
  createdAt timestamp
  updatedAt timestamp
}

user [icon: user, color: green] {
  id string pk
  name string
  email string unique
  password string
  verified boolean
  cartData object
  createdAt timestamp
  updatedAt timestamp
}

order [icon: shopping-cart, color: orange] {
  id string pk
  userId string fk
  items array
  amount number
  address object
  status string
  paymentMethod string
  payment boolean
  date number
}

otp [icon: key, color: purple] {
  id string pk
  email string
  otp string
  otpFor string
  verified boolean
  expiry date
}

product [icon: box, color: blue] {
  id string pk
  name string
  description string
  price number
  sellingPrice number
  image array
  category string
  subCategory string
  size array
  bestSeller boolean
  date number
}

review [icon: star, color: yellow] {
  id string pk
  productId string fk
  email string
  rating number
  comment string
  createdAt date
}

// define relationships
order.userId > user.id
review.productId > product.id

Diagram

View on Eraser