law_appendix

Data license: 비공개

2 rows where law_master_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: collected_at (date)

CREATE TABLE law_appendix (
    id                  INTEGER PRIMARY KEY AUTOINCREMENT,
    law_master_id       INTEGER NOT NULL REFERENCES law_master(id) ON DELETE CASCADE,
    appendix_no         TEXT,
    appendix_branch_no  TEXT,
    appendix_type       TEXT,
    appendix_title      TEXT,
    attachment_name     TEXT,
    appendix_text       TEXT,
    extra               TEXT,
    collected_at        TEXT NOT NULL,
    UNIQUE(law_master_id, appendix_no, appendix_branch_no, appendix_title)
);
CREATE INDEX idx_law_appendix_master
    ON law_appendix(law_master_id);