Hello. I am trying to design the following database, but i never had a table that referred to itself.
I have a table with several articles. But some articles of this table are composed by other articles of this same table. Let me give you an example.
Article
CAR
LIGHTS
DOOR
So, i want to make a relationship where CAR has LIGHTS and DOOR, but these are elements from the same table. ¿How can i do this?