CREATE TABLE "sender_ids" (
	"id" serial PRIMARY KEY,
	"user_id" text NOT NULL,
	"sender_id" text NOT NULL,
	"purpose" text NOT NULL,
	"status" text DEFAULT 'pending' NOT NULL,
	"review_note" text,
	"reviewed_by" text,
	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
	"reviewed_at" timestamp with time zone
);
--> statement-breakpoint
CREATE UNIQUE INDEX "sender_ids_user_sender_idx" ON "sender_ids" ("user_id","sender_id");--> statement-breakpoint
CREATE INDEX "sender_ids_status_idx" ON "sender_ids" ("status");--> statement-breakpoint
ALTER TABLE "sender_ids" ADD CONSTRAINT "sender_ids_user_id_accounts_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "accounts"("user_id");