BookStore ERD

// Use DBML to define your database structure
// Docs: https://dbml.dbdiagram.io/docs

Table users {
  id Integer [primary key]
  email varchar
  password varchar
}

Table books {
  id integer [primary key]
  title varchar
  categoty varchar
  format varchar
  isbn varchar
  summary text
  description text
  author varchar
  pages integer
  index text
  price integer
  likes integer
  pubDate timestamp
}

Table likes {
  user_id integer
  liked_book_id integer
}

Ref: likes.user_id < users.id
Ref: likes.liked_book_id < books.id

Table cartItems {
  cartId integer [primary key]
  bookId integer  
  count integer
}

Ref: cartItems.bookId < books.id

Table delivery {
  deliveryId integer [primary key]
  address varchar
  receiver varchar
  contact varchar
}

Ref: delivery.receiver < users.id

Table orders {
  orderId integer [primary key]
  deliveryId integer
  total_price integer
  created_at timestamp
  bookTitle varchar
  totalCount integer
}

Ref: orders.deliveryId < delivery.deliveryId
Ref: orders.bookTitle < books.title

Table orderedBook {
  orderId integer
  bookId integer
  count integer
}

Ref: orderedBook.orderId < orders.orderId
Ref: orderedBook.bookId < books.id