ZSTOCK
Tables (15)
data_source
- id — BIGINT — Primary key — NOT NULL
- date — DATE — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- source_type — VARCHAR(20) — NOT NULL
- headline — TEXT — NOT NULL
- url — TEXT
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- sentiment — VARCHAR(10)
financial_statements
- id — BIGINT — Primary key — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- fiscal_year — SMALLINT — NOT NULL
- revenue — BIGINT — NOT NULL
- operating_profit — BIGINT — NOT NULL
- operating_margin — NUMERIC
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
kakao_tokens
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- kakao_user_id — BIGINT — NOT NULL
- access_token — TEXT — NOT NULL
- refresh_token — TEXT — NOT NULL
- token_type — VARCHAR(20) — NOT NULL
- scope — TEXT
- expires_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- refresh_token_expires_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
market_indices
- id — BIGINT — Primary key — NOT NULL
- index_type — VARCHAR(20) — NOT NULL
- value — NUMERIC — NOT NULL
- recorded_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
sentiment_analysis
- id — BIGINT — Primary key — NOT NULL
- date — DATE — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- sentiment — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
shortform_likes
- id — BIGINT — Primary key — NOT NULL
- shortform_id — BIGINT — Foreign key → shortforms.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
shortforms
- id — BIGINT — Primary key — NOT NULL
- report_id — BIGINT — Foreign key → stock_reports.id
- ticker — VARCHAR(10) — Foreign key → stocks.code — NOT NULL
- s3_url — TEXT — NOT NULL
- script — TEXT — NOT NULL
- sentiment — VARCHAR(10) — NOT NULL
- view_count — INTEGER — NOT NULL
- like_count — INTEGER — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
stock_daily_candles
- id — BIGINT — Primary key — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- trade_date — DATE — NOT NULL
- open_price — NUMERIC — NOT NULL
- high_price — NUMERIC — NOT NULL
- low_price — NUMERIC — NOT NULL
- close_price — NUMERIC — NOT NULL
- volume — BIGINT — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
stock_minute_candles
- id — BIGINT — Primary key — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- traded_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- open_price — NUMERIC — NOT NULL
- high_price — NUMERIC — NOT NULL
- low_price — NUMERIC — NOT NULL
- close_price — NUMERIC — NOT NULL
- volume — BIGINT — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
stock_reports
- id — BIGINT — Primary key — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- report_date — DATE — NOT NULL
- judgement — VARCHAR(10)
- judgement_reasons — JSONB
- revenue_trend — VARCHAR(10)
- operating_profit_trend — VARCHAR(10)
- operating_margin_trend — VARCHAR(10)
- growth_grade — VARCHAR(10)
- profitability_grade — VARCHAR(10)
- risk_scores — JSONB
- peer_comparison — JSONB
- week52_high — NUMERIC
- week52_low — NUMERIC
- current_price — NUMERIC
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
stocks
- id — INTEGER — Primary key — NOT NULL
- code — VARCHAR(10) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- market — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
telegram_link_codes
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- code — VARCHAR(20) — NOT NULL
- expires_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- used_at — TIMESTAMP WITH TIME ZONE
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
telegram_notifications
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id
- notification_type — VARCHAR(20) — NOT NULL
- sent_date — DATE — NOT NULL
- sent_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- device_id — TEXT
- telegram_chat_id — TEXT
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- notify_morning — BOOLEAN — NOT NULL
- notify_evening — BOOLEAN — NOT NULL
- notify_alert — BOOLEAN — NOT NULL
watchlists
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
- updated_at — TIMESTAMP WITH TIME ZONE — NOT NULL