analysis_infos

6 rows where analyis_id = 0290023002

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ key value analyis_id
8892 MinFallzahl 100 MACH Consumer 2010-2 0290023002
8893 AnalysenKennung MACHConsumer2010-2 MACH Consumer 2010-2 0290023002
8894 UniversumsID 1 MACH Consumer 2010-2 0290023002
8895 Analysenname MACH Consumer 2010-2 MACH Consumer 2010-2 0290023002
8896 UniversumName Schweiz Gesamt MACH Consumer 2010-2 0290023002
8897 Tarifjahr 2011 MACH Consumer 2010-2 0290023002

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