freedakgmail
2968484d2d
- Money.tsx (2260行→54行): 拆分为 money/ 子目录4个组件, React.lazy二级分割 - AIAssistant.tsx (2038行→63行): 拆分为 ai-assistant/ 子目录6个组件, React.lazy二级分割 - xlsx改为动态导入, OvertimeTab从345KB降至12.7KB - api-services.ts: 请求参数 any→Record<string,unknown> - 移除前端3处console.log残留 - 后端console替换为pino logger - 前后端未使用import/变量清理 - Zod schema验证: termination/platform/special-status/work-process - 新增 leave.routes.ts, acceptance-test.routes.ts - UI组件: PageGuide, QueryError, Stepper
28 lines
1.0 KiB
SQL
28 lines
1.0 KiB
SQL
-- 验收测试表
|
|
CREATE TABLE IF NOT EXISTS "AcceptanceTest" (
|
|
"id" TEXT NOT NULL,
|
|
"orgId" TEXT NOT NULL,
|
|
"verifierName" TEXT NOT NULL,
|
|
"results" JSONB NOT NULL,
|
|
"remarks" JSONB NOT NULL,
|
|
"conclusionName" TEXT,
|
|
"conclusionDate" TEXT,
|
|
"conclusionResult" TEXT,
|
|
"conclusionIssues" TEXT,
|
|
"screenshots" JSONB,
|
|
"signature1" TEXT,
|
|
"signature2" TEXT,
|
|
"status" TEXT NOT NULL DEFAULT 'DRAFT',
|
|
"submittedAt" TIMESTAMP(3),
|
|
"createdBy" TEXT NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
CONSTRAINT "AcceptanceTest_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- 唯一约束：同一组织下验收人姓名唯一
|
|
CREATE UNIQUE INDEX IF NOT EXISTS "AcceptanceTest_orgId_verifierName_key" ON "AcceptanceTest"("orgId", "verifierName");
|
|
|
|
-- 索引
|
|
CREATE INDEX IF NOT EXISTS "AcceptanceTest_orgId_status_idx" ON "AcceptanceTest"("orgId", "status");
|