variant_types

3 rows where variant_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: variant_pos_in_type

Link variant_type_id variant_id variant_pos_in_type
1,2 Basisdaten 1 Hörer in den letzten 14 Tagen 2 1
5,2 Letzte Radionutzung 5 Hörer in den letzten 14 Tagen 2 3
6,2 Alle 6 Hörer in den letzten 14 Tagen 2 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE variant_types (
	variant_type_id INTEGER NOT NULL, 
	variant_id INTEGER NOT NULL, 
	variant_pos_in_type INTEGER, 
	PRIMARY KEY (variant_type_id, variant_id), 
	FOREIGN KEY(variant_type_id) REFERENCES variant_type (id), 
	FOREIGN KEY(variant_id) REFERENCES variant (id)
);