I am going to create a person to person store with Laravel, a website where its users can share and sell their product or their mobile, TV, Computer, Shoes, Shirts, Books, Cars, Bags, Animal, etc.
I am going to create a table named products and other tables about products are, for example, bugs, Animals, Cars, Shirts, Shoes, Computers.
product_id | cat_id | title | cost | timestamp
id | product_fk | brand | model | type | Fuel | ...
id | product_fk | brand | type | CPU | GPU | hard_disk | ...
I will create other tables with this way.
I want to search database by titles and their type , I mean I just search the products table
I want to know
- Is there any other way (better and easier) to do this?
- What do you think about this structure?