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