stock

Tables (6)

holidays (휴일정보)

  • holiday_id (휴일ID) — Long — Primary key — NOT NULL
  • holiday_date (휴일일자) — Date
  • description (내용) — String

stock_aggregate (집계데이터)

  • agg_id (집계ID) — Long — Primary key — NOT NULL
  • stock_id (종목ID) — Long — Foreign key → stocks.stock_id — NOT NULL
  • agg_date (집계일자) — Date
  • stock_code (종목코드) — String
  • bbz_price (전일종가) — Double
  • current_price (현재가격) — Double
  • price_chg_rate (가격증감률) — Double
  • bbz_volume (전일거래량) — long
  • current_volume (현재거래량) — long
  • volume_chg_rate (거래량증감률) — Double
  • view_count (조회수) — long
  • created_at (생성시각) — DateTime
  • updated_at (수정시각) — DateTime

stock_trades (주식거래내역)

  • trade_id (거래ID) — Long — Primary key — NOT NULL
  • stock_id (종목ID) — Long — Foreign key → stocks.stock_id — NOT NULL
  • user_id (사용자ID) — Long — Foreign key → user.user_id — NOT NULL
  • trade_dt (거래일자) — Date
  • stock_code (종목코드) — String
  • stock_name (종목명) — String
  • order_type (매매구분코드) — String
  • quantity (매매수량) — long
  • price (매매가격) — Double
  • trade_time (거래시각) — DateTime
  • trn_stcd (거래상태코드) — String
  • created_at (생성시각) — DateTime
  • updated_at (수정시각) — DateTime

stock_views (주식조회원장)

  • view_id (조회ID) — Long — Primary key — NOT NULL
  • stock_id (종목ID) — Long — Foreign key → stocks.stock_id — NOT NULL
  • user_id (사용자ID) — Long — Foreign key → user.user_id — NOT NULL
  • view_timestamp (조회시각) — DateTime

stocks (주식종목)

  • stock_id (종목ID) — Long — Primary key — NOT NULL
  • stock_code (종목코드) — String
  • stock_name (종목명) — String
  • current_price (현재가격) — Double
  • bbz_price (전일종가) — Double
  • last_trade_dt (최종거래일자) — Date
  • created_at (생성일시) — DateTime
  • updated_at (수정일시) — DateTime

user (사용자)

  • user_id (사용자ID) — Long — Primary key — NOT NULL
  • user_name (사용자명) — String
  • created_at (생성시각) — DateTime
  • updated_at (수정시각) — DateTime