daiyongkang
76f266645d
含 Phase 1.1 IM seq 排序、断线重连、多端已读同步与微信式语音转文字 UI。 排除 node_modules、构建产物、安装包与 .env 密钥。 Co-authored-by: Cursor <cursoragent@cursor.com>
28 lines
1003 B
SQL
28 lines
1003 B
SQL
-- CreateTable
|
|
CREATE TABLE "LaborContract" (
|
|
"id" TEXT NOT NULL,
|
|
"tenantId" TEXT NOT NULL DEFAULT '1',
|
|
"employeeId" TEXT NOT NULL,
|
|
"contractNo" TEXT,
|
|
"startAt" TIMESTAMP(3),
|
|
"endAt" TIMESTAMP(3),
|
|
"remark" TEXT,
|
|
"createdById" TEXT,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "LaborContract_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "LaborContract_employeeId_idx" ON "LaborContract"("employeeId");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "LaborContract_tenantId_createdAt_idx" ON "LaborContract"("tenantId", "createdAt");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "LaborContract" ADD CONSTRAINT "LaborContract_employeeId_fkey" FOREIGN KEY ("employeeId") REFERENCES "Employee"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "LaborContract" ADD CONSTRAINT "LaborContract_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES "User"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|