chickenStock2

Tables (7)

fee_tax_summary

  • fee_tax_id — BIGINT — 수수료세금ID
  • total_buy_fee — BIGINT — NOT NULL — 총매수수수료
  • total_sell_fee — BIGINT — NOT NULL — 총매도수수료
  • total_sell_tax — BIGINT — NOT NULL — 총매도세금
  • total_amount — BIGINT — NOT NULL — 총합계
  • version — BIGINT — 낙관적락버전
  • created_at — DATETIME — NOT NULL — 생성일시
  • last_updated_at — DATETIME — 마지막수정시간

holding_position

  • stock_holding_id — BIGINT — 보유포지션ID
  • member_id — BIGINT — NOT NULL — 회원ID
  • stock_data_id — BIGINT — NOT NULL — 종목ID
  • quantity — INT — NOT NULL — 보유수량
  • average_price — BIGINT — NOT NULL — 평균매입가
  • current_profit — BIGINT — NOT NULL — 현재손익
  • return_rate — DOUBLE — NOT NULL — 수익률
  • active — BOOLEAN — NOT NULL — 활성상태
  • INDEX — idx_holding_member_id
  • INDEX — idx_holding_active
  • INDEX — idx_holding_return_rate

notifications

  • id — BIGINT — 알림ID
  • member_id — BIGINT — NOT NULL — 회원ID(FK아님)
  • type — VARCHAR(20) — NOT NULL — 알림유형(TRADE/COMMENT/LIKE/SYSTEM)
  • title — VARCHAR(100) — NOT NULL — 알림제목
  • message — VARCHAR(1000) — NOT NULL — 알림내용
  • related_id — BIGINT — 관련ID
  • is_read — BOOLEAN — NOT NULL — 읽음여부
  • created_at — DATETIME — NOT NULL — 생성일시
  • INDEX — idx_notification_member_id
  • INDEX — idx_notification_type
  • INDEX — idx_notification_is_read
  • INDEX — idx_notification_created_at
  • INDEX — idx_notification_member_unread

pending_order

  • order_id — BIGINT — 주문ID
  • member_id — BIGINT — NOT NULL — 회원ID
  • stock_data_id — BIGINT — NOT NULL — 종목ID
  • order_type — ENUM('BUY', 'SELL') — NOT NULL — 주문유형
  • quantity — INT — NOT NULL — 주문수량
  • target_price — BIGINT — NOT NULL — 목표가격
  • reserved_fee — BIGINT — 예약수수료(매수용)
  • expected_fee — BIGINT — 예상수수료(매도용)
  • expected_tax — BIGINT — 예상세금(매도용)
  • version — BIGINT — 낙관적락버전
  • created_at — DATETIME(0) — NOT NULL — 생성일시
  • status — ENUM('PENDING', 'PROCESSING', 'COMPLETED', 'CANCELED', 'FAILED') — NOT NULL — 주문상태
  • INDEX — idx_pending_order_member_id
  • INDEX — idx_pending_order_stock_id
  • INDEX — idx_pending_order_status
  • INDEX — idx_pending_order_created_at

stock_comment

  • id — BIGINT — 댓글ID
  • stock_data_id — BIGINT — NOT NULL — 종목ID
  • member_id — BIGINT — NOT NULL — 회원ID
  • content — TEXT — NOT NULL — 댓글내용
  • parent_id — BIGINT — 부모댓글ID
  • is_deleted — BOOLEAN — NOT NULL — 삭제여부
  • created_at — DATETIME — NOT NULL — 생성일시
  • updated_at — DATETIME — NOT NULL — 수정일시
  • INDEX — idx_comment_stock_data_id
  • INDEX — idx_comment_member_id
  • INDEX — idx_comment_parent_id
  • INDEX — idx_comment_created_at

stock_comment_like

  • stock_comment_like_id — BIGINT — 댓글좋아요ID
  • member_id — BIGINT — NOT NULL — 회원ID
  • stock_comment_id — BIGINT — NOT NULL — 댓글ID
  • created_at — DATETIME — NOT NULL — 생성일시
  • INDEX — idx_comment_like_member_id
  • INDEX — idx_comment_like_comment_id

trade_history

  • trade_history_id — BIGINT — 거래내역ID
  • member_id — BIGINT — NOT NULL — 회원ID
  • stock_data_id — BIGINT — NOT NULL — 종목ID
  • trade_type — ENUM('BUY', 'SELL') — NOT NULL — 거래유형
  • quantity — INT — NOT NULL — 거래수량
  • unit_price — BIGINT — NOT NULL — 체결단가
  • total_price — BIGINT — NOT NULL — 총거래금액
  • fee — BIGINT — NOT NULL — 수수료
  • tax — BIGINT — NOT NULL — 세금
  • created_at — DATETIME(0) — NOT NULL — 생성일시
  • traded_at — DATETIME(0) — 체결시간
  • INDEX — idx_trade_member_id
  • INDEX — idx_trade_stock_data_id
  • INDEX — idx_trade_type
  • INDEX — idx_trade_traded_at
  • INDEX — idx_trade_member_stock