Entity1:
- Entity1_Id
Token
SubToken
Time
Entity2:
- Entity2_Id
Token
SubToken
Description
Token and sub-token essentially make for a single key into entity2 so there is an N-1 relationship between Entity1 and Entity2 for the combined Token and Subtoken property. I am not sure how to model this correctly as it appears to me that the relationships point to the primary key of the target entity.
Thanks!