currency

Tables (3)

currency (환전)

  • id (Key) — bigint auto increment — Primary key — NOT NULL
  • exchange_rate (환율) — float
  • currency_name (통화 이름) — varchar(20)
  • symbol (표시) — varchar(20)
  • created_at (생성일) — datetime
  • modified_at (수정일) — datetime

user (사용자)

  • id (Key) — bigint auto increment — Primary key — NOT NULL
  • email (이메일) — varchar(200)
  • name (이름) — varchar(50)
  • created_at (생성일) — datetime
  • modified_at (수정일) — datetime

user_currency (환전 중간테이블)

  • id (Key) — bigint auto increment — Primary key — NOT NULL
  • user_id (userKey) — bigint auto increment — Foreign key → user.id — NOT NULL
  • to_currency_id (currencyKey) — bigint auto increment — Foreign key → currency.id — NOT NULL
  • amount_in_krw (환전 전 금액) — int
  • amount_after_exchange (환전 후 금액) — float
  • status (상태) — varchar(20)
  • created_at (생성일) — datetime
  • modified_at (수정일) — datetime