cantonal_laws

37 rows

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE TABLE cantonal_laws (
    lexfind_id           INTEGER PRIMARY KEY,
    canton               TEXT NOT NULL DEFAULT 'ZH',
    systematic_number    TEXT,
    keywords             TEXT,
    title                TEXT,
    category             TEXT,
    is_active            INTEGER DEFAULT 1,
    version_active_since TEXT,
    original_url         TEXT,
    article_count        INTEGER,
    content_hash         TEXT,
    json_path            TEXT,
    fetch_status         TEXT NOT NULL DEFAULT 'pending',
    last_fetch_attempt   TEXT,
    downloaded_at        TEXT,
    error_message        TEXT
);
CREATE INDEX idx_cantonal_laws_canton   ON cantonal_laws(canton);
CREATE INDEX idx_cantonal_laws_keywords ON cantonal_laws(canton, keywords);
CREATE INDEX idx_cantonal_laws_sysno    ON cantonal_laws(canton, systematic_number);
CREATE INDEX idx_cantonal_laws_status   ON cantonal_laws(fetch_status);