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