ALTER TABLE "vendor_candidates" ADD COLUMN "tax_id" varchar(100) NOT NULL;--> statement-breakpoint
ALTER TABLE "vendor_candidates" ADD COLUMN "address" text;--> statement-breakpoint
ALTER TABLE "vendor_candidates" ADD COLUMN "remark" text;--> statement-breakpoint
ALTER TABLE "vendor_candidates" ADD COLUMN "items" text NOT NULL;--> statement-breakpoint
ALTER TABLE "vendor_candidates" ADD COLUMN "vendor_id" integer;--> statement-breakpoint
ALTER TABLE "vendor_candidates" ADD CONSTRAINT "vendor_candidates_vendor_id_vendors_id_fk" FOREIGN KEY ("vendor_id") REFERENCES "public"."vendors"("id") ON DELETE cascade ON UPDATE no action;