6 rows where analyis_id = 0290023401

View and edit SQL

id ▼ key value analyis_id
9036 MinFallzahl 80 MACH Consumer 2014 0290023401
9037 AnalysenKennung MACHConsumer2014 MACH Consumer 2014 0290023401
9038 UniversumsID 1 MACH Consumer 2014 0290023401
9039 Analysenname MACH Consumer 2014 MACH Consumer 2014 0290023401
9040 UniversumName Schweiz Gesamt MACH Consumer 2014 0290023401
9041 Tarifjahr 2015 MACH Consumer 2014 0290023401

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