4 ms·
I am firmly in the control your primary key, preferably uuid. Quick question for database gurus here. Is it ok to have a currency table using the currency code
by meekaaku 2y ago
I am firmly in the control your primary key, preferably uuid.
Quick question for database gurus here.
Is it ok to have a currency table using the currency code as primary key?
- brabel 2y agoI think long term, that is a bad idea. In Brazil in the 80's and early 90's, the currency changed name several times. It was called "cruzado", then "cruzeiro", then "cruzado novo" (yep, "new" <old-name>, very creative) and then I think it went back to just "cruzado" :D before finally becoming Real (which I believe was the name of the currency also during Monarchy, 100 years earlier).
- kassner 2y agoLikely no, there are currencies without an ISO 4217 code, i.e.: https://en.wikipedia.org/wiki/Faroese_kr%C3%B3na https://en.wikipedia.org/wiki/Faroese_kr%C3%B3na
- zarzavat 2y agoThis is interesting but it doesn’t really seem like a separate currency. It’s more like Scottish pound vs English pound, it’s the same currency but different banknotes for different regions in the same state.