law_appendix

Data license: 비공개

1 row where law_master_id = 40

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: collected_at (date)

id ▼ law_master_id appendix_no appendix_branch_no appendix_type appendix_title attachment_name appendix_text extra collected_at
6218 40 40 0001 00 서식 별지(대전광역시 소방시설 및 피난ㆍ방화시설 등에 대한 위반행위 신고포상제 운영 조례) http://www.law.go.kr/flDownload.do?gubun=ELIS&flSeq=163399523&flNm=%EB%B3%84%EC%A7%80%28%EB%8C%80%EC%A0%84%EA%B4%91%EC%97%AD%EC%8B%9C+%EC%86%8C%EB%B0%A9%EC%8B%9C%EC%84%A4+%EB%B0%8F+%ED%94%BC%EB%82%9C%E3%86%8D%EB%B0%A9%ED%99%94%EC%8B%9C%EC%84%A4+%EB%93%B1%EC%97%90+%EB%8C%80%ED%95%9C+%EC%9C%84%EB%B0%98%ED%96%89%EC%9C%84+%EC%8B%A0%EA%B3%A0%ED%8F%AC%EC%83%81%EC%A0%9C+%EC%9A%B4%EC%98%81+%EC%A1%B0%EB%A1%80%29   {"별표제목": "별지(대전광역시 소방시설 및 피난ㆍ방화시설 등에 대한 위반행위 신고포상제 운영 조례)", "별표첨부파일구분": "hwpx", "별표첨부파일명": "http://www.law.go.kr/flDownload.do?gubun=ELIS&flSeq=163399523&flNm=%EB%B3%84%EC%A7%80%28%EB%8C%80%EC%A0%84%EA%B4%91%EC%97%AD%EC%8B%9C+%EC%86%8C%EB%B0%A9%EC%8B%9C%EC%84%A4+%EB%B0%8F+%ED%94%BC%EB%82%9C%E3%86%8D%EB%B0%A9%ED%99%94%EC%8B%9C%EC%84%A4+%EB%93%B1%EC%97%90+%EB%8C%80%ED%95%9C+%EC%9C%84%EB%B0%98%ED%96%89%EC%9C%84+%EC%8B%A0%EA%B3%A0%ED%8F%AC%EC%83%81%EC%A0%9C+%EC%9A%B4%EC%98%81+%EC%A1%B0%EB%A1%80%29", "별표번호": "0001", "별표키": "21755031", "별표내용": "", "별표구분": "서식", "별표가지번호": "00"} 2026-06-27 00:53:10

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);