k4kabirmalik
/ CurrencyMeta.sql
Last active
July 26, 2025 17:31
List of all currency with country, currency name, ISO codes, symbols, symbol position, layout direction in SQL format
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE CurrencyMeta ( | |
| Country TEXT NOT NULL, | |
| CurrencyName TEXT NOT NULL, | |
| ISOCodeAlpha2 CHAR(2) NOT NULL, | |
| ISOCodeAlpha3 CHAR(3) NOT NULL, | |
| Symbol TEXT, | |
| SymbolPosition TEXT CHECK (SymbolPosition IN ('prefix', 'postfix')) DEFAULT 'prefix', | |
| LayoutDirection TEXT CHECK (LayoutDirection IN ('LTR', 'RTL')) DEFAULT 'LTR', | |
| -- Unique constraint to avoid duplicates by country and currency code |