f673f2c953
* feat: add db table and structure * chore: migration * createCreditNote * add check conditions quotationId before create credit note and add fn delete data * feat: add query list of credit note * feat: add get stats of credit ntoe * update * feat: add get by id * add permission * delete console log * chore: cleanup --------- Co-authored-by: Methapon2001 <61303214+Methapon2001@users.noreply.github.com> Co-authored-by: Kanjana <taii.kanjana@gmail.com>
45 lines
1.5 KiB
SQL
45 lines
1.5 KiB
SQL
-- AlterTable
|
|
ALTER TABLE "RequestWork" ADD COLUMN "creditNoteId" TEXT;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "_NotificationToNotificationGroup" ADD CONSTRAINT "_NotificationToNotificationGroup_AB_pkey" PRIMARY KEY ("A", "B");
|
|
|
|
-- DropIndex
|
|
DROP INDEX "_NotificationToNotificationGroup_AB_unique";
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "_NotificationToUser" ADD CONSTRAINT "_NotificationToUser_AB_pkey" PRIMARY KEY ("A", "B");
|
|
|
|
-- DropIndex
|
|
DROP INDEX "_NotificationToUser_AB_unique";
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "_UserToUserResponsibleArea" ADD CONSTRAINT "_UserToUserResponsibleArea_AB_pkey" PRIMARY KEY ("A", "B");
|
|
|
|
-- DropIndex
|
|
DROP INDEX "_UserToUserResponsibleArea_AB_unique";
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "CreditNote" (
|
|
"id" TEXT NOT NULL,
|
|
"quotationId" TEXT NOT NULL,
|
|
|
|
CONSTRAINT "CreditNote_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "DebitNote" (
|
|
"id" TEXT NOT NULL,
|
|
"quotationId" TEXT NOT NULL,
|
|
|
|
CONSTRAINT "DebitNote_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "RequestWork" ADD CONSTRAINT "RequestWork_creditNoteId_fkey" FOREIGN KEY ("creditNoteId") REFERENCES "CreditNote"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "CreditNote" ADD CONSTRAINT "CreditNote_quotationId_fkey" FOREIGN KEY ("quotationId") REFERENCES "Quotation"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "DebitNote" ADD CONSTRAINT "DebitNote_quotationId_fkey" FOREIGN KEY ("quotationId") REFERENCES "Quotation"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|