currency

Tables (3)

currency

  • currency_id (통화 고유 식별자) — BIGINT — Primary key — NOT NULL — Auto increment
  • exchange_rate (환율) — DECIMAL — NOT NULL
  • currency_name (통화 이름) — VARCHAR — NOT NULL — ex.USD
  • symbol (표시) — VARCHAR — NOT NULL — ex. $
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • modifed_at (수정일) — TIMESTAMP — NOT NULL

exchange

  • id (환전 요청 고유 식별자) — BIGINT — Primary key — NOT NULL — Auto increment
  • user_id (유저 고유 식별자) — BIGINT — Foreign key → user.user_id — NOT NULL — Auto increment
  • currency_id (통화 고유 식별자) — BIGINT — Foreign key → currency.currency_id — NOT NULL — Auto increment
  • amount_in_krw (환전 전 금액 (원화 기준)) — DECIMAL — NOT NULL
  • amount_after_exchange (환전 후 금액) — DECIMAL — NOT NULL
  • status (상태) — VARCHAR — NOT NULL
  • created_at (생성일자) — TIMESTAMP — NOT NULL
  • modified_at (수정일자) — TIMESTAMP — NOT NULL

user

  • user_id (유저 고유 식별자) — BIGINT — Primary key — NOT NULL — Auto increment
  • name (사용자 이름) — VARCHAR — NOT NULL
  • email (사용자 이메일) — VARCHAR — NOT NULL — unique
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • modified_at (수정일) — TIMESTAMP — NOT NULL