I'm building an eCommerce system with the following design
Subercategories -> has many Categories -> has many Subcategories -> has many Products (product has many subcategories as well).
and has also offers system with the following design
Offer -> morphedByMany Subercategories, Categories, Subcategories, Products through offerable table.
for each product on the website, I need to get the best offer for this product.
what's the best design for the latest idea ??
Here's another thread with some examples from @bobbybouwmann https://laracasts.com/discuss/channels/laravel/database-design-for-ecommerce-website-example which may give you some direction. The examples are of Laravel eCommerce packages and how they structure their system.
Ultimately it's what works best for you in your use-case.
Please or to participate in this conversation.