DB Link 2016 multiple entries for same element

[Anonymous]

I have setup a connection between Revit 2016 and SQL using DB link 2016 Add-in. I have noticed that the material quantities table have multiple primary keys (3 to be exact) which allows to have different materials for the same elements when the model is exported. As per my understanding each export should delete the previous record for the same material. On the other hand I can understand that an element  may be composite in nature so multiple entries are needed. 

But for the quantities if I add up the volume than this is greater than the total volume of elements. Has somebody experienced this issue? Is there a way to work around it?

[FAIR59]

I suspect the 3 material quantities, represent the element in the different Detail Levels [ Coarse, Medium, Fine].

[Anonymous]

Dear Fair59,

It does not seem so, I am talking about composite primary keys for a table in sql. What you are referring to is the filter for viewing. 

I have two parts of the problem:

1. I want to be sure if DB Link actually uses the concept of composite primary keys in the table of MaterialQuantitites.

2. How to tackle multiple entries for the same element after multiple exports?

A similar problem is also faced by another user but with Access and he agrees to me on this. Link for that post http://forums.autodesk.com/t5/revit-architecture-forum/db-link-quot-leftovers-quot/m-p/6873251#M1401...