Laravel的正确关系

Question

hello, sorry for my english. I will try explain my problem.

For example, we have model Product.

Each product has some options:

product_1 : option_1 = 50, option_2 = 14, option_3 = 23

Whats is the right way?

First - create database, like

id | title | option_1 | option_2 | option_3

Second - create models and tables, like

ProductModel hasMany optionModel 
OptionModel belongsToMany ProductModel

tables in databases: Product, Option, Product_Option_Relationships

Third - create some collection in function and table Product_Option_Relationships like

$options = collect([
  ['id' => '1', 'name' =>'option1'],
  ['id' => '2', 'name' =>'option2'],  
]);

Table: id | product_id | option_id

Or maybe exist normal way, because first - its too big table, when you have 20 options, second - create new model only for information function, i dont now, its normal? Third - too difficult in view show options name.

Thank you, i hope you understand me.

Answer 1

Use the second way. You won't have repeated options. For example:

products

id | name
---|------
1  | Car
2  | Bike

options

id   |  name
-----|------------
1    |  Transport

option_product

option_id   |  product_id
------------|-------------
1           |  1
1           |  2

Using the other ways, you would have the option Transport twice.