home / PUP_Spotconfigs_2022_02_v09

media_variant_standard

1 row where media = "FB_P_000"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ variant media
97 32758 32758 Public Video Mall Schleswig-Holstein FB_P_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.207ms