Hi

Agentid - Integer

Chain - Varchar(2000)

Chain , it contains all sub-agents(Agentid) list seprated by '-'

For eg

agentid 100

chain would be 100-101-102

Chain gets longer as new subagents...