CREATE TABLE `payment_approvals` (
  `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  `cash_flow_id` integer NOT NULL REFERENCES `cash_flows`(`id`),
  `company_id` text NOT NULL REFERENCES `companies`(`id`),
  `requested_by` text NOT NULL,
  `requested_at` text NOT NULL,
  `status` text NOT NULL DEFAULT 'pending',
  `decided_by` text,
  `decided_at` text,
  `decision_note` text
);
--> statement-breakpoint
CREATE UNIQUE INDEX `payment_approvals_cash_flow_unique` ON `payment_approvals` (`cash_flow_id`);
--> statement-breakpoint
CREATE INDEX `idx_payment_approvals_company_status` ON `payment_approvals` (`company_id`,`status`,`requested_at`);
--> statement-breakpoint
PRAGMA optimize;