Topic: A simple idea: "Used cards"
Hi!
When in your profile build a deck you can see the number of every card required for the deck (Count in this deck), "Wishlist count" and your total of this card (Inventory count).
But when have, for example, 10 fetchlands in total and uses a playset in one deck and another playset (8 in total) for another deck you can't know if you have 2 remain cards "available" for a third deck.
This becomes a major problem when have a great collection (or when you prefer build decks without switch cards/sleeves because play with a important number of decks with friends and don't have the time for it).
My proposal can go from two points with same results:
A) Add one new column to the right of "Inventory Count" called "Inventory available" plus a option for every deck called "Deck in use" (so if you have 3 cards "A" in inventory list and one in a "deck in use" the "Inventory Available" is 3 - 1 = 2).
Or
B) The option of "Deck in use" and the same new column but called "Cards in use".
The result is the same but I think the B) option requires touch less the logic of SQL DDBB...