If you were designing a database for Magic: The Gathering cards, what would be the most basic identifying fields for a card to get a primary key. The Gatherer site uses the multiverse id, but say you couldn't use it and had to come up with something else.
I believe it would be the card name and set. Every card name is unique. Even the cards from Unstable like "Knight Of The Kitchen Sink" that have multiple versions of the card with the same name have versions a-f on the Gatherer site, and the set + card name would let you get any other version of the card (different rarities, wordings, etc.).
I think the only other possible unique identifier might be the "version" - stuff like extended art, full art, showcase art, etc., which could be the same per card name and per set, especially with recent sets. Stuff like Cloudpiercer has the same name & set (Ikoria), but comes in standard art and showcase art.
Is there anything I'm overlooking?
BTW, I wasn't sure whether to ask this question here or in the Database Administrators Stackexchange, but I thought more MTG players would know DB stuff than DB Admins would know MTG cards. If I need to ask it there please let me know.