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)