15 rows where analyis_id = 0730123502

View and edit SQL

id ▼ key value analyis_id
15687 MinFallzahl 80 MA Strategy Consumer 2015 DSG 0730123502
15688 AnalysenKennung MAStrategyConsumer2015 MA Strategy Consumer 2015 DSG 0730123502
15689 UniversumsID 2 MA Strategy Consumer 2015 DSG 0730123502
15690 Analysenname MA Strategy Consumer 2015 MA Strategy Consumer 2015 DSG 0730123502
15691 UniversumName Deutschsprachige Schweiz MA Strategy Consumer 2015 DSG 0730123502
15692 Tarifjahr 2015 MA Strategy Consumer 2015 DSG 0730123502
15693 MediengattungColor1 0;126;199 MA Strategy Consumer 2015 DSG 0730123502
15694 MediengattungColor2 0;158;166 MA Strategy Consumer 2015 DSG 0730123502
15695 MediengattungColor3 135;182;64 MA Strategy Consumer 2015 DSG 0730123502
15696 MediengattungColor4 255;209;67 MA Strategy Consumer 2015 DSG 0730123502
15697 MediengattungColor5 177;57;122 MA Strategy Consumer 2015 DSG 0730123502
15698 MediengattungColor6 244;0;18 MA Strategy Consumer 2015 DSG 0730123502
15699 MediengattungColor7 255;187;62 MA Strategy Consumer 2015 DSG 0730123502
15700 MediengattungColor8 254;130;44 MA Strategy Consumer 2015 DSG 0730123502
15701 MediengattungColor10 255;102;204 MA Strategy Consumer 2015 DSG 0730123502

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