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