erd
Tables (9)
assets
- id — BIGINT
- user_id — BIGINT — NOT NULL
- coin_symbol — VARCHAR(10) — NOT NULL
- amount — DECIMAL(20,8)
- updated_at — TIMESTAMP
klines
- id — BIGINT
- market_id — INT — NOT NULL
- interval — ENUM('1m', '5m', '15m', '1h', '1d') — NOT NULL
- open_time — DATETIME — NOT NULL
- open — DECIMAL(30, 18) — NOT NULL
- high — DECIMAL(30, 18) — NOT NULL
- low — DECIMAL(30, 18) — NOT NULL
- close — DECIMAL(30, 18) — NOT NULL
- volume — DECIMAL(30, 18) — NOT NULL
- close_time — DATETIME — NOT NULL
markets
- id — INT
- base_asset — VARCHAR(10) — NOT NULL
- quote_asset — VARCHAR(10) — NOT NULL
- symbol — VARCHAR(20) — NOT NULL
- price_precision — INT — NOT NULL
- quantity_precision — INT — NOT NULL
- min_order_amount — DECIMAL(30, 18) — NOT NULL
- status — ENUM('active', 'inactive') — NOT NULL
- created_at — DATETIME — NOT NULL
order_books
- id — BIGINT
- market_id — INT — NOT NULL
- side — ENUM('buy', 'sell') — NOT NULL
- price — DECIMAL(30, 18) — NOT NULL
- quantity — DECIMAL(30, 18) — NOT NULL
- created_at — DATETIME — NOT NULL
orders
- id — BIGINT
- user_id — BIGINT — NOT NULL
- market_id — INT — NOT NULL
- side — ENUM('buy', 'sell') — NOT NULL
- type — ENUM('limit', 'market', 'stop') — NOT NULL
- price — DECIMAL(30, 18)
- quantity — DECIMAL(30, 18) — NOT NULL
- filled_quantity — DECIMAL(30, 18) — NOT NULL
- status — ENUM('open', 'partial', 'filled', 'canceled') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- CHECK — ((type = 'limit' AND price IS NOT NULL) — NOT NULL
orders2
- id — BIGINT
- user_id — BIGINT — NOT NULL
- coin_symbol — VARCHAR(10) — NOT NULL
- order_type — ENUM('buy', 'sell') — NOT NULL
- quantity — DECIMAL(20,8) — NOT NULL
- price — DECIMAL(20,8) — NOT NULL
- status — ENUM('pending', 'filled', 'cancelled')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
trades
- id — BIGINT
- market_id — INT — NOT NULL
- buy_order_id — BIGINT — NOT NULL
- sell_order_id — BIGINT — NOT NULL
- price — DECIMAL(30, 18) — NOT NULL
- quantity — DECIMAL(30, 18) — NOT NULL
- trade_time — DATETIME — NOT NULL
user_balances
- id — BIGINT
- user_id — BIGINT — NOT NULL
- asset — VARCHAR(10) — NOT NULL
- available — DECIMAL(30, 18) — NOT NULL
- locked — DECIMAL(30, 18) — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- is_active — BOOLEAN — NOT NULL