Hi Raghav thanks for the information, Option 2 does look the best
solution but accountId is coming as string.so can we use
marketId(integer) of lookup table along with accountId (string).Note:
market code would be 2 char max. (IN, US etc.) but accountId can be of
10 chars, so anyhow we have to use a string for composite so which would
be better? or is there any other solution to have this solution
implemented with integer composite key? Maybe we can use
autopk(recipientId) and marketId somehow?