DEV Community

[Comment from a deleted post]

Replies for: I highly recommend learning at least the basics of designing a database. Even as a developer it's very useful to know how to model data effectively...

Collapse
 
jsxsudan profile image
Sudan Ghimire •

Media

  • id
  • name
  • path
  • type

User

  • id
  • name
  • email
  • password
  • role -media_id

Category

  • id
  • name
  • category_id

Author

  • id
  • name
  • description

Book

  • id
  • title
  • price -on_sale -sale_price -published_at -edition -isbn
  • description
  • media_id

table: create_author_book_table

  • author_id
  • book_id

table: create_book_category_table

  • book_id
  • category_id

Review

  • id
  • book_id
  • user_id
  • rating (int: 1 to 5 stars)
  • message

Order

  • id
  • user_id
  • total_price
  • discount
  • delivery_address
  • billing_address
  • remarks
  • status (Pending, Confirmed, Delivered, Refund)

table: create_book_order_table

  • book_id
  • order_id
  • quantity
  • price