/ doc / toc / ARCCore / Enum / ARConcepts / ManyToManyRelations

ManyToManyRelations

Edit keys at this level only

Edit keys at all sub levels.
NOTE: Edits are always additive. Use 'Invalid' in order to delete keys.

__TOCDet/Assembly = ARCCore
__TOCDet/Description = -ARCQuery- supports many-to-many relations in a simple manner without introducing a third entity type (a third table).0x000D0x000A0x000D0x000AThis is done through having foreign keys with cardinality -IsMultiple- like -WholeCollection- and -IndividualItems-.0x000D0x000A0x000D0x000AExample 1), tagging PersonP.CarId with -IndividualItems-:0x000D0x000A  Person/42/CarId/19680x000D0x000A  Person/42/CarId/19810x000D0x000A  Person/43/CarId/19680x000D0x000A0x000D0x000AExample 2), tagging PersonP.CarId with -WholeCollection-:0x000D0x000A  Person/42/CarId = 19680x003B19810x000D0x000A  Person/43/CarId/19680x000D0x000A0x000D0x000AIn both examples person 42 owns two cars (1968 and 1981), but shares car 1968 with person 43.0x000D0x000A(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).0x000D0x000A
__TOCDet/DocFragType = EnumMember
__TOCDet/Name = ManyToManyRelations
__TOCDet/Namespace = ARCCore
__TOCDet/Type = ARConcepts
__TOCDet/Attribute/Description = -ARCQuery- supports many-to-many relations in a simple manner without introducing a third entity type (a third table).0x000D0x000A0x000D0x000AThis is done through having foreign keys with cardinality -IsMultiple- like -WholeCollection- and -IndividualItems-.0x000D0x000A0x000D0x000AExample 1), tagging PersonP.CarId with -IndividualItems-:0x000D0x000A  Person/42/CarId/19680x000D0x000A  Person/42/CarId/19810x000D0x000A  Person/43/CarId/19680x000D0x000A0x000D0x000AExample 2), tagging PersonP.CarId with -WholeCollection-:0x000D0x000A  Person/42/CarId = 19680x003B19810x000D0x000A  Person/43/CarId/19680x000D0x000A0x000D0x000AIn both examples person 42 owns two cars (1968 and 1981), but shares car 1968 with person 43.0x000D0x000A(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).0x000D0x000A
__TOCDet/Attribute/EnumMember = ManyToManyRelations
__TOCDet/Attribute/EnumType = ARConcepts

Edit single sub keys only: __TOCDet

Generated 2024-06-02 03:01:56.351 UTC