환율계산
테이블 (5)
Currencies
- id — int — 기본 키 — NOT NULL
- Key (codeId) — int — 외래 키 → Untitled.Key — NOT NULL
- country — varchar
- language — varchar
ExchangeRates
- id (Key) — 기본 키 — NOT NULL
- targetCurrency (currencyID) — varchar
- exchangeRate — DECIMAL(10, 4)
- updateAt (lastUpdated) — datetime
Untitled (Languages)
- Key (id) — int — 기본 키 — NOT NULL
- Field (code) — varchar
- Field (name) — varchar
Untitled (Localization)
- Key (id) — int — 기본 키 — NOT NULL
- Field (languageId) — int
- Field (key) — varchar
- Field (value) — text
Untitled (CurrencyCodes)
- Key (id) — int — 기본 키 — NOT NULL
- Field (code) — varchar(3)
- Field (description) — varchar(100)