userCurrency
Tables (3)
Untitled (User)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Field (EMAIL) — VARCHAR — NOT NULL
- Field (NAME) — VARCHAR — NOT NULL
- Field (CREATED_AT) — TIMESTAMP — NOT NULL
- Field (MODIFIED_AT) — TIMESTAMP — NOT NULL
Untitled (Currency)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Field (EXCHANGE_RATE) — FLOAT — NOT NULL
- Field (CURRENCY_NAME) — VARCHAR — NOT NULL
- Field (SYMBOL) — VARCHAR — NOT NULL
- Field (CREATED_AT) — TIMESTAMP — NOT NULL
- Field (MODIFIED_AT) — TIMESTAMP — NOT NULL
Untitled (Exchange)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Key (USER_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (CURRENCY_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (AMOUNT_IN_KRW) — INT — NOT NULL
- Field (AMOUNT_AFTER_EXCHANGE) — FLOAT — NOT NULL
- Field (STATUS) — VARCHAR — NOT NULL
- Field (CREATED_AT) — TIMESTAMP — NOT NULL
- Field (MODIFIED_AT) — TIMESTAMP — NOT NULL