Paste P17599

schema.cql
ActivePublic
Actions

Authored by Eevans on Oct 25 2021, 7:44 PM.

Tags

None

Referenced Files

	F34738265: schema.cql
	Nov 8 2021, 7:39 PM

	F34722489: schema.cql
	Nov 1 2021, 7:12 PM

	F34722481: schema.cql
	Nov 1 2021, 7:10 PM

	F34722474: schema.cql
	Nov 1 2021, 7:06 PM

	F34722467: schema.cql
	Nov 1 2021, 7:00 PM

	F34710850: schema.cql
	Oct 25 2021, 7:44 PM

Subscribers

None

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

	-- Stores the metadata associated with an image recommendation.
	CREATE TYPE image_recommendations.metadata (
	confidence_rating float,
	source text,
	found_on set<text>,
	);

	-- The full data set; Recommendations for unillustrated articles.
	CREATE TABLE image_recommendations.articles (
	wiki text,
	page_id int,
	dataset_id timeuuid,
	recommended_images map<text, frozen<metadata>>,
	PRIMARY KEY((wiki, page_id))
	);

Event Timeline

Eevans created this paste.Oct 25 2021, 7:44 PM

Eevans mentioned this in T293808: Design Image Suggestion Schema.Oct 25 2021, 8:11 PM

Eevans edited the content of this paste. (Show Details)Nov 1 2021, 7:00 PM

Eevans edited the content of this paste. (Show Details)Nov 1 2021, 7:06 PM

Eevans edited the content of this paste. (Show Details)Nov 1 2021, 7:10 PM

Eevans edited the content of this paste. (Show Details)

Eevans edited the content of this paste. (Show Details)Nov 8 2021, 7:39 PM