analysis_infos

15 rows where analyis_id = 0730313402

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ key value analyis_id
15369 MinFallzahl 80 MA Strategy Basic 2014 ISG 0730313402
15370 AnalysenKennung MAStrategyBasic2014 MA Strategy Basic 2014 ISG 0730313402
15371 UniversumsID 4 MA Strategy Basic 2014 ISG 0730313402
15372 Analysenname MA Strategy Basic 2014 MA Strategy Basic 2014 ISG 0730313402
15373 UniversumName Italienischsprachige Schweiz MA Strategy Basic 2014 ISG 0730313402
15374 Tarifjahr 2014 MA Strategy Basic 2014 ISG 0730313402
15375 MediengattungColor1 0;126;199 MA Strategy Basic 2014 ISG 0730313402
15376 MediengattungColor2 0;158;166 MA Strategy Basic 2014 ISG 0730313402
15377 MediengattungColor3 135;182;64 MA Strategy Basic 2014 ISG 0730313402
15378 MediengattungColor4 255;209;67 MA Strategy Basic 2014 ISG 0730313402
15379 MediengattungColor5 177;57;122 MA Strategy Basic 2014 ISG 0730313402
15380 MediengattungColor6 244;0;18 MA Strategy Basic 2014 ISG 0730313402
15381 MediengattungColor7 255;187;62 MA Strategy Basic 2014 ISG 0730313402
15382 MediengattungColor8 254;130;44 MA Strategy Basic 2014 ISG 0730313402
15383 MediengattungColor10 255;102;204 MA Strategy Basic 2014 ISG 0730313402

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