6 rows where analyis_id = 0290112801

View and edit SQL

id ▼ key value analyis_id
8152 MinFallzahl 100 MACH Basic 2008-1 DSG 0290112801
8153 AnalysenKennung MACHBasic2008-1 MACH Basic 2008-1 DSG 0290112801
8154 UniversumsID 2 MACH Basic 2008-1 DSG 0290112801
8155 Analysenname MACH Basic 2008-1 MACH Basic 2008-1 DSG 0290112801
8156 UniversumName Deutschsprachige Schweiz MACH Basic 2008-1 DSG 0290112801
8157 Tarifjahr 2008 MACH Basic 2008-1 DSG 0290112801

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