StockDB

Tables (6)

Copy Of Untitled (Positions(캐시용))

  • Field (instrument_id) — BIGINT — Foreign key → Untitled.Field
  • Field2 (avg_price) — DECIMAL(18,6)
  • Field3 (quantity) — DECIMAL(18,6)
  • Field (update_at) — DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP

Copy Of Untitled2 (원달러 환율)

  • Field2 (rate_date) — DATE — Primary key
  • Field (usdkrw) — DECIMAL(18,6)

Copy Of Untitled3 (News_Cache)

  • Field (new_id) — BIGINT — Primary key
  • Field (instrument_id) — BIGINT — Foreign key → Untitled.Field
  • Field (title) — VARCHAR(255)
  • Field (url) — VARCHAR(255)
  • Field (published_at) — DATETIME
  • Field (ai_summary) — TEXT
  • Field (fetched_at) — DATETIME

Untitled (StockItem)

  • Field (instrument_id) — BIGINT — Primary key
  • Field2 (symbol) — VARCHAR
  • Field (name) — VARCHAR
  • Field (market) — ENUM('KR','US')
  • Field (asset_type) — ENUM('STOCK','ETF','INDEX')
  • Field (is_active) — BOOLEAN

Untitled (Market_Price)

  • Field (instrument_id) — BIGINT — Foreign key → Untitled.Field
  • Field (bar_date) — DATE
  • Field (open) — DECIMAL(18,6)
  • Field (high) — DECIMAL(18,6)
  • Field (low) — DECIMAL(18,6)
  • Field (close) — DECIMAL(18,6)

Untitled (TransActions)

  • Field (tx_id) — BIGINT — Primary key
  • Field (instrument_id) — BIGINT — Foreign key → Untitled.Field
  • Field2 (tx_type) — ENUM('BUY','SELL')
  • Field (tx_time) — DATETIME
  • Field3 (quantity) — DECIMAL(18,6)
  • Field (price) — DECIMAL(18,6)
  • Field (fee) — DECIMAL(18,6)
  • Field (tax) — DECIMAL(18,6)
  • Field (note) — VARCHAR(255)