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