analysis_infos
6 rows where analyis_id = 0290112801
This data as json, copyable, CSV (advanced)
| id ▼ | key | value | analyis_id |
|---|---|---|---|
| 8152 | MinFallzahl | 100 | MACH Basic 2008-1 DSG 0290112801 |
| 8153 | AnalysenKennung | MACHBasic2008-1 | MACH Basic 2008-1 DSG 0290112801 |
| 8154 | UniversumsID | 2 | MACH Basic 2008-1 DSG 0290112801 |
| 8155 | Analysenname | MACH Basic 2008-1 | MACH Basic 2008-1 DSG 0290112801 |
| 8156 | UniversumName | Deutschsprachige Schweiz | MACH Basic 2008-1 DSG 0290112801 |
| 8157 | Tarifjahr | 2008 | MACH Basic 2008-1 DSG 0290112801 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE analysis_infos (
id INTEGER NOT NULL,
"key" VARCHAR(250),
value VARCHAR(250),
analyis_id VARCHAR(10),
PRIMARY KEY (id),
UNIQUE (id),
FOREIGN KEY(analyis_id) REFERENCES analysis (id)
);
CREATE INDEX ix_analysis_infos_key ON analysis_infos ("key");