Re: How to manage products materials
Date: Sun, 11 Jan 2015 11:38:40 -0800
Message-ID: <m3k5bal0ft8m48hi1gojs9t9ep8u86vtah_at_4ax.com>
On Sun, 11 Jan 2015 19:03:16 +0100, GabrieleMax
<gabriele1NOSPAM_at_hotmail.com> wrote in comp.databases.mysql:
>I need to make a mysql db to manage products and how to recycle them.
>
>For example I have a box of cookies and here you can have "paper",
>"plastic", "organic material", etc.
Ok, so you got a 1:n relationship.
>I can make a table named "products" and another one named "material" but
>how many rows I must add in products table?
As many as you got different products. And it is up to you do decide if a box if crackers is different from a box of cookies.
>For example I could make ten rows in "products" table like picture1, 2,
>etc. linked to "material" table where I could have just five or six fields!
If you got 10 different products, then yes.
>When user will see the picture of his box of cookies he'll see "put in
>plastic bin" this is what I'd like to do...
Where is the problem?
jue Received on Sun Jan 11 2015 - 20:38:40 CET