Rethink index choices

[bhollis]

I think I can probably drop a bunch of the primary key constraints in favor of fewer, more useful unique indexes.

[bhollis]

Specifically the item_annotations primary key index is basically the same size as the table itself