No relationship between Product and department

[ademulegun]

From your database schema, i cant find a relationship between product and department, which makes this enpoint confusing (/products/inDepartment/{department_id})

[edertaveiraturing]

So, you can reach the products from the department through categories, since one department can have many categories and one category can have many products, you can get products from the department.

[sabyrzhan]

there is a catalog_get_products_on_department procedure that you can use. However the procedure has error: does not have p.display in select statement in order to order the result. So this sql scripts need a fix.

[abeltsew]

I am having the same error on SP call to catalog_get_products_on_department,
has anybody found a fix?

[sabyrzhan]

Well you have 2 ways:

1. fix the procedure locally and go with it.
2. write your own procedure or SQL script.
   Think better way is the first.

[innoflash]

For a normal shopping cart you add products to cart as you please,

i suppose thats why we have the **/shoppingcart/add** route and 
the **product_id** column in the cart

next you will see a route that queries products in a cart so i think these 2 models are related directly and not through another

[sbansa1]

Exactly what I am thinking. Well there should atleast be a foreign key. Since one department can have many products.

[Basttyy]

Exactly what I am thinking. Well there should atleast be a foreign key. Since one department can have many products.

there is no need for that. product can get to departments through categories