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)