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