analysis_infos

14 rows where analyis_id = 0730013101

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ key value analyis_id
15156 MinFallzahl 100 MA Strategy Basic 2011 0730013101
15157 AnalysenKennung MAStrategyBasic2011 MA Strategy Basic 2011 0730013101
15158 UniversumsID 1 MA Strategy Basic 2011 0730013101
15159 Analysenname MA Strategy Basic 2011 MA Strategy Basic 2011 0730013101
15160 UniversumName Schweiz Gesamt MA Strategy Basic 2011 0730013101
15161 Tarifjahr 2011 MA Strategy Basic 2011 0730013101
15162 MediengattungColor1 0;126;199 MA Strategy Basic 2011 0730013101
15163 MediengattungColor2 0;158;166 MA Strategy Basic 2011 0730013101
15164 MediengattungColor3 135;182;64 MA Strategy Basic 2011 0730013101
15165 MediengattungColor4 255;209;67 MA Strategy Basic 2011 0730013101
15166 MediengattungColor5 177;57;122 MA Strategy Basic 2011 0730013101
15167 MediengattungColor6 244;0;18 MA Strategy Basic 2011 0730013101
15168 MediengattungColor7 255;187;62 MA Strategy Basic 2011 0730013101
15169 MediengattungColor8 254;130;44 MA Strategy Basic 2011 0730013101

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