analysis_infos

14 rows where analyis_id = 0730323101

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ key value analyis_id
15486 MinFallzahl 100 MA Strategy Consumer 2011 ISG 0730323101
15487 AnalysenKennung MAStrategyConsumer2011 MA Strategy Consumer 2011 ISG 0730323101
15488 UniversumsID 4 MA Strategy Consumer 2011 ISG 0730323101
15489 Analysenname MA Strategy Consumer 2011 MA Strategy Consumer 2011 ISG 0730323101
15490 UniversumName Italienischsprachige Schweiz MA Strategy Consumer 2011 ISG 0730323101
15491 Tarifjahr 2011 MA Strategy Consumer 2011 ISG 0730323101
15492 MediengattungColor1 0;126;199 MA Strategy Consumer 2011 ISG 0730323101
15493 MediengattungColor2 0;158;166 MA Strategy Consumer 2011 ISG 0730323101
15494 MediengattungColor3 135;182;64 MA Strategy Consumer 2011 ISG 0730323101
15495 MediengattungColor4 255;209;67 MA Strategy Consumer 2011 ISG 0730323101
15496 MediengattungColor5 177;57;122 MA Strategy Consumer 2011 ISG 0730323101
15497 MediengattungColor6 244;0;18 MA Strategy Consumer 2011 ISG 0730323101
15498 MediengattungColor7 255;187;62 MA Strategy Consumer 2011 ISG 0730323101
15499 MediengattungColor8 254;130;44 MA Strategy Consumer 2011 ISG 0730323101

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