I have four tables.

• option_groups
• options
• product_options
• product_images

Tables Structure

option_groups

id name

options

id name option_group_id

product_options

id product_id option_id option_group_id

product_images

id product_id images isfeatured

so what basically i want to store options according to option_group_id.

ex:

i'm creating a product T-Shirt in product_options table the records must like this.

id => 1 product_id => 1 option_id => // 1 for red and so on; 7 for small and so on; option_group_id => // 1 for color; 2 for size;

i'm fully confused how to it and how to store multiple options for single product.

every product have multiple options and images like

colors => ['red','green', 'blue']

size => ['small','Medium','Large']

images => ['img1.png','img2.png','img3.png','img4.png','img5.png']

// total 5 images limit

isfeatured => true //for img1.png

please help me how to do this...