| 1 | CREATE TYPE "public"."expense_recipient_status" AS ENUM('pending', 'approved', 'rejected');--> statement-breakpoint |
| 2 | CREATE TABLE "expense_recipients" ( |
| 3 | "id" text PRIMARY KEY |
| 4 | "expense_id" text NOT NULL |
| 5 | "client_member_id" text NOT NULL |
| 6 | "status" "expense_recipient_status" DEFAULT |
| 7 | "reject_reason" text, |
| 8 | "responded_at" timestamp, |
| 9 | "created_at" timestamp DEFAULT |
| 10 | "updated_at" timestamp DEFAULT |
| 11 | CONSTRAINT "expense_recipients_expense_id_client_member_id_unique" UNIQUE |
| 12 | ); |
| 13 | --> statement-breakpoint |
| 14 | ALTER TABLE "expense_recipients" ADD |
| 15 | ALTER TABLE "expense_recipients" ADD |
| 16 | CREATE INDEX "expense_recipients_expense_id_idx" ON |