user currency

Tables (3)

currency (통화)

  • id (통화 고유 식별자) — BIGINT — Primary key — NOT NULL — Auto Increment
  • exchange_rate (환율) — DECIMAL — NOT NULL
  • currency_name (통화 이름) — String — NOT NULL
  • symbol (표시) — char — NOT NULL
  • created_at (생성일자) — TIMESTAMP — NOT NULL
  • modified_at (수정일자) — TIMESTAMP — NOT NULL

user (유저)

  • id (고객 고유식별자) — BIGINT — Primary key — NOT NULL — Auto Increment
  • email (고객 이메일) — String — NOT NULL
  • name (고객 이름) — String — NOT NULL
  • created_at (생성일자) — TIMESTAMP — NOT NULL
  • modified_at (수정일자) — TIMESTAMP — NOT NULL

user_currency (환전요청)

  • id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
  • user_id (고객 고유식별자) — BIGINT — Foreign key → user.id — NOT NULL
  • to_currency_id (통화 고유 식별자) — BIGINT — Foreign key → currency.id — NOT NULL
  • amountInKrw (환전 요청 금액 원화) — DECIMAL — NOT NULL
  • amountAfterExchange (환전 수행 후 금액) — DECIMAL — NOT NULL
  • status (환전 요청 상태) — String — NOT NULL
  • created_at (생성일자) — TIMESTAMP — NOT NULL
  • modified_at (수정일자) — TIMESTAMP — NOT NULL