CREATE TABLE `references` ( `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL, `grocery_id` integer NOT NULL, `brand` text NOT NULL, `price` real, `unit` text, `quality_score` integer, FOREIGN KEY (`grocery_id`) REFERENCES `groceries`(`id`) ON UPDATE no action ON DELETE cascade );