ThreadCount
0910bc32c1
Uniform stock management for healthcare linen rooms: the coordinator app, the phone counter and the staff app, for your own server. Built from 38e16eb on 2026-09-15. Licensed under the Functional Source License (FSL-1.1-ALv2).
25 lines
1.2 KiB
SQL
25 lines
1.2 KiB
SQL
-- The counter phone's per-line override reasons and signed slips. A flagged issue line carries the
|
|
-- reason it was issued anyway; a signed hand-over (issue or request) gets a Slip the staff app can show.
|
|
ALTER TABLE "Issue" ADD COLUMN "overrideReason" TEXT NOT NULL DEFAULT '';
|
|
ALTER TABLE "Issue" ADD COLUMN "slipId" TEXT;
|
|
CREATE INDEX "Issue_slipId_idx" ON "Issue"("slipId");
|
|
|
|
CREATE TABLE "Slip" (
|
|
"id" TEXT NOT NULL,
|
|
"facilityId" TEXT NOT NULL,
|
|
"staffId" TEXT NOT NULL,
|
|
"kind" TEXT NOT NULL,
|
|
"date" TEXT NOT NULL,
|
|
"sigId" TEXT,
|
|
"toStaff" BOOLEAN NOT NULL DEFAULT false,
|
|
"requestId" TEXT,
|
|
"lines" JSONB NOT NULL,
|
|
"byName" TEXT NOT NULL DEFAULT '',
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
CONSTRAINT "Slip_pkey" PRIMARY KEY ("id")
|
|
);
|
|
CREATE INDEX "Slip_facilityId_idx" ON "Slip"("facilityId");
|
|
CREATE INDEX "Slip_staffId_idx" ON "Slip"("staffId");
|
|
ALTER TABLE "Slip" ADD CONSTRAINT "Slip_facilityId_fkey" FOREIGN KEY ("facilityId") REFERENCES "Facility"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
ALTER TABLE "Slip" ADD CONSTRAINT "Slip_staffId_fkey" FOREIGN KEY ("staffId") REFERENCES "Staff"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|