law_article

Data license: 비공개

74 rows where law_master_id = 3073

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_article, collected_at (date)

CREATE TABLE law_article (
    id               INTEGER PRIMARY KEY AUTOINCREMENT,
    law_master_id    INTEGER NOT NULL REFERENCES law_master(id) ON DELETE CASCADE,
    article_key      TEXT NOT NULL,         -- 조문번호 + 제목 조합
    article_no       TEXT,                  -- 조문번호
    is_article       INTEGER DEFAULT 1,     -- 조문이면 1, 편/장/절/관이면 0
    article_title    TEXT,                  -- 조제목
    article_text     TEXT,                  -- 조내용
    sort_order       INTEGER,
    extra            TEXT,                  -- 원본 조문 JSON
    collected_at     TEXT NOT NULL,
    UNIQUE(law_master_id, article_key)
);
CREATE INDEX idx_law_article_master
    ON law_article(law_master_id, sort_order);