What does the API currently do if you try to add a tag/verse relationship that already exists?
Does is just create duplicate data or does it do something else?
My suggestion is that it would effectively 'up-vote' that tag and give it greater visibility in query results but I don't know what the best way to manage that in the database would be.
The way I've looked at doing it in terms of database structure is to have one table for the actual tag terms and a separate linked one for 'tag events' - when a tag is attached to a verse, up-voted (even down-voted?).
What does the API currently do if you try to add a tag/verse relationship that already exists? Does is just create duplicate data or does it do something else?
My suggestion is that it would effectively 'up-vote' that tag and give it greater visibility in query results but I don't know what the best way to manage that in the database would be.
The way I've looked at doing it in terms of database structure is to have one table for the actual tag terms and a separate linked one for 'tag events' - when a tag is attached to a verse, up-voted (even down-voted?).