Need to Create an audit table for task assignments

Hi all,

I have got a requirement to create an audit table in the appian cloud DB.

I have an interface which i can select the select the tasks for users from a selectable Grid and assign those tasks for a particular user (one user can able multiple tasks).

So i haven to create a table and load those assignment data. Could you please guide me how can i achieve this.

example:

If a,b,c tasks are assigned to x

then our table should be

id   taskid    assignee   active

1      a            x               1

2      b            x               1

3      c            x                1

if x reassigned task b to y then our old transaction should go inactive.

Could you please suggest me the process model design with an dummy example

Thanks in advance