1 row where variant = 24396

View and edit SQL

id ▼ variant media
54 24396 24396 Airport Touchpoint Nürnberg Öffentlicher Bereich BF_2_000

Advanced export

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

CSV options:

CREATE TABLE media_variant_standard (
	id INTEGER NOT NULL, 
	variant INTEGER, 
	media INTEGER, 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	UNIQUE (variant), 
	FOREIGN KEY(variant) REFERENCES media_variant (id), 
	FOREIGN KEY(media) REFERENCES media (id)
);
CREATE INDEX ix_media_variant_standard_media ON media_variant_standard (media);