the product options table is a linking table used to create the options that are available for each product.
take this for an example:
Products:
+-----------+----------------+
| ProductID | ProductName |.....
+-----------+----------------+
| 1 | Cotton T-Shirt |
+-----------+----------------+
| 2 | Los Angeles |
+-----------+----------------+
Options:
+----------|------------+
| OptionID | OptionName |.....
+----------|------------+
| 1 | Red |
+----------|------------+
| 2 | Yellow |
+----------|------------+
| 3 | Blue |
+----------|------------+
| 4 | Green |
+----------|------------+
| 5 | Black |
+----------|------------+
ProductOptions:
+-----------------+-----------|----------+
| ProductOptionID | ProductID | OptionID |.....
+-----------------+-----------|----------+
| 1 | 1 | 2 |
+-----------------+-----------|----------+
| 2 | 1 | 4 |
+-----------------+-----------|----------+
| 3 | 2 | 1 |
+-----------------+-----------|----------+
| 4 | 2 | 3 |
+-----------------+-----------|----------+
| 5 | 2 | 4 |
+-----------------+-----------|----------+
| 6 | 2 | 5 |
+-----------------+-----------|----------+
this defines 2 products and 5 color options.
in the product options table, it assigns the color options: Yellow, and Green to product1. and assigns the color options: Red, Blue, green, Black to product ID 2.
in the product options table, you need to create a record for each product option combination
