law_appendix

Data license: 비공개

1 row where law_master_id = 52

✎ 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
6190 52 52 0001 00 서식 별지(대전광역시 체불임금 없는 관급공사 운영조례) http://www.law.go.kr/flDownload.do?gubun=ELIS&flSeq=163399525&flNm=%EB%B3%84%EC%A7%80%28%EB%8C%80%EC%A0%84%EA%B4%91%EC%97%AD%EC%8B%9C+%EC%B2%B4%EB%B6%88%EC%9E%84%EA%B8%88+%EC%97%86%EB%8A%94+%EA%B4%80%EA%B8%89%EA%B3%B5%EC%82%AC+%EC%9A%B4%EC%98%81%EC%A1%B0%EB%A1%80%29   {"별표제목": "별지(대전광역시 체불임금 없는 관급공사 운영조례)", "별표첨부파일구분": "hwpx", "별표첨부파일명": "http://www.law.go.kr/flDownload.do?gubun=ELIS&flSeq=163399525&flNm=%EB%B3%84%EC%A7%80%28%EB%8C%80%EC%A0%84%EA%B4%91%EC%97%AD%EC%8B%9C+%EC%B2%B4%EB%B6%88%EC%9E%84%EA%B8%88+%EC%97%86%EB%8A%94+%EA%B4%80%EA%B8%89%EA%B3%B5%EC%82%AC+%EC%9A%B4%EC%98%81%EC%A1%B0%EB%A1%80%29", "별표번호": "0001", "별표키": "21755033", "별표내용": "", "별표구분": "서식", "별표가지번호": "00"} 2026-06-27 00:52:43

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