analysis_infos
14 rows where analyis_id = 0730023202
This data as json, copyable, CSV (advanced)
| id ▼ | key | value | analyis_id |
|---|---|---|---|
| 15500 | MinFallzahl | 100 | MA Strategy Consumer 2012 0730023202 |
| 15501 | AnalysenKennung | MAStrategyConsumer2012 | MA Strategy Consumer 2012 0730023202 |
| 15502 | UniversumsID | 1 | MA Strategy Consumer 2012 0730023202 |
| 15503 | Analysenname | MA Strategy Consumer 2012 | MA Strategy Consumer 2012 0730023202 |
| 15504 | UniversumName | Schweiz Gesamt | MA Strategy Consumer 2012 0730023202 |
| 15505 | Tarifjahr | 2012 | MA Strategy Consumer 2012 0730023202 |
| 15506 | MediengattungColor1 | 0;126;199 | MA Strategy Consumer 2012 0730023202 |
| 15507 | MediengattungColor2 | 0;158;166 | MA Strategy Consumer 2012 0730023202 |
| 15508 | MediengattungColor3 | 135;182;64 | MA Strategy Consumer 2012 0730023202 |
| 15509 | MediengattungColor4 | 255;209;67 | MA Strategy Consumer 2012 0730023202 |
| 15510 | MediengattungColor5 | 177;57;122 | MA Strategy Consumer 2012 0730023202 |
| 15511 | MediengattungColor6 | 244;0;18 | MA Strategy Consumer 2012 0730023202 |
| 15512 | MediengattungColor7 | 255;187;62 | MA Strategy Consumer 2012 0730023202 |
| 15513 | MediengattungColor8 | 254;130;44 | MA Strategy Consumer 2012 0730023202 |
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");