webAhead1 / e-store

0 stars 2 forks source link

Missing relationship table #14

Open Iz1cK opened 2 years ago

Iz1cK commented 2 years ago

https://github.com/webAhead1/e-store/blob/d63787901544b630f9dadcdf7309aa3ffab26818/public/database/init.sql#L12-L25

According to the code above, theres is no way to know which products are in which cart, since a cart can have many products, and products can be ordered in many carts, so you would need a relationship table which references both primary keys.