dinance
테이블 (10)
refresh_token
- token — CHAR(64) — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → 유저.user_id — NOT NULL
- expired_date — DATETIME
- created_at — TIMESTAMP
거래 (trades)
- trade_id — BIGINT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → 유저.user_id — NOT NULL
- market_id — BIGINT — 외래 키 → 쌍.market_id
- price — DECIMAL(30, 10) — NOT NULL
- quantity — DECIMAL(30, 10) — NOT NULL
- type — ENUM('BUY', 'SELL') — NOT NULL
- buy_order_id — BIGINT
- sell_order_id — BIGINT
- traded_time — TIMESTAMP — NOT NULL
로그인 히스토리 (login_history)
- login_id — INT — 기본 키
- user_id — INT — 외래 키 → 유저.user_id — NOT NULL
- ip_address — VARCHAR(45)
- user_agent — VARCHAR(255)
- success — BOOLEAN — NOT NULL
- reason — VARCHAR(255)
- login_time — TIMESTAMP
마켓 자산 (BTC/USDT (마켓)) (assets)
- market_id — BIGINT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → 유저.user_id — NOT NULL
- amount — DECIMAL(30, 10) — NOT NULL
- updated_at — TIMESTAMP
쌍 (markets)
- market_id — BIGINT — 기본 키 — NOT NULL
- base_asset — VARCHAR(20) — NOT NULL
- quote_asset — VARCHAR(20) — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE')
- created_at — TIMESTAMP
유저 (user)
- user_id — INT — 기본 키 — NOT NULL
- email — VARCHAR(50) — NOT NULL
- name — VARCHAR(30)
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
유저 지갑 (BTC, USDT, ETH (단일) (user_wallets)
- wallet_id — BIGINT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → 유저.user_id — NOT NULL
- asset — VARCHAR(20) — NOT NULL
- balance — DECIMAL(30, 10) — NOT NULL
- updated_at — TIMESTAMP
주문 (orders)
- order_id — BIGINT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → 유저.user_id — NOT NULL
- market_id — BIGINT — 외래 키 → 쌍.market_id
- type — ENUM('BUY', 'SELL') — NOT NULL
- price — DECIMAL(30, 10)
- quantity — DECIMAL(30, 10) — NOT NULL
- status — ENUM('NEW', 'FILLED', 'CANCELLED') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
캔들차트 (ohlcv)
- candle_id — BIGINT — 기본 키
- market_id — BIGINT — 외래 키 → 쌍.market_id
- interval — ENUM('1m', '5m', '15m', '1h', '1d') — NOT NULL
- open_price — DECIMAL(30, 10)
- high_price — DECIMAL(30, 10)
- low_price — DECIMAL(30, 10)
- close_price — DECIMAL(30, 10)
- total_trade_volume — DECIMAL(30, 10)
- total_trade_price — BIGINT
- created_at — TIMESTAMP
- open_time — TIMESTAMP
- close_time — TIMESTAMP
코인목록 (coin)
- coin_id — INT — 기본 키 — NOT NULL
- market_id (market) — VARCHAR(10) — NOT NULL
- price — DECIMAL(30,10)
- amount — DECIMAL(30,10)
- time — TIMESTAMP