Re: How to manage products materials

Thanks for your reply! :)

> Table "PRODUCT"
>
> Column Column Column Column
> "PRODUCT" "NAME" "IMAGE PATH" "BIN"
> Int String String Int
> Primary Key Foreign Key
> references "BIN"
>
> Row 1 cookie box C:\images\cookie_box.jpg 1

But... a cookie box (like other products) could be more than one material for example plastic (outside) organic material (biscuits out of date), etc. for this reason it should be "IMAGE1" (box), "IMAGE2" (biscuits) etc. and different bins "BIN-1" "BIN-2" etc.

Table "PRODUCT"

Column     Column   Column     Column    Column         Column "PRODUCT" 
  "NAME"   "IMAGE1"   "IMAGE2"  "BIN-1"        "BIN-2"
Int        String   String     String    Int            Int
Primary Key                              Foreign Key     Foreign Key
                                       references "BIN" references "BIN"



>        Table "BIN"


>

>        Column        Column

>        "BIN"         "NAME"

>        Int           String

>        Primary Key

>

> Row   1             Plastic bin

And here I should have for one product different bins if you have packaging, organic material, etc.

GabrieleMax Received on Sun Jan 11 2015 - 19:36:41 CET