home / PUP_Spotconfigs_2022_01

media_variant_standard

1 row where media = "FB_M_000"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ variant media
113 41407 41407 Mall Video Saarland FB_M_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);
Powered by Datasette · Queries took 8.956ms