lukasandClaude Opus 5.5
edd34a00a7
A ready Order Item now gets the lowest-numbered free Pickup Box (or waits for one to free up), shown as "Pickup box N" on its status. The customer opens the box from their order and closes it again; closing marks the item picked up and hands the box to the next waiting item. On the order card the box button comes first, full width on mobile, with a padlock that lifts on open and snaps shut before the button collapses away. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
9 lines
507 B
SQL
9 lines
507 B
SQL
CREATE TABLE "pickup_boxes" (
|
|
"id" serial PRIMARY KEY NOT NULL,
|
|
"number" integer NOT NULL,
|
|
"is_open" boolean DEFAULT false NOT NULL,
|
|
CONSTRAINT "pickup_boxes_number_unique" UNIQUE("number")
|
|
);
|
|
--> statement-breakpoint
|
|
ALTER TABLE "order_items" ADD COLUMN "pickup_box_id" integer;--> statement-breakpoint
|
|
ALTER TABLE "order_items" ADD CONSTRAINT "order_items_pickup_box_id_pickup_boxes_id_fk" FOREIGN KEY ("pickup_box_id") REFERENCES "public"."pickup_boxes"("id") ON DELETE no action ON UPDATE no action; |