26
Views
2
Comments
Parent and child entity
Application Type
Reactive

how to identify which entity is child and which is parent...as in Movie OSMDb reactive web application we created a relation between Movie and MovieGenre .....Every movie should have a genre and different movies can have same genre.

How we can know Movie is child or parent entity.

Rank: #68

Hi Eshita,


You seem to be describing a many-to-many relationship, where a movie can have multiple genres and the same genre can be present in multiple movies.

To support this scenario, there is no child nor parent relationship but a junction table that holds the relationship between genres and movies, something like the MovieGenre entity in my example below having a foreign key for the Movie and another foreign key for the Genre entities:


You can read more about creating many to many relationships in OutSystems here.


Hope it helps.


Cheers,
João