ZStock
Tables (15)
data_source
- id — BIGSERIAL — 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 — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
financial_statements
- id — BIGSERIAL — 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(6,2)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
kakao_tokens
- id — BIGSERIAL — 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 — TIMESTAMPTZ — NOT NULL
- refresh_token_expires_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
market_indices
- id — BIGSERIAL — Primary key — NOT NULL
- index_type — VARCHAR(20) — NOT NULL
- value — NUMERIC(15,4) — NOT NULL
- recorded_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
sentiment_analysis
- id — BIGSERIAL — Primary key — NOT NULL
- date — DATE — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- sentiment — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
shortform_likes
- id — BIGSERIAL — Primary key — NOT NULL
- shortform_id — BIGINT — Foreign key → shortforms.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
shortforms
- id — BIGSERIAL — Primary key — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- sentiment — VARCHAR(10) — NOT NULL
- video_url — TEXT — NOT NULL
- subtitle_text — TEXT — NOT NULL
- ai_insight — TEXT
- news_id — BIGINT — Foreign key → data_source.id
- view_count — INTEGER — NOT NULL
- like_count — INTEGER — NOT NULL
- published_date — DATE — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
stock_daily_candles
- id — BIGSERIAL — Primary key — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- trade_date — DATE — NOT NULL
- open_price — NUMERIC(15,2) — NOT NULL
- high_price — NUMERIC(15,2) — NOT NULL
- low_price — NUMERIC(15,2) — NOT NULL
- close_price — NUMERIC(15,2) — NOT NULL
- volume — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
stock_minute_candles
- id — BIGSERIAL — Primary key — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- traded_at — TIMESTAMPTZ — NOT NULL
- open_price — NUMERIC(15,2) — NOT NULL
- high_price — NUMERIC(15,2) — NOT NULL
- low_price — NUMERIC(15,2) — NOT NULL
- close_price — NUMERIC(15,2) — NOT NULL
- volume — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
stock_reports
- id — BIGSERIAL — 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(15,2)
- week52_low — NUMERIC(15,2)
- current_price — NUMERIC(15,2)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
stocks
- id — SERIAL — Primary key — NOT NULL
- code — VARCHAR(10) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- market — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
telegram_link_codes
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- code — VARCHAR(20) — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- used_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
telegram_notifications
- id — BIGSERIAL — 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 — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL
- device_id — TEXT
- telegram_chat_id — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
watchlists
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- stock_id — INTEGER — Foreign key → stocks.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL