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