Duplicate Records in Couple of Tables

I found duplicate records getting inserted in tc_device_attribute and tc_user_device.

Any ways to restrict this. There can be other mapping tables which might have duplicate entries too.

How do you get duplicates there?

I checked the db and found there are duplicates. We use api to update userid and device mapping, same way we do for attribute and device. So while we do Insert with the same ids it accepts and inserts new.

Are you saying that you are inserting duplicates?

We are inserting from API as and when we update information to avoid any issue.