analysis_infos

14 rows where analyis_id = 0730123302

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ key value analyis_id
15570 MinFallzahl 80 MA Strategy Consumer 2013 DSG 0730123302
15571 AnalysenKennung MAStrategyConsumer2013 MA Strategy Consumer 2013 DSG 0730123302
15572 UniversumsID 2 MA Strategy Consumer 2013 DSG 0730123302
15573 Analysenname MA Strategy Consumer 2013 MA Strategy Consumer 2013 DSG 0730123302
15574 UniversumName Deutschsprachige Schweiz MA Strategy Consumer 2013 DSG 0730123302
15575 Tarifjahr 2013 MA Strategy Consumer 2013 DSG 0730123302
15576 MediengattungColor1 0;126;199 MA Strategy Consumer 2013 DSG 0730123302
15577 MediengattungColor2 0;158;166 MA Strategy Consumer 2013 DSG 0730123302
15578 MediengattungColor3 135;182;64 MA Strategy Consumer 2013 DSG 0730123302
15579 MediengattungColor4 255;209;67 MA Strategy Consumer 2013 DSG 0730123302
15580 MediengattungColor5 177;57;122 MA Strategy Consumer 2013 DSG 0730123302
15581 MediengattungColor6 244;0;18 MA Strategy Consumer 2013 DSG 0730123302
15582 MediengattungColor7 255;187;62 MA Strategy Consumer 2013 DSG 0730123302
15583 MediengattungColor8 254;130;44 MA Strategy Consumer 2013 DSG 0730123302

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