Re: How to manage products materials

GabrieleMax <gabriele1NOSPAM_at_hotmail.com> writes:
>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
      "PRODUCT"     "NAME"
      Int           String
      Primary Key 

Row   1             cookie box (CB)


      Table "MATERIAL"

      Column      Column      Column     Column      Column
      "MATERIAL"  "NAME"      "PICTURE"  "PRODUCT"   "BIN"
      Int         String      String     Int         Int
      Primary Key                        Foreign Key Foreign Key
                                         References  References 
                                         "PRODUCT"   "BIN"

Row   1           CB Outside  cb_out.jpg 1           1
Row   2           CB Inside   cb_in.jpg  1           2


      Table "BIN"

      Column        Column
      "BIN"         "NAME"
      Int           String
      Primary Key

Row   1             Plastic bin
Row   2             Organic bin