가상화폐 트레이드 플랫폼
테이블 (12)
balances
- balance_id — BIGINT — 기본 키 — NOT NULL
- wallet_id — BIGINT — 외래 키 → wallets.wallet_id — NOT NULL
- currency_id — VARCHAR(20) — 외래 키 → currencies.currency_id — NOT NULL
- available_amount — DECIMAL(36, 18) — NOT NULL
- locked_amount — DECIMAL(36, 18) — NOT NULL
- updated_at — TIMESTAMP
- user_id (user_id2) — BIGINT — 외래 키 → wallets.user_id — NOT NULL
- Key — 외래 키 → wallets.Key — NOT NULL
- Key2 — 외래 키 → wallets.Key2 — NOT NULL
currencies
- currency_id — VARCHAR(20) — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- symbol — VARCHAR(10) — NOT NULL
- decimals — INT
- is_fiat — BOOLEAN
- can_deposit — BOOLEAN
- can_withdraw — BOOLEAN
- min_withdrawal — DECIMAL(36, 18)
deposit_addresses
- address_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- currency_id — VARCHAR(20) — 외래 키 — NOT NULL
- address — VARCHAR(255) — NOT NULL
- memo_tag — VARCHAR(100)
- created_at — TIMESTAMP
deposits
- deposit_id — BIGINT — 기본 키 — NOT NULL
- wallet_id — BIGINT — 외래 키 → wallets.wallet_id — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → wallets.user_id — NOT NULL
- Key — 외래 키 → wallets.Key — NOT NULL
- Key2 — 외래 키 → wallets.Key2 — NOT NULL
- address_id — BIGINT — 외래 키 → deposit_addresses.address_id — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- currency_id — VARCHAR(20) — NOT NULL
- tx_hash — VARCHAR(255) — NOT NULL
- amount — DECIMAL(36, 18) — NOT NULL
- confirmations — INT
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
ledgers
- ledger_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- currency_id — VARCHAR(20) — NOT NULL
- type — VARCHAR(30) — NOT NULL
- amount — DECIMAL(36, 18) — NOT NULL
- balance_after — DECIMAL(36, 18) — NOT NULL
- reference_id — VARCHAR(100)
- created_at — TIMESTAMP
orders
- order_id — BIGINT — 기본 키 — NOT NULL
- wallet_id — BIGINT — 외래 키 → wallets.wallet_id — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → wallets.user_id — NOT NULL
- Key — 외래 키 → wallets.Key — NOT NULL
- Key2 — 외래 키 → wallets.Key2 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- pair_id — BIGINT — 외래 키 → trading_pairs.pair_id — NOT NULL
- side — VARCHAR(10) — NOT NULL
- type — VARCHAR(10) — NOT NULL
- price — DECIMAL(36, 18)
- quantity — DECIMAL(36, 18) — NOT NULL
- executed_qty — DECIMAL(36, 18)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
trades
- trade_id — BIGINT — 기본 키 — NOT NULL
- pair_id — BIGINT — 외래 키 → trading_pairs.pair_id — NOT NULL
- maker_order_id — BIGINT — 외래 키 → orders.order_id — NOT NULL
- taker_order_id — BIGINT — 외래 키 → orders.order_id — NOT NULL
- price — DECIMAL(36, 18) — NOT NULL
- quantity — DECIMAL(36, 18) — NOT NULL
- maker_fee — DECIMAL(36, 18)
- taker_fee — DECIMAL(36, 18)
- executed_at — TIMESTAMP
- wallet_id — BIGINT — 외래 키 → orders.wallet_id — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → orders.user_id — NOT NULL
- Key — 외래 키 → orders.Key — NOT NULL
- Key2 — 외래 키 → orders.Key2 — NOT NULL
trading_pairs
- pair_id — BIGINT — 기본 키 — NOT NULL
- symbol — VARCHAR(30) — NOT NULL
- base_currency — VARCHAR(20) — 외래 키 — NOT NULL
- quote_currency — VARCHAR(20) — 외래 키 — NOT NULL
- min_order_size — DECIMAL(36, 18) — NOT NULL
- price_tick_size — DECIMAL(36, 18) — NOT NULL
- is_active — BOOLEAN
user_kyc
- kyc_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- real_name — VARCHAR(100) — NOT NULL
- dob — DATE — NOT NULL
- country_code — VARCHAR(5) — NOT NULL
- id_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- approved_at — TIMESTAMP
users
- user_id — BIGINT — 기본 키 — NOT NULL
- Key — 기본 키 — NOT NULL
- Key2 — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- two_factor_auth — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
wallets
- wallet_id — BIGINT — 기본 키 — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → users.user_id — NOT NULL
- Key — 외래 키 → users.Key — NOT NULL
- Key2 — 외래 키 → users.Key2 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- type — VARCHAR(20)
- created_at — TIMESTAMP
withdrawals
- withdrawal_id — BIGINT — 기본 키 — NOT NULL
- wallet_id — BIGINT — 외래 키 → wallets.wallet_id — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → wallets.user_id — NOT NULL
- Key — 외래 키 → wallets.Key — NOT NULL
- Key2 — 외래 키 → wallets.Key2 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- currency_id — VARCHAR(20) — NOT NULL
- to_address — VARCHAR(255) — NOT NULL
- amount — DECIMAL(36, 18) — NOT NULL
- fee — DECIMAL(36, 18) — NOT NULL
- tx_hash — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP