가상화폐 트레이드 플랫폼

테이블 (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