javascript - Mysql : Linking products and its components, Online shopping JSP -
i creating database shopping cart (jsp). have products , each product have components, product made of. if out of particular component, products made of component has made out of stock. products shown user , components @ admin side. have idea? how can make tables 2 , link in mysql? or if javascript required it?
your question quite incomplete, can give hint on db design.
you can design tables this:
table product (product_id, other product fields... )
table component (component_id, other component fields... )
table product_component (product_id, component_id)
Comments
Post a Comment