userCurrency

Tables (3)

Untitled (User)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (EMAIL) — VARCHAR — NOT NULL
  • Field (NAME) — VARCHAR — NOT NULL
  • Field (CREATED_AT) — TIMESTAMP — NOT NULL
  • Field (MODIFIED_AT) — TIMESTAMP — NOT NULL

Untitled (Currency)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (EXCHANGE_RATE) — FLOAT — NOT NULL
  • Field (CURRENCY_NAME) — VARCHAR — NOT NULL
  • Field (SYMBOL) — VARCHAR — NOT NULL
  • Field (CREATED_AT) — TIMESTAMP — NOT NULL
  • Field (MODIFIED_AT) — TIMESTAMP — NOT NULL

Untitled (Exchange)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (USER_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (CURRENCY_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (AMOUNT_IN_KRW) — INT — NOT NULL
  • Field (AMOUNT_AFTER_EXCHANGE) — FLOAT — NOT NULL
  • Field (STATUS) — VARCHAR — NOT NULL
  • Field (CREATED_AT) — TIMESTAMP — NOT NULL
  • Field (MODIFIED_AT) — TIMESTAMP — NOT NULL