foia_documents

Data license: 비공개

✎ View and edit SQL

This data as json

0 records

CREATE TABLE foia_documents (
    id             INTEGER PRIMARY KEY AUTOINCREMENT,
    source         TEXT NOT NULL DEFAULT 'foia',
    source_id      TEXT,                     -- 청구 번호
    region         TEXT,
    org            TEXT,
    doc_type       TEXT,                     -- 'vehicle'|'project'|'expense'|'contract'|'other'
    request_date   TEXT,                     -- 청구일
    receive_date   TEXT,                     -- 접수·회신일
    title          TEXT,
    file_path      TEXT,                     -- 로컬 저장 경로
    content_summary TEXT,
    fiscal_year    INTEGER,
    extra          TEXT,                     -- JSON
    collect_method TEXT DEFAULT 'foia',
    collected_at   TEXT NOT NULL
);