Erd for peer review

UpdatedApril 6, 2026

•1 min read

relation constriants

users.id - store.ownerId  // one to one
users.id < orders.costumerId // one to many
users.id < reviews.autherId
users.id < payments.paidBy


store.id < products.soldInStore
store.id  < orders.storeId

products.id < reviews.productId

orders.id < payments.orderId

explanation of some design decisions

an order can have multiple payments in case of failures.
any user is allowed to make payment for any order therefore it is linked to payment .

still have doubts regarding erd ? can clear via a dm on x . -> link

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

URL Parameters vs Query Strings in Express.js

Today we will discuss about a easy concept of http api . this concept may sound fancy but it is used in almost all websites.For starters they help to pass variable values to the urls . These variables

Jun 11, 20262 min read

URL Parameters vs Query Strings in Express.js

Async Code in Node.Js

if you not already know by now what async code means , then you should probably read previous blogs . for them who wants revise - async code runs parallelly with rest of the code ( its is just a short

May 28, 20264 min read

Async Code in Node.Js

Synchronous vs Asynchronous Js

what is synchronous code ? JavaScript is fundamentally a synchronous, single-threaded language that executes code line-by-line in a sequential order, where each instruction must complete before the

Mar 26, 20262 min read

Synchronous vs Asynchronous Js

Async/Await in JavaScript

to understand why async nature was introduced you must know about callbacks and promises . after reading these you will know about callback hell and how promises solve it . now there is problem with p

Mar 26, 20263 min read

Async/Await in JavaScript

S

ShayType

40 posts

You can call me Shay . I have started writing blogs on some tech related topics . If you ever read it then drop a review.

Erd for peer review