UserImage.jpg
Alberto Santos
18Views
5Comments
Solved
Many-to-many relationship
Question
Database
Traditional Web
Application Type
Traditional Web
Service Studio Version
11.54.29 (Build 62891)
Platform Version
11.23.1 (Build 40847)

I'm new to OutSystems,

I would like to know if in all N:N relationships I need to have an id in the associative table or can I simply create a new table passing only the FK of my tables.

0
0
20 Oct
Solution

Hi Alberto

You can't create a Junction Entity without a Primary key because it wouldn't serve the purpose of a Many-to-Many relationship.

Thanks

See solution in context
2
0
20 Oct

Thanks for the reply Anshul, I've cleared up my doubts 

0
0
20 Oct
Solution

Replying to Alberto Santos' comment on 20 Oct 2023 12:39:21

If you have Associative Table without PK it means you already build a one to one relationship. 

See solution in context
0
0
20 Oct


Hi Alberto Santos ,

This is the example of N:N relationship .

To learn more about many to many relationship you must read this blow document .

https://success.outsystems.com/documentation/11/developing_an_application/use_data/data_modeling/entity_relationships/create_a_many_to_many_relationship/


let me know if you have any other question 

Thanks

Arif 

1
0
20 Oct

Thanks for the reply Arif ,


My main doubt is if I can have an associative table without a PK.

0
0
20 Oct
Solution

Replying to Alberto Santos' comment on 20 Oct 2023 12:39:21

If you have Associative Table without PK it means you already build a one to one relationship. 

0
0
20 Oct
Solution

Hi Alberto

You can't create a Junction Entity without a Primary key because it wouldn't serve the purpose of a Many-to-Many relationship.

Thanks

2
0
20 Oct

Thanks for the reply Anshul, I've cleared up my doubts 

0
0
20 Oct
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.