analysis_infos
14 rows where analyis_id = 0730223302
This data as json, copyable, CSV (advanced)
| id ▼ | key | value | analyis_id |
|---|---|---|---|
| 15584 | MinFallzahl | 80 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15585 | AnalysenKennung | MAStrategyConsumer2013 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15586 | UniversumsID | 3 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15587 | Analysenname | MA Strategy Consumer 2013 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15588 | UniversumName | Französischsprachige Schweiz | MA Strategy Consumer 2013 FSG 0730223302 |
| 15589 | Tarifjahr | 2013 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15590 | MediengattungColor1 | 0;126;199 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15591 | MediengattungColor2 | 0;158;166 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15592 | MediengattungColor3 | 135;182;64 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15593 | MediengattungColor4 | 255;209;67 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15594 | MediengattungColor5 | 177;57;122 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15595 | MediengattungColor6 | 244;0;18 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15596 | MediengattungColor7 | 255;187;62 | MA Strategy Consumer 2013 FSG 0730223302 |
| 15597 | MediengattungColor8 | 254;130;44 | MA Strategy Consumer 2013 FSG 0730223302 |
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");