decision_law_refs

9 rows where from_decision_id = "bge_100 IA 109"

✎ View and edit SQL

This data as json, CSV (advanced)

Link from_decision_id sr article raw_text
bge_100 IA 109,101,4 None bge_100 IA 109 101 4 Art. 4 BV
bge_100 IA 109,210,25 None bge_100 IA 109 210 25 art. 25 al. 1 CC
bge_100 IA 109,210,308 None bge_100 IA 109 210 308 art. 308 CC
bge_100 IA 109,210,311 None bge_100 IA 109 210 311 art. 311 CC
bge_100 IA 109,210,312 None bge_100 IA 109 210 312 art. 312 al. 1 CC
bge_100 IA 109,210,313 None bge_100 IA 109 210 313 art. 313 CC
bge_100 IA 109,272,58 None bge_100 IA 109 272 58 art. 58 CPC
bge_100 IA 109,272,61 None bge_100 IA 109 272 61 art. 61 al. 3 CPC
bge_100 IA 109,272,92 None bge_100 IA 109 272 92 art. 92 CPC

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