arifal
48 lines
1.7 KiB
SQL
48 lines
1.7 KiB
SQL
-- CreateEnum
|
|
CREATE TYPE "PayoutStatus" AS ENUM ('HELD', 'RELEASED', 'PAID', 'CANCELLED');
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "Payout" (
|
|
"id" TEXT NOT NULL,
|
|
"bookingId" TEXT NOT NULL,
|
|
"tripId" TEXT NOT NULL,
|
|
"organizerId" TEXT NOT NULL,
|
|
"amount" INTEGER NOT NULL,
|
|
"currency" TEXT NOT NULL DEFAULT 'IDR',
|
|
"status" "PayoutStatus" NOT NULL DEFAULT 'HELD',
|
|
"heldUntil" TIMESTAMP(3) NOT NULL,
|
|
"releasedAt" TIMESTAMP(3),
|
|
"paidAt" TIMESTAMP(3),
|
|
"cancelledAt" TIMESTAMP(3),
|
|
"bankName" TEXT,
|
|
"bankAccountNumber" TEXT,
|
|
"bankAccountName" TEXT,
|
|
"adminNote" TEXT,
|
|
"processedById" TEXT,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "Payout_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "Payout_bookingId_key" ON "Payout"("bookingId");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Payout_organizerId_status_idx" ON "Payout"("organizerId", "status");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Payout_status_heldUntil_idx" ON "Payout"("status", "heldUntil");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Payout" ADD CONSTRAINT "Payout_bookingId_fkey" FOREIGN KEY ("bookingId") REFERENCES "Booking"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Payout" ADD CONSTRAINT "Payout_tripId_fkey" FOREIGN KEY ("tripId") REFERENCES "Trip"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Payout" ADD CONSTRAINT "Payout_organizerId_fkey" FOREIGN KEY ("organizerId") REFERENCES "User"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Payout" ADD CONSTRAINT "Payout_processedById_fkey" FOREIGN KEY ("processedById") REFERENCES "User"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|