From ef75cf1b5e6f23f5ec039946ebaeb9e71ac864fc Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期二, 10 二月 2026 16:43:02 +0800
Subject: [PATCH] 生成缺勤记录
---
doc/20260209_create_personal_attendance_records.sql | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/doc/20260209_create_personal_attendance_records.sql b/doc/20260209_create_personal_attendance_records.sql
index 71b4565..0a25e18 100644
--- a/doc/20260209_create_personal_attendance_records.sql
+++ b/doc/20260209_create_personal_attendance_records.sql
@@ -13,5 +13,6 @@
tenant_id bigint not null comment '绉熸埛id',
create_time datetime null comment '褰曞叆鏃堕棿',
update_time datetime null comment '鏇存柊鏃堕棿',
- index idx_staff_on_job_id (staff_on_job_id)
+ index idx_staff_on_job_id (staff_on_job_id),
+ unique idx_staff_on_job_id_date (staff_on_job_id, date)
);
--
Gitblit v1.9.3