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