decision_law_refs

7 rows where from_decision_id = "bge_100 IA 348"

✎ View and edit SQL

This data as json, CSV (advanced)

Link from_decision_id sr article raw_text
bge_100 IA 348,101,22ter None bge_100 IA 348 101 22ter Art. 22ter BV
bge_100 IA 348,101,4 None bge_100 IA 348 101 4 Art. 4 BV
bge_100 IA 348,210,642 None bge_100 IA 348 210 642 Art. 642 ZGB
bge_100 IA 348,210,805 None bge_100 IA 348 210 805 Art. 805 ZGB
bge_100 IA 348,210,808 None bge_100 IA 348 210 808 Art. 808 ZGB
bge_100 IA 348,210,836 None bge_100 IA 348 210 836 Art. 836 ZGB
bge_100 IA 348,210,895 None bge_100 IA 348 210 895 Art. 895 Abs. 1 ZGB

Advanced export

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

CSV options: 

CREATE TABLE decision_law_refs (
    from_decision_id TEXT NOT NULL,
    sr               TEXT NOT NULL,
    article          TEXT NOT NULL,
    raw_text         TEXT,
    PRIMARY KEY (from_decision_id, sr, article),
    FOREIGN KEY (from_decision_id) REFERENCES decisions(decision_id) ON DELETE CASCADE
);
CREATE INDEX idx_dlr_law      ON decision_law_refs(sr, article);
CREATE INDEX idx_dlr_decision ON decision_law_refs(from_decision_id);