Support for multiple 1-M relationships in a single relationship class

468
0
03-02-2021 05:01 PM
Labels (2)
Trippetoe
Occasional Contributor III

Hello.

In AGOL, is there a way for a relationship class to have multiple 1-M relationships? Here is my use case...
I have a main table of CASES. Each case can have one-to-many CREWS assigned. Each crew can perform one-to-many TASKS. Each task could have various other attributes like time spent.

I am imagining a single relationship table that has (See image below)
-CaseId
-CrewId
-TaskId
-some other attributes

Is there a way to support a schema like that in AGOL? If that is not supported, any ideas how best to implement my scenario?

Simplified CaseCrewTasks ERDSimplified CaseCrewTasks ERD

 

Tags (3)
0 Replies