coing
Tables (9)
bookmark (Untitled)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- item_id (Key3) — Foreign key → item.id — NOT NULL
candle (캔들)
- id (Key) — Primary key — NOT NULL
- item_id (Key2) — Foreign key → item.id — NOT NULL
- code (거래쌍)
- start_price (시가)
- end_price (종가)
- high_price (고가)
- low_price (저가)
- acc_price (누적 거래 금액)
- acc_volume (누적 거래량)
- timestamp ((끝)시각) — Long
- type (타입) — String
- unit (단위)
item (종목)
- id (Key) — Primary key — NOT NULL
- code (거래쌍)
- warning (유의여부) — Boolean
- day_volume (24시간 거래량)
- cap (시가총액)
- dominance (도미넌스)
orderbook (호가)
- id (Key) — Primary key — NOT NULL
- item_id (Key2) — Foreign key → item.id — NOT NULL
- code (거래쌍)
- timestamp (시각) — Long
- ask_bid (구분)
- level (단위)
- total_ask_size (총매도량)
- total_bid_size (총매수량)
orderbook_units (호가유닛)
- id (Key) — Primary key — NOT NULL
- orderbook_id (Key2) — Foreign key → orderbook.id — NOT NULL
- ask_price (매도가)
- ask_size (매도량)
- bid_price (매수가)
- bid_size (매수량)
refresh_token (리프레시토큰)
- user_id (Key) — Foreign key → user.id — NOT NULL
- token (토큰 값)
- expiredAt (만료일)
role (권한)
- user_id (Key) — Foreign key → user.id — NOT NULL
- role (권한) — String
trade (체결)
- id (Key) — Primary key — NOT NULL
- item_id (Key2) — Foreign key → item.id — NOT NULL
- code (거래쌍)
- price (가격)
- volume (수량)
- change_price (전일대비)
- timestamp (시각) — Long
- ask_bid (구분) — String
user (유저)
- id (Key) — Primary key — NOT NULL
- name (이름)
- email (이메일)
- pwd (비밀번호)
- createdAt (생성일)