환율계산

테이블 (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)