upbit
Tables (5)
candle
- candle_id — PK — Primary key — NOT NULL
- candle_time — TIMESTAMP
- open — NUMERIC
- high — NUMERIC
- low — NUMERIC
- close — NUMERIC
- volume — NUMERIC
- market_code — VARCHAR(20) — Foreign key → market.market_id — NOT NULL
market
- market_id — Primary key — NOT NULL
- market_code — VARCHAR(20)
- korean_name — VARCHAR(40)
- english_name — VARCHAR(40)
quality_check
- quality_id — PK — Primary key — NOT NULL
- check_time — TIMESTAMP
- table_name — VARCHAR(40)
- result — VARCHAR(20)
- details — TEXT
signal
- sig_id — PK — Primary key — NOT NULL
- market_code — VARCHAR(20) — Foreign key → market.market_id — NOT NULL
- signal_time — TIMESTAMP
- signal_type — VARCHAR(20)
- value — NUMERIC
trade
- trade_id — PK — Primary key — NOT NULL
- market_code — VARCHAR(20) — Foreign key → market.market_id — NOT NULL
- trade_time — TIMESTAMP
- price — NUMERIC
- volume — NUMERIC
- ask_bid — VARCHAR(10)
- seq_id — BIGINT