law_finance_link

Data license: 비공개

0 rows where article_id = 40

✎ View and edit SQL

This data as json

0 records

CREATE TABLE law_finance_link (
    id               INTEGER PRIMARY KEY AUTOINCREMENT,
    local_gov_code   TEXT,
    fiscal_year      INTEGER,
    law_master_id    INTEGER NOT NULL REFERENCES law_master(id) ON DELETE CASCADE,
    article_id       INTEGER REFERENCES law_article(id) ON DELETE CASCADE,
    finance_tag      TEXT,
    target_type      TEXT,                  -- revenue/expenditure/fund/debt/indicator/process
    target_id        TEXT,
    link_type        TEXT,                  -- legal_basis/policy_basis/.../risk_signal
    evidence_text    TEXT,
    match_method     TEXT,
    confidence       REAL,
    review_status    TEXT DEFAULT 'auto',
    collected_at     TEXT NOT NULL
);
CREATE INDEX idx_law_finance_link_master
    ON law_finance_link(law_master_id, fiscal_year);