analysis_infos

14 rows where analyis_id = 0730123202

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ key value analyis_id
15514 MinFallzahl 100 MA Strategy Consumer 2012 DSG 0730123202
15515 AnalysenKennung MAStrategyConsumer2012 MA Strategy Consumer 2012 DSG 0730123202
15516 UniversumsID 2 MA Strategy Consumer 2012 DSG 0730123202
15517 Analysenname MA Strategy Consumer 2012 MA Strategy Consumer 2012 DSG 0730123202
15518 UniversumName Deutschsprachige Schweiz MA Strategy Consumer 2012 DSG 0730123202
15519 Tarifjahr 2012 MA Strategy Consumer 2012 DSG 0730123202
15520 MediengattungColor1 0;126;199 MA Strategy Consumer 2012 DSG 0730123202
15521 MediengattungColor2 0;158;166 MA Strategy Consumer 2012 DSG 0730123202
15522 MediengattungColor3 135;182;64 MA Strategy Consumer 2012 DSG 0730123202
15523 MediengattungColor4 255;209;67 MA Strategy Consumer 2012 DSG 0730123202
15524 MediengattungColor5 177;57;122 MA Strategy Consumer 2012 DSG 0730123202
15525 MediengattungColor6 244;0;18 MA Strategy Consumer 2012 DSG 0730123202
15526 MediengattungColor7 255;187;62 MA Strategy Consumer 2012 DSG 0730123202
15527 MediengattungColor8 254;130;44 MA Strategy Consumer 2012 DSG 0730123202

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");