decision_law_refs

15 rows where from_decision_id = "bge_151 II 742"

✎ View and edit SQL

This data as json, CSV (advanced)

Link from_decision_id sr article raw_text
bge_151 II 742,231.1,10 None bge_151 II 742 231.1 10 Art. 10 Abs. 1 URG
bge_151 II 742,241,2 None bge_151 II 742 241 2 Art. 2 UWG
bge_151 II 742,241,3 None bge_151 II 742 241 3 Art. 3 Abs. 1 lit. d UWG
bge_151 II 742,241,5 None bge_151 II 742 241 5 Art. 5 lit. c UWG
bge_151 II 742,251,27 None bge_151 II 742 251 27 Art. 27 KG
bge_151 II 742,251,3 None bge_151 II 742 251 3 Art. 3 Abs. 1 lit. a KG
bge_151 II 742,251,30 None bge_151 II 742 251 30 Art. 30 KG
bge_151 II 742,251,4 None bge_151 II 742 251 4 Art. 4 Abs. 2 KG
bge_151 II 742,251,49a None bge_151 II 742 251 49a Art. 49a KG
bge_151 II 742,251,53 None bge_151 II 742 251 53 Art. 53 KG
bge_151 II 742,251,7 None bge_151 II 742 251 7 Art. 7 Abs. 2 KG
bge_151 II 742,251,9 None bge_151 II 742 251 9 Art. 9 KG
bge_151 II 742,251.5,3 None bge_151 II 742 251.5 3 Art. 3 SVKG
bge_151 II 742,812.21,4 None bge_151 II 742 812.21 4 Art. 4 Abs. 1 lit. a HMG
bge_151 II 742,812.21,9 None bge_151 II 742 812.21 9 Art. 9 HMG

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