스키마 · ValueChain.wiki

Data model · Schema

The data model behind the money-flow graph and the machine endpoints for agents. A reference for integrating the data directly.

Machine endpoints

/<slug>.md — Company node as LLM-reasoning markdown. Supports ?lang=en.
/<slug>.json — Structured JSON. Lossless bilingual (both ko and en fields).
/analysis/<slug>.md — Analysis article as LLM-reasoning markdown. Supports ?lang=en.
/llms.txt — Agent discovery index (all companies + .md links).

Tables

vc_companies · Company nodes

slugtextURL identifier (unique)
name / name_entextCompany name (KO/EN)
tickertextTicker (e.g. NVDA, 000660.KS)
kicker / lead (+_en)textCategory and summary (KO/EN)
segments / segments_enjsonbTotal revenue, concentration, segments
name_ko / countrytextKorean name (for foreign firms) and country code
returns_yearly / return_asofjsonb/dateYearly returns {year:%} and as-of date (heatmap)
price / price_currency / price_asofnum/text/dateCurrent price, currency, as-of (shown beside ratings)
analysis_ko / analysis_en / analysis_asoftext/dateValue-chain verification note (KO/EN) and as-of
updated_atdateLast updated (home sort key)

vc_edges · Money-flow edges

company_iduuidSource node
directiontext'revenue' | 'cost'
counterparty_nametextCounterparty name
counterparty_iduuidCounterparty node (links the graph when present)
confidencetext'high' | 'mid' | 'low'
metricjsonbNormalized metric {type,value,unit,period,basis,qualifier}
note (+_en)textNote (KO/EN)

vc_edge_sources · Observations (edge × source)

edge_id / source_iduuidEdge and source references
stancetext'confirms' | 'mentions' | 'contradicts'
as_ofdateObservation date
metricjsonbPer-observation normalized metric
excerpt (+_en)textSource excerpt (KO/EN)

vc_sources · Sources

urltextSource URL (unique)
title (+_en)textTitle (KO/EN)
publisher (+_en)textPublisher (KO/EN)
kindtext'filing' | 'news' | 'ir' | 'research'
published_at / langdate/textPublished date and language (ko/en)

vc_analyst_ratings · Broker analyst ratings

company_iduuidRated node
broker (+_en) / analysttextBroker (KO/EN) and analyst
rating / rating_normtextRaw rating and normalized ('buy'|'hold'|'sell')
target_price / currencynum/textTarget price and currency
report_title (+_en) / report_urltextReport title (KO/EN) and URL
summary_ko / summary_entextSummary (KO/EN)
published_at / accessed_atdateReport date and access date

vc_articles · Analysis articles

slugtextURL identifier (unique)
title / summary (+_en)textTitle and summary (KO/EN)
body_ko / body_entextBody markdown (bilingual)
tags (+_en) / related_slugstext[]Tags and related node slugs
faqjsonbQ&A [{q,a,q_en,a_en}], rendered as FAQPage JSON-LD
positionsjsonbPosition groups (returns live-joined from nodes)
changelogjsonbChange log [{date,note,note_en}], newest first
pinned / sort_orderbool/intPin to top (house view) and reading order
published_at / updated_atdatePublished and updated dates

vc_roadmap · Update and expansion log

entry_datedateEntry date
kindtext'update' (done) | 'planned'
statustext'done' | 'in_progress' | 'planned'
title (+_en) / detail (+_en)textTitle and detail (KO/EN)
sort_orderintSort order (unique)

vc_crawl_log · AI crawl and citation log

ts / pathtimestamp/textCrawl time and requested path
bot / categorytextBot id and funnel stage ('train'|'index'|'cite')
user_agenttextRaw User-Agent

All tables are public read-only via PostgREST. A versioned, authenticated API is planned.

스키마 · ValueChain.wiki