CREATE TABLE `tabs` (
	`id` text PRIMARY KEY NOT NULL,
	`branch_id` text NOT NULL,
	`pc_id` text NOT NULL,
	`session_id` text NOT NULL,
	`customer_id` text,
	`label` text,
	`amount` integer NOT NULL,
	`status` text DEFAULT 'open' NOT NULL,
	`settled_via` text,
	`shift_id` text,
	`created_at` integer NOT NULL,
	`settled_at` integer
);
--> statement-breakpoint
CREATE UNIQUE INDEX `tabs_session_uq` ON `tabs` (`session_id`);--> statement-breakpoint
CREATE INDEX `tabs_status_idx` ON `tabs` (`status`);