-
Notifications
You must be signed in to change notification settings - Fork 0
Database: Currencies Table
Fifteen 15 Studios edited this page Jan 7, 2023
·
5 revisions
Holds a list of currencies that have been used over time.
-
ID- BigInt(20) (UNSIGNED) (NOT NULL) -
Name- VarChar(100) (DEFAULT) NULL) -
Abbreviation- VarChar(10) (DEFAULT NULL) -
Symbol- VarChar(10) (DEFAULT NULL) -
SymbolBefore- Boolean (DEFAULT TRUE)
-
ID- Unique identifier for this currency -
Name- Display name of the currency -
Abbreviation- Unique abbreviation for this currency -
Symbol- Symbol for this currency (e.g. $) -
SymbolBefore- True if symbol should be before value, otherwise false. (e.g. $ would be true, to display $5)
CountryCurrencies - Connects each country to the currencies it has used. Linked by Abbreviation
Coins - A coin is of a currency. Linked by Abbreviation
Bills - A bill is of a currency. Linked by Abbreviation