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