schema.cql
No One
Actions

Authored By

	Eevans
	Nov 1 2021, 7:00 PM

Size

5 KB

Referenced Files

None

Subscribers

None

schema.cql
View Options

	CREATE KEYSPACE image_recommendations WITH replication = {...};

	CREATE TYPE image_recommendations.metadata (
	confidence_rating float,
	source text,
	found_on set<text>,
	);

	CREATE TABLE image_recommendations.articles (
	wiki text,
	page_id int,
	dataset_id timeuuid,
	recommended_images map<text, frozen<metadata>>,
	PRIMARY KEY((wiki, page_id))
	);

	CREATE TABLE image_recommendations.candidates (
	wiki text,
	dataset_id timeuuid,
	idx int,
	page_id int,
	PRIMARY KEY((wiki, dataset_id), idx)
	);

	CREATE TABLE image_recommendations.candidate_count (
	wiki text,
	dataset_id timeuuid,
	count int,
	PRIMARY KEY((wiki, dataset_id))
	);