user_currency

Tables (3)

Currency (currency)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (exchange_rate) — DECIMAL(10, 2)
  • Field2 (currency_name) — CHAR(3)
  • Field3 (symbol) — CHAR(1)
  • Field4 (created_at) — DATETIME(6)
  • Field5 (modified_at) — DATETIME(6)

Exchange (exchange)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (user_id) — INT — Foreign key → User.Key — NOT NULL
  • Key (to_currency_id) — INT — Foreign key → Currency.Key — NOT NULL
  • Field (amount_in_krw) — DECIMAL(15, 2)
  • Field2 (amount_after_exchange) — DECIMAL(15, 2)
  • Field3 (status) — normal
  • Field4 (created_at) — DATETIME(6)
  • Field (modified_at) — DATETIME(6)

User (user)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (email) — VARCHAR(255)
  • Field (name) — VARCHAR(100)
  • Field2 (created_at) — DATETIME(6)
  • Field3 (modified_at) — DATETIME(6)