options in power store use 3 tables:
ps4_optionsgroups - this defines option groups like Size or color
ps4_options - this defiles the options like medium of red - the ps4_options.OptionGroupID relates the option to the ps4_optiongroups.OptionGroupID column
ps_productoptions - this is a linking table to relate products to the options. the ps_productoptions.ProductID column relates to the products.productID column. the ps_productoptions.OptionID relates to the ps4_options.OptionID column