analysis_infos

15 rows where analyis_id = 0730213402

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ key value analyis_id
15354 MinFallzahl 80 MA Strategy Basic 2014 FSG 0730213402
15355 AnalysenKennung MAStrategyBasic2014 MA Strategy Basic 2014 FSG 0730213402
15356 UniversumsID 3 MA Strategy Basic 2014 FSG 0730213402
15357 Analysenname MA Strategy Basic 2014 MA Strategy Basic 2014 FSG 0730213402
15358 UniversumName Französischsprachige Schweiz MA Strategy Basic 2014 FSG 0730213402
15359 Tarifjahr 2014 MA Strategy Basic 2014 FSG 0730213402
15360 MediengattungColor1 0;126;199 MA Strategy Basic 2014 FSG 0730213402
15361 MediengattungColor2 0;158;166 MA Strategy Basic 2014 FSG 0730213402
15362 MediengattungColor3 135;182;64 MA Strategy Basic 2014 FSG 0730213402
15363 MediengattungColor4 255;209;67 MA Strategy Basic 2014 FSG 0730213402
15364 MediengattungColor5 177;57;122 MA Strategy Basic 2014 FSG 0730213402
15365 MediengattungColor6 244;0;18 MA Strategy Basic 2014 FSG 0730213402
15366 MediengattungColor7 255;187;62 MA Strategy Basic 2014 FSG 0730213402
15367 MediengattungColor8 254;130;44 MA Strategy Basic 2014 FSG 0730213402
15368 MediengattungColor10 255;102;204 MA Strategy Basic 2014 FSG 0730213402

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