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