ㅁ

Tables (19)

admin_action_log

  • log_id — BIGINT — 로그
  • admin_id — BIGINT — 행동한
  • action — VARCHAR(255) — 수행한
  • target — VARCHAR(255) — 작업
  • created_at — TIMESTAMP — 작업

asset_history

  • id — BIGINT — 기록
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 사용자
  • total_asset — DECIMAL(15,2) — 해당
  • timestamp — TIMESTAMP — 기록

comments

  • comment_id — BIGINT — 댓글
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL — 어느
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 작성자
  • content — TEXT — 댓글
  • created_at — TIMESTAMP — 작성

likes

  • id — BIGINT — 좋아요
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 좋아요
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL — 좋아요

order_queue

  • queue_id — BIGINT — 호가
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 주문을
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL — 종목
  • type — VARCHAR(10) — 매수/매도
  • price — DECIMAL(15,2) — 주문
  • remaining_qty — BIGINT — 남은
  • created_at — TIMESTAMP — 큐에

orders

  • order_id — BIGINT — 주문
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 주문을
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL — 주문
  • type — VARCHAR(10) — 주문
  • order_type — VARCHAR(10) — 주문
  • price — DECIMAL(15,2) — 주문
  • quantity — BIGINT — NOT NULL — 주문
  • filled_quantity — BIGINT — 이미
  • remaining_quantity — BIGINT — 아직
  • status — VARCHAR(20) — 주문
  • created_at — TIMESTAMP — 주문

portfolio_position

  • position_id — BIGINT — 보유
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 사용자
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL — 종목
  • quantity — BIGINT — NOT NULL — 현재
  • avg_price — DECIMAL(15,2) — 평균
  • updated_at — TIMESTAMP — 마지막

portfolio_summary

  • user_id — BIGINT — Foreign key → users.user_id — 사용자
  • total_asset — DECIMAL(15,2) — 총
  • total_profit — DECIMAL(15,2) — 총
  • profit_rate — DECIMAL(10,2) — 수익률
  • updated_at — TIMESTAMP — 갱신

posts

  • post_id — BIGINT — 게시글
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 작성자
  • title — VARCHAR(255) — 게시글
  • content — TEXT — 게시글
  • created_at — TIMESTAMP — 작성

recent_view

  • id — BIGINT — 최근조회
  • user_id — BIGINT — NOT NULL — 사용자
  • stock_id — BIGINT — NOT NULL — 조회한
  • viewed_at — TIMESTAMP — 조회

stock

  • stock_id — BIGINT — 종목
  • code — VARCHAR(20) — 종목
  • name — VARCHAR(100) — 종목
  • market — VARCHAR(50) — 시장

stock_analysis

  • analysis_id — BIGINT — 분석
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL — 종목
  • signal — VARCHAR(20) — AI
  • confidence — DECIMAL(5,2) — 추천
  • created_at — TIMESTAMP — 분석

stock_liquidity

  • stock_id — BIGINT — Foreign key → stock.stock_id — 종목
  • available_buy_qty — BIGINT — 현재
  • available_sell_qty — BIGINT — 현재
  • spread — DECIMAL(10,2) — 매도
  • updated_at — TIMESTAMP — 유동성

stock_price_tick

  • tick_id — BIGINT — 가격
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL — 종목
  • price — DECIMAL(15,2) — NOT NULL — 해당
  • volume — BIGINT — 해당
  • timestamp — TIMESTAMP — 가격이

stock_realtime

  • stock_id — BIGINT — Foreign key → stock.stock_id — 종목
  • current_price — DECIMAL(15,2) — 현재
  • open_price — DECIMAL(15,2) — 당일
  • change_price — DECIMAL(10,2) — 시가
  • change_rate — DECIMAL(10,2) — 시가
  • volume — BIGINT — 누적
  • updated_at — TIMESTAMP — 마지막

trades

  • trade_id — BIGINT — 체결
  • order_id — BIGINT — Foreign key → orders.order_id — NOT NULL — 어떤
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL — 종목
  • price — DECIMAL(15,2) — 실제로
  • quantity — BIGINT — 체결된
  • executed_at — TIMESTAMP — 체결이

user_wallet

  • wallet_id — BIGINT — 지갑
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 해당
  • balance — DECIMAL(15,2) — 실제
  • locked_balance — DECIMAL(15,2) — 주문에
  • updated_at — TIMESTAMP — 마지막으로

users

  • user_id — BIGINT — 사용자
  • email — VARCHAR(255) — NOT NULL — 로그인에
  • password — VARCHAR(255) — 비밀번호
  • nickname — VARCHAR(100) — 서비스에서
  • provider — VARCHAR(50) — 로그인
  • role — VARCHAR(20) — 권한
  • status — VARCHAR(20) — 계정
  • created_at — TIMESTAMP — 회원가입

watchlist

  • id — BIGINT — 관심종목
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 사용자
  • stock_id — BIGINT — Foreign key → stock.stock_id — NOT NULL — 관심