PHP Dynamic Filtering and Option Table

[Atakan]

Hello I want product filter groups by category.

There will be different options.

Ex: http://prntscr.com/sr00ay

Product Table : http://prntscr.com/sr00rm

Option Groups Table : http://prntscr.com/sr013r

Options Table : http://prntscr.com/sr01fk

Product Option Table : http://prntscr.com/sr01r3

How can I build this structure? And how should it be sql for filtering? Is the structure correct? I'm waiting for your help.

Edited May 31, 2020 by Atakan

[Barand]

If you received a message from a complete stranger, would you click on the links?

[Atakan]

Just now, Barand said:

Tamamen bir yabancıdan bir mesaj aldıysanız, bağlantıları tıklar mıydınız?

I'm sorry I couldn't add it as a picture. Links are the page of the ScreenShot program.

[Barand]

It is possible (and preferred) for you to show table structures without pictures

DESCRIBE season;
+--------------+---------+------+-----+---------+-------+
| Field        | Type    | Null | Key | Default | Extra |
+--------------+---------+------+-----+---------+-------+
| season       | char(4) | NO   | PRI |         |       |
| season_start | date    | YES  | MUL |         |       |
| season_end   | date    | YES  | MUL |         |       |
+--------------+---------+------+-----+---------+-------+


SHOW CREATE TABLE season;

CREATE TABLE `season` (
  `season` char(4) NOT NULL,
  `season_start` date DEFAULT NULL,
  `season_end` date DEFAULT NULL,
  PRIMARY KEY (`season`),
  KEY `idx_season_start` (`season_start`,`season_end`),
  KEY `idx_season_end` (`season_end`)
)