Objects vs Table Reference, which one should I use and which direction?

Answered

Hiya! Noob here.

I watched some of your YT videos, which were helpful, I had my structure all setup and I understood it, It had Table References, life was great. ๐Ÿ˜Ž

Then Objects were thrown in and it all got confusing again ๐Ÿ˜ฉ. In the application I have in my head I had a products table and a products_type table. I had a table reference between the two but now I'm confused. Let's make the example cars

In products I've got
Car #1
Car #2
Car #3

In products_type I've got
SUV
Hatchback
Coupe

Is it better to have a table reference in products for products_type_id ?

Or is it better to have an object in products_type that lists the items in products ?

Cheers

2 replies