penguin-milk

Tables (23)

company

  • id — BIGINT — Primary key — NOT NULL
  • market — TEXT — NOT NULL
  • code — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • industry — TEXT — NOT NULL
  • currency — TEXT — NOT NULL

daily_price

  • trade_date — DATE — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • close_local — NUMERIC(18,4) — NOT NULL
  • volume — BIGINT — NOT NULL

financial_fact

  • id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • metric — TEXT — NOT NULL
  • fiscal_period — TEXT — NOT NULL
  • value — NUMERIC(24,6) — NOT NULL
  • disclosed_on — DATE — NOT NULL

financial_snapshot

  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • per — NUMERIC(12,4)
  • pbr — NUMERIC(12,4)
  • revenue_yoy — NUMERIC(10,6)
  • op_yoy — NUMERIC(10,6)
  • op_margin — NUMERIC(10,6)
  • debt_ratio — NUMERIC(10,6)
  • ocf_sign — SMALLINT
  • updated_at — TIMESTAMPTZ — NOT NULL

fx_rate

  • as_of — TIMESTAMPTZ — Primary key — NOT NULL
  • rate — NUMERIC(12,4) — NOT NULL
  • source — TEXT — NOT NULL

keyword

  • id — BIGINT — Primary key — NOT NULL
  • term — TEXT — NOT NULL
  • lang — TEXT — NOT NULL
  • term_jamo — TEXT
  • first_seen_on — DATE — NOT NULL
  • doc_freq — INTEGER — NOT NULL

keyword_alias

  • alias — TEXT — Primary key — NOT NULL
  • keyword_id — BIGINT — Foreign key → keyword.id
  • company_id — BIGINT — Foreign key → company.id

keyword_blacklist

  • term — TEXT — Primary key — NOT NULL
  • reason — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

keyword_daily

  • obs_date — DATE — Primary key — NOT NULL
  • keyword_id — BIGINT — Foreign key → keyword.id — NOT NULL
  • doc_count — INTEGER — NOT NULL
  • spike_ratio — NUMERIC(10,4)

keyword_related

  • keyword_id — BIGINT — Foreign key → keyword.id — NOT NULL
  • related_keyword_id — BIGINT — Foreign key → keyword.id — NOT NULL
  • score — NUMERIC(10,6) — NOT NULL
  • rank — SMALLINT — NOT NULL

macro_daily

  • variable — TEXT — Primary key — NOT NULL
  • obs_date — DATE — Primary key — NOT NULL
  • value — NUMERIC(18,6) — NOT NULL
  • change_pct — NUMERIC(10,6)

market_calendar

  • market — TEXT — Primary key — NOT NULL
  • cal_date — DATE — Primary key — NOT NULL
  • is_trading_day — BOOLEAN — NOT NULL
  • open_at — TIMESTAMPTZ
  • close_at — TIMESTAMPTZ

metric_help

  • metric — TEXT — Primary key — NOT NULL
  • what_is — TEXT — NOT NULL
  • what_to_look — TEXT — NOT NULL
  • caveat — TEXT — NOT NULL

orders

  • id — BIGINT — Primary key — NOT NULL
  • client_order_id — UUID — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • wallet_id — BIGINT — Foreign key → wallet.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • side — TEXT — NOT NULL
  • qty — INTEGER — NOT NULL
  • price_local — NUMERIC(18,4) — NOT NULL
  • fx_rate — NUMERIC(12,4) — NOT NULL
  • amount_krw — BIGINT — NOT NULL
  • fee_krw — BIGINT — NOT NULL
  • tax_krw — BIGINT — NOT NULL
  • executed_at — TIMESTAMPTZ — NOT NULL
  • saw_news — BOOLEAN — NOT NULL
  • saw_chart — BOOLEAN — NOT NULL
  • saw_volume — BOOLEAN — NOT NULL
  • saw_fin — BOOLEAN — NOT NULL
  • scored_at — TIMESTAMPTZ
  • score_close_local — NUMERIC(18,4)
  • score_return — NUMERIC(10,6)

position

  • wallet_id — BIGINT — Foreign key → wallet.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • qty — INTEGER — NOT NULL
  • avg_price_local — NUMERIC(18,4) — NOT NULL
  • avg_fx_rate — NUMERIC(12,4) — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

ranking_snapshot

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • rank — INTEGER — NOT NULL
  • total_asset_krw — BIGINT — NOT NULL
  • check_rate — NUMERIC(5,4)
  • captured_at — TIMESTAMPTZ — NOT NULL

rival

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • rival_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • added_at — TIMESTAMPTZ — NOT NULL

topic

  • id — BIGINT — Primary key — NOT NULL
  • cluster_id — TEXT — NOT NULL
  • country_code — CHAR(2) — NOT NULL
  • occurred_on — DATE — NOT NULL
  • industry — TEXT
  • direction — TEXT
  • impact — TEXT
  • confidence — NUMERIC(4,3)
  • title — TEXT
  • summary — TEXT
  • prompt_version — TEXT
  • generated_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

topic_article

  • id — BIGINT — Primary key — NOT NULL
  • topic_id — BIGINT — Foreign key → topic.id — NOT NULL
  • article_key — TEXT — NOT NULL
  • title — TEXT — NOT NULL
  • source — TEXT — NOT NULL
  • source_country — CHAR(2)
  • published_at — TIMESTAMPTZ — NOT NULL
  • tone — NUMERIC(6,3)
  • url — TEXT — NOT NULL

topic_company

  • topic_id — BIGINT — Foreign key → topic.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • occurred_on — DATE — NOT NULL

topic_keyword

  • topic_id — BIGINT — Foreign key → topic.id — NOT NULL
  • keyword_id — BIGINT — Foreign key → keyword.id — NOT NULL
  • weight — NUMERIC(10,6) — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • google_sub — TEXT — NOT NULL
  • nickname — TEXT — NOT NULL

wallet

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • kind — TEXT — NOT NULL
  • run_id — TEXT
  • cash_krw — BIGINT — NOT NULL
  • seeded_at — TIMESTAMPTZ — NOT NULL