coip
Tables (8)
candles
- id — BIGSERIAL
- coin_id — BIGINT — Foreign key → coins.id — NOT NULL
- interval — VARCHAR(10) — NOT NULL
- open_price — NUMERIC(20, 2) — NOT NULL
- high_price — NUMERIC(20, 2) — NOT NULL
- low_price — NUMERIC(20, 2) — NOT NULL
- close_price — NUMERIC(20, 2) — NOT NULL
- volume — NUMERIC(28, 8) — NOT NULL
- timestamp — TIMESTAMP — NOT NULL
coin_balances
- id — BIGSERIAL
- wallet_id — BIGINT — Foreign key → wallets.id — NOT NULL
- coin_id — BIGINT — Foreign key → coins.id — NOT NULL
- quantity — NUMERIC(28, 8) — NOT NULL
- quantity_locked — NUMERIC(28, 8) — NOT NULL
- avg_buy_price — NUMERIC(20, 2) — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
coins
- id — BIGSERIAL
- symbol — VARCHAR(10) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- name_kr — VARCHAR(50)
- logo — VARCHAR(20)
- market_cap — VARCHAR(50)
- is_active — BOOLEAN
- created_at — TIMESTAMP — NOT NULL
orders
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- coin_id — BIGINT — Foreign key → coins.id — NOT NULL
- side — VARCHAR(10) — NOT NULL
- order_type — VARCHAR(10) — NOT NULL
- price — NUMERIC(20, 2)
- quantity — NUMERIC(28, 8) — NOT NULL
- filled_quantity — NUMERIC(28, 8) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
tickers
- id — BIGSERIAL
- coin_id — BIGINT — Foreign key → coins.id — NOT NULL
- price — NUMERIC(20, 2) — NOT NULL
- change_rate — NUMERIC(8, 4) — NOT NULL
- volume_24h — NUMERIC(28, 8) — NOT NULL
- high_24h — NUMERIC(20, 2)
- low_24h — NUMERIC(20, 2)
- updated_at — TIMESTAMP — NOT NULL
trades
- id — BIGSERIAL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- coin_id — BIGINT — Foreign key → coins.id — NOT NULL
- side — VARCHAR(10) — NOT NULL
- price — NUMERIC(20, 2) — NOT NULL
- quantity — NUMERIC(28, 8) — NOT NULL
- total_amount — NUMERIC(20, 2) — NOT NULL
- fee — NUMERIC(20, 2) — NOT NULL
- executed_at — TIMESTAMP — NOT NULL
users
- id — BIGSERIAL
- username — VARCHAR(150) — NOT NULL
- email — VARCHAR(254) — NOT NULL
- password — VARCHAR(128) — NOT NULL
- nickname — VARCHAR(50)
- is_active — BOOLEAN
- date_joined — TIMESTAMP — NOT NULL
- last_login — TIMESTAMP
wallets
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- krw_balance — NUMERIC(20, 2) — NOT NULL
- krw_locked — NUMERIC(20, 2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL