====== Technical Notes ======

===== Product Options: database structure =====

Question: How are product options organized in the database?

Answer: They are stored as follows:

  * Option groups are stored in the **OptionGroups** table (e.g. "Color", "Size", etc.).

  * Option attributes are stored in the **Options** table (e.g. "Blue", "Red", "Small", "Large", etc.).

The relationship between option groups and attributes is defined in the **optGrps** table.

The products table contains the ID of the option group(s) assigned to those products, which is used to determine whether the product is using product options or not. The **options_optionsGroups** table holds details about the relationship between products and options assigned to them.