Hey all, i am a starting webdevloper, and this is the first time i am going to work with codeigniter.
First of all sorry for my english, its not that good but i hope you can understand me
but now i need some advice(not codeigniter related) currently i am working on webshop/service system.
what i want to archieve, i have parent category, that contains sub category's.
every sub category could be products or different services.
for example
parent1
-parent1sub1
-parent1sub2
-parent1sub3
-parent1sub4
ect.
Where sub1 is a sub category that containts downloadable products
sub2 contains non downloadable products
sub3 contains a type of service
and sub4 also contains a type of service.
now i need some advice what you guys should do with storing this all in the database
shall i create a own table for service/digital produtcs/normal products?.
and if i create a own table for each service/product type how would i store the information for orders?
normally you would have a orderDetails table where you store all products for that order, how would i store products/service from multiple table?
just create a own colum for service/product in the table orderDetails?
I hope you have some advice for me
jaap