rebalance

Tables (12)

account (계좌)

  • account_id (계좌id) — bigint — Primary key — NOT NULL
  • portfolio_id (포트폴리오 id) — varchar — Foreign key → portfolio.portfolio_id — NOT NULL
  • strategy_id (전략id) — varchar — Foreign key → portfolio.strategy_id — NOT NULL
  • uid (사용자id) — bigint — NOT NULL
  • account_provider (증권사) — varchar — NOT NULL — [KIS(한국투자증권)]
  • created_at (생성시간) — timestamp — NOT NULL

market_event (장운영정보)

  • market_event_id (장운영정보 id) — bigint — Primary key — NOT NULL
  • account_provider (증권사) — varchar — NOT NULL — [KIS(한국투자증권)]
  • market_type (시장종류) — varchar — NOT NULL
  • event_type (이벤트종류) — varchar — NOT NULL
  • event_details (이벤트상세) — varchar
  • created_at (생성시간) — timestamp — NOT NULL

order_book (주문계획서)

  • order_book_id (주문계획서 id) — bigint — Primary key — NOT NULL
  • rebalancing_history_id (리밸런싱이력id) — bigint — Foreign key → rebalancing_history.rebalancing_history_id — NOT NULL
  • strategy_id (전략id) — varchar — Foreign key → rebalancing_history.strategy_id — NOT NULL
  • portfolio_id (포트폴리오 id) — bigint — Foreign key → rebalancing_history.portfolio_id — NOT NULL
  • account_id (계좌id) — bigint — NOT NULL
  • ticker (ticker symbol) — varchar — NOT NULL
  • status (진행상태) — varchar — NOT NULL — 준비중, 주문, 부분체결, 완료
  • volume (주문수량) — decimal — NOT NULL
  • price (주문가격) — decimal — NOT NULL
  • created_at (생성시간) — timestamp — NOT NULL
  • updated_at (수정시간) — timestamp — NOT NULL

order_history (주문체결 내역)

  • order_history_id (주문체결 내역 id) — bigint — Primary key — NOT NULL
  • order_book_id (주문계획서 id) — bigint — Foreign key → order_book.order_book_id
  • rebalancing_history_id (리밸런싱이력id) — bigint — Foreign key → order_book.rebalancing_history_id
  • account_id (계좌_id) — bigint — NOT NULL
  • market_type (시장종류) — varchar — NOT NULL — 국내주식, 해외주식, 장내채권
  • order_number (주문번호) — varchar — NOT NULL
  • original_order_number (원주문번호) — varchar
  • side (주문종류) — varchar — NOT NULL — bid(매수), ask(매도)
  • order_type (주문유형) — varchar — NOT NULL — limit(지정가), market(시장가), best(최유리)
  • ticker (ticker symbol) — varchar — NOT NULL
  • request_volume (주문수량) — decimal — NOT NULL
  • request_price (주문가격) — decimal
  • executed_volume (체결수량) — decimal — NOT NULL
  • executed_price (체결가격) — decimal — NOT NULL
  • executed_funds (체결금액) — deciaml — NOT NULL
  • executed_at (체결시간) — decimal — NOT NULL
  • status (주문상태) — varchar — NOT NULL — 주문/취소/정정/체결
  • created_at (생성시간) — timestamp — NOT NULL
  • updated_at (수정시간) — timestamp — NOT NULL

order_history_log (주문체결 내역 이력)

  • order_history_log (주문체결내역id) — bigint — Primary key — NOT NULL

portfoio_weight (포트폴리오 비중)

  • portfolio_weight_id (포트폴리오 비중 id) — bigint — Primary key — NOT NULL
  • portfolio_id (포트폴리오 id) — varchar — Foreign key → portfolio.portfolio_id — NOT NULL
  • strategy_id (전략id) — varchar — Foreign key → portfolio.strategy_id — NOT NULL
  • portfolio_version (포트폴리오 버전) — varchar — NOT NULL
  • ticker (ticker symbol) — varchar — NOT NULL
  • market_type (시장 종류) — varchar — NOT NULL — 국내주식, 해외주식, 장내채권
  • currency (통화) — varchar — NOT NULL
  • weight (비중) — decimal — NOT NULL
  • created_at (생성시간) — timestamp — NOT NULL
  • updated_at (수정시간) — timestamp — NOT NULL

portfolio (포트폴리오)

  • portfolio_id (포트폴리오 id) — varchar — Primary key — NOT NULL
  • strategy_id (전략id) — varchar — Foreign key → strategy.strategy_id — NOT NULL
  • portfolio_version (포트폴리오 버전) — varchar — NOT NULL
  • portfolio_name (포트폴리오명) — varchar — NOT NULL
  • created_at (생성일시) — timestamp — NOT NULL
  • upated_at (수정일시) — timestamp — NOT NULL

portfolio_weight_log (포트폴리오 비중 이력)

  • portfolio_weight_log_id (포트폴리오 비중 log id) — bigint — Primary key — NOT NULL
  • portfolio_weight_id (포트폴리오 비중 id) — bigint — Foreign key → portfoio_weight.portfolio_weight_id — NOT NULL
  • portfolio_id (포트폴리오 id) — bigint — Foreign key → portfoio_weight.portfolio_id — NOT NULL
  • strategy_id (전략id) — varchar — Foreign key → portfoio_weight.strategy_id — NOT NULL
  • portfolio_version (포트폴리오 버전) — varchar — NOT NULL
  • ticker (ticker symbol) — varchar — NOT NULL
  • market_type (시장종류) — varchar — NOT NULL
  • currency (통화) — varchar — NOT NULL
  • weight (비중) — decimal — NOT NULL
  • created_at (생성시간) — timestamp — NOT NULL

rebalancer_event (리밸런서 이벤트)

  • rebalancer_event_id (리밸런서 이벤트 id) — bigint — Primary key — NOT NULL
  • event_type (이벤트 종류) — varchar — NOT NULL — ORDER_QUEUE_ERROR_CLOSE
  • event_details (이벤트 상세) — varchar
  • created_at (생성시간) — timestamp — NOT NULL

rebalancing_history (리밸런싱 내역)

  • rebalancing_history_id (리밸런싱이력id) — bigint — Primary key — NOT NULL
  • strategy_id (전략id) — varchar — Foreign key → portfolio.strategy_id — NOT NULL
  • portfolio_id (포트폴리오 id) — bigint — Foreign key → portfolio.portfolio_id — NOT NULL
  • portfolio_version (포트폴리오 버전) — varchar — NOT NULL
  • account_id (계좌id) — bigint — NOT NULL
  • uid (사용자id) — bigint — NOT NULL
  • status (리밸런싱 상태) — varchar — NOT NULL — [IN_PROGRESS,CANCELED,COMPLETED,FAILED]
  • rebalancing_type (리밸런싱 유형) — varchar — NOT NULL
  • rebalancing_trigger (리밸런싱 트리거) — varchar — NOT NULL
  • reason (취소, 실패 사유) — varchar
  • created_at (생성시간) — timestamp — NOT NULL
  • updated_at (수정시간) — timestamp — NOT NULL

strategy (전략)

  • strategy_id (전략id) — varchar — Primary key — NOT NULL
  • strategy_name (전략명) — varchar — NOT NULL
  • created_at (생성시간) — timestamp — NOT NULL
  • updated_at (수정시간) — timestamp — NOT NULL

strategy_log (전략 이력)

  • stragey_log_id (전략 log id) — bigint — Primary key — NOT NULL
  • strategy_id (전략id) — varchar — Foreign key → strategy.strategy_id — NOT NULL
  • strategy_name (전략명) — varchar — NOT NULL
  • created_at (생성시간) — timestamp — NOT NULL