From 34e986e6e158450ee35319f1cac872a4bc974a74 Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期五, 16 一月 2026 18:02:41 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev_New' into dev_New

---
 doc/20260116_create_table_staff_contract.sql |   13 +++++++++++++
 1 files changed, 13 insertions(+), 0 deletions(-)

diff --git a/doc/20260116_create_table_staff_contract.sql b/doc/20260116_create_table_staff_contract.sql
new file mode 100644
index 0000000..f8fc20a
--- /dev/null
+++ b/doc/20260116_create_table_staff_contract.sql
@@ -0,0 +1,13 @@
+# 鍛樺伐鍚堝悓琛�
+drop table if exists staff_contract;
+create table staff_contract
+(
+    id                  bigint auto_increment primary key,
+    staff_on_job_id     bigint not null default 0 comment '鍛樺伐鍦ㄨ亴id',
+    contract_start_time datetime null comment '鍚堝悓寮�濮嬫椂闂�',
+    contract_end_time   datetime null comment '鍚堝悓缁撴潫鏃堕棿',
+    contract_term       int    not null default 0 comment '鍚堝悓鏈熼檺',
+    tenant_id           bigint not null comment '绉熸埛id',
+    create_time         datetime null comment '褰曞叆鏃堕棿',
+    update_time         datetime null comment '鏇存柊鏃堕棿'
+);

--
Gitblit v1.9.3