user_currency

Tables (3)

Currency

  • currency_id (id) — bigint — Primary key — NOT NULL
  • currency_name (currencyName) — varchar — NOT NULL
  • exchange_rate (exchangeRate) — double — NOT NULL
  • symbol — varchar — NOT NULL
  • created_at (createdAt) — datetime — NOT NULL
  • modified_at (modifiedAt) — datetime — NOT NULL

User

  • user_id (id) — bigint — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • email — varchar — NOT NULL
  • create_at (createAt) — datetime — NOT NULL
  • modified_at (modifiedAt) — datetime — NOT NULL

User_Currency (UserCurrency)

  • user_currency_id (id) — bigint — Primary key — NOT NULL
  • amount_in_krw (amountInKrw) — bigint — NOT NULL
  • amount_after_exchange (amountAfterExchange) — double — NOT NULL
  • status — varchar — NOT NULL
  • created_at (createdAt) — datetime — NOT NULL
  • modified_at (modifiedAt) — datetime — NOT NULL
  • user_id (userId) — bigint — Foreign key → User.user_id — NOT NULL
  • to_currency_id (toCurrencyId) — bigint — Foreign key → Currency.currency_id — NOT NULL