ㅁ
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 — 관심