analysis_infos

15 rows where analyis_id = 0730313502

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ key value analyis_id
15429 MinFallzahl 80 MA Strategy Basic 2015 ISG 0730313502
15430 AnalysenKennung MAStrategyBasic2015 MA Strategy Basic 2015 ISG 0730313502
15431 UniversumsID 4 MA Strategy Basic 2015 ISG 0730313502
15432 Analysenname MA Strategy Basic 2015 MA Strategy Basic 2015 ISG 0730313502
15433 UniversumName Italienischsprachige Schweiz MA Strategy Basic 2015 ISG 0730313502
15434 Tarifjahr 2015 MA Strategy Basic 2015 ISG 0730313502
15435 MediengattungColor1 0;126;199 MA Strategy Basic 2015 ISG 0730313502
15436 MediengattungColor2 0;158;166 MA Strategy Basic 2015 ISG 0730313502
15437 MediengattungColor3 135;182;64 MA Strategy Basic 2015 ISG 0730313502
15438 MediengattungColor4 255;209;67 MA Strategy Basic 2015 ISG 0730313502
15439 MediengattungColor5 177;57;122 MA Strategy Basic 2015 ISG 0730313502
15440 MediengattungColor6 244;0;18 MA Strategy Basic 2015 ISG 0730313502
15441 MediengattungColor7 255;187;62 MA Strategy Basic 2015 ISG 0730313502
15442 MediengattungColor8 254;130;44 MA Strategy Basic 2015 ISG 0730313502
15443 MediengattungColor10 255;102;204 MA Strategy Basic 2015 ISG 0730313502

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