The Compound Pattern
A Compound pattern helps us to define attributes that depend on a combination of two entities. This allows us to create additional flexibility when designing the application setup, creating values that connect through a many-to-many relationship.
The following diagram explains how to implement the Compound pattern:
To use the compound table in the application, both the fields are members of the table that uses the attributes. Typically, the compound key values are inherited from the fields in Master Data.