analysis_infos
15 rows where analyis_id = 0730013502
This data as json, copyable, CSV (advanced)
| id ▼ | key | value | analyis_id |
|---|---|---|---|
| 15384 | MinFallzahl | 80 | MA Strategy Basic 2015 0730013502 |
| 15385 | AnalysenKennung | MAStrategyBasic2015 | MA Strategy Basic 2015 0730013502 |
| 15386 | UniversumsID | 1 | MA Strategy Basic 2015 0730013502 |
| 15387 | Analysenname | MA Strategy Basic 2015 | MA Strategy Basic 2015 0730013502 |
| 15388 | UniversumName | Schweiz Gesamt | MA Strategy Basic 2015 0730013502 |
| 15389 | Tarifjahr | 2015 | MA Strategy Basic 2015 0730013502 |
| 15390 | MediengattungColor1 | 0;126;199 | MA Strategy Basic 2015 0730013502 |
| 15391 | MediengattungColor2 | 0;158;166 | MA Strategy Basic 2015 0730013502 |
| 15392 | MediengattungColor3 | 135;182;64 | MA Strategy Basic 2015 0730013502 |
| 15393 | MediengattungColor4 | 255;209;67 | MA Strategy Basic 2015 0730013502 |
| 15394 | MediengattungColor5 | 177;57;122 | MA Strategy Basic 2015 0730013502 |
| 15395 | MediengattungColor6 | 244;0;18 | MA Strategy Basic 2015 0730013502 |
| 15396 | MediengattungColor7 | 255;187;62 | MA Strategy Basic 2015 0730013502 |
| 15397 | MediengattungColor8 | 254;130;44 | MA Strategy Basic 2015 0730013502 |
| 15398 | MediengattungColor10 | 255;102;204 | MA Strategy Basic 2015 0730013502 |
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");