analysis_infos
14 rows where analyis_id = 0730113202
This data as json, copyable, CSV (advanced)
| id ▼ | key | value | analyis_id |
|---|---|---|---|
| 15226 | MinFallzahl | 100 | MA Strategy Basic 2012 DSG 0730113202 |
| 15227 | AnalysenKennung | MAStrategyBasic2012 | MA Strategy Basic 2012 DSG 0730113202 |
| 15228 | UniversumsID | 2 | MA Strategy Basic 2012 DSG 0730113202 |
| 15229 | Analysenname | MA Strategy Basic 2012 | MA Strategy Basic 2012 DSG 0730113202 |
| 15230 | UniversumName | Deutschsprachige Schweiz | MA Strategy Basic 2012 DSG 0730113202 |
| 15231 | Tarifjahr | 2012 | MA Strategy Basic 2012 DSG 0730113202 |
| 15232 | MediengattungColor1 | 0;126;199 | MA Strategy Basic 2012 DSG 0730113202 |
| 15233 | MediengattungColor2 | 0;158;166 | MA Strategy Basic 2012 DSG 0730113202 |
| 15234 | MediengattungColor3 | 135;182;64 | MA Strategy Basic 2012 DSG 0730113202 |
| 15235 | MediengattungColor4 | 255;209;67 | MA Strategy Basic 2012 DSG 0730113202 |
| 15236 | MediengattungColor5 | 177;57;122 | MA Strategy Basic 2012 DSG 0730113202 |
| 15237 | MediengattungColor6 | 244;0;18 | MA Strategy Basic 2012 DSG 0730113202 |
| 15238 | MediengattungColor7 | 255;187;62 | MA Strategy Basic 2012 DSG 0730113202 |
| 15239 | MediengattungColor8 | 254;130;44 | MA Strategy Basic 2012 DSG 0730113202 |
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");