Root / Assembly / ARCCore / AREnumType / DocumentationOnlyEnum / ARConcepts / _Member / ManyToManyRelations
|Description||ARCQuery supports many-to-many relations in a simple manner without introducing a third entity type (a third table).|
This is done through having foreign keys with cardinality IsMultiple like WholeCollection and IndividualItems.
Example 1), tagging PersonP.CarId with IndividualItems:
Example 2), tagging PersonP.CarId with WholeCollection:
Person/42/CarId = 1968;1981
In both examples person 42 owns two cars (1968 and 1981), but shares car 1968 with person 43.
(you can of course also store many-to-many relations in the traditional RDBMS manner by using a third 'entity' type called PersonCarOwnership or similar).
Generated 2020-10-13 11:11:01.140 UTC