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