15 rows where analyis_id = 0730113502

View and edit SQL

id ▼ key value analyis_id
15399 MinFallzahl 80 MA Strategy Basic 2015 DSG 0730113502
15400 AnalysenKennung MAStrategyBasic2015 MA Strategy Basic 2015 DSG 0730113502
15401 UniversumsID 2 MA Strategy Basic 2015 DSG 0730113502
15402 Analysenname MA Strategy Basic 2015 MA Strategy Basic 2015 DSG 0730113502
15403 UniversumName Deutschsprachige Schweiz MA Strategy Basic 2015 DSG 0730113502
15404 Tarifjahr 2015 MA Strategy Basic 2015 DSG 0730113502
15405 MediengattungColor1 0;126;199 MA Strategy Basic 2015 DSG 0730113502
15406 MediengattungColor2 0;158;166 MA Strategy Basic 2015 DSG 0730113502
15407 MediengattungColor3 135;182;64 MA Strategy Basic 2015 DSG 0730113502
15408 MediengattungColor4 255;209;67 MA Strategy Basic 2015 DSG 0730113502
15409 MediengattungColor5 177;57;122 MA Strategy Basic 2015 DSG 0730113502
15410 MediengattungColor6 244;0;18 MA Strategy Basic 2015 DSG 0730113502
15411 MediengattungColor7 255;187;62 MA Strategy Basic 2015 DSG 0730113502
15412 MediengattungColor8 254;130;44 MA Strategy Basic 2015 DSG 0730113502
15413 MediengattungColor10 255;102;204 MA Strategy Basic 2015 DSG 0730113502

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