legislation

Data license: 비공개

✎ View and edit SQL

This data as json

0 records

CREATE TABLE legislation (
    leg_id        INTEGER PRIMARY KEY AUTOINCREMENT,
    gov_code      TEXT,
    title         TEXT,
    title_norm    TEXT,         -- 정규화 제목 (키워드 매칭용)
    leg_type      TEXT,         -- notice(입법예고)·ordinance(제정조례)
    status        TEXT DEFAULT 'pending',  -- pending·enacted·withdrawn
    propose_date  TEXT,
    result_date   TEXT,
    source_table  TEXT,
    source_id     INTEGER,
    source_file   TEXT
);