Hello,

I have 3 tables

tableA has info regarding name and clientid
tableB has info regarding the orderids of the clients
tableC has info regarding the tradeids of the clients
And all the tables have session column

primary key for tableA is (session,client id, name)
tableB has primary key(session, orderid) and index(session, clientid)
tableC has index(session, orderid)...