From 3262eb334953a1b208aa4a50584442a3804912d9 Mon Sep 17 00:00:00 2001
From: LR-20210131IOQH\Administrator <jackcold@163.com>
Date: 星期日, 27 六月 2021 13:09:43 +0800
Subject: [PATCH] Merge branch 'master' of http://47.108.235.38:8080/r/zhengcaioa
---
考勤计算的表.sql | 136 ++++++++++++++++++++++++++------------------
1 files changed, 80 insertions(+), 56 deletions(-)
diff --git "a/\350\200\203\345\213\244\350\256\241\347\256\227\347\232\204\350\241\250.sql" "b/\350\200\203\345\213\244\350\256\241\347\256\227\347\232\204\350\241\250.sql"
index 014e69f..06ed231 100644
--- "a/\350\200\203\345\213\244\350\256\241\347\256\227\347\232\204\350\241\250.sql"
+++ "b/\350\200\203\345\213\244\350\256\241\347\256\227\347\232\204\350\241\250.sql"
@@ -1,6 +1,86 @@
USE [zhengcaioa]
GO
+/****** Object: Table [dbo].[ADM_Attendance_dtl] Script Date: 2021/6/10 13:04:31 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+IF EXISTS(Select 1 From Sysobjects Where Name='ADM_Attendance_dtl') --查询表名costSeparateConfig是否存在
+drop TABLE [dbo].[ADM_Attendance_dtl]
+GO
+CREATE TABLE [dbo].[ADM_Attendance_dtl](
+ [Id] [nvarchar](50) NOT NULL,
+ [attendance_id] [nvarchar](50) NOT NULL,
+ [SgninDate] [datetime] NULL,
+ [MorningIn] [datetime] NULL,
+ [MorningOut] [datetime] NULL,
+ [AfternoonIn] [datetime] NULL,
+ [AfternoonOut] [datetime] NULL,
+ [OvertimeIn] [datetime] NULL,
+ [OvertimeOut] [datetime] NULL,
+ [qingjia] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [xiaojia] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [rec_status] [nvarchar](1) NOT NULL,
+ [creater] [nvarchar](50) NOT NULL,
+ [createtime] [datetime] NOT NULL,
+ [modifier] [nvarchar](50) NOT NULL,
+ [modifytime] [datetime] NOT NULL,
+ [shangwuchidaofenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [xiawuchidaofenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [shangwuzaotuifenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [xiawuzaotuifenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [kuanggongtianshu] [decimal](18, 4) NOT NULL DEFAULT ((0)),
+ [iswork] [nvarchar](1) NULL,
+ CONSTRAINT [PK__ADM_Attendance_dtl] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [SgninDate]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
/****** Object: Table [dbo].[hr_salary] Script Date: 2021/6/10 12:54:34 ******/
SET ANSI_NULLS ON
GO
@@ -142,62 +222,6 @@
-USE [zhengcaioa]
-GO
-
-/****** Object: Table [dbo].[ADM_Attendance_dtl] Script Date: 2021/6/10 13:04:31 ******/
-SET ANSI_NULLS ON
-GO
-
-SET QUOTED_IDENTIFIER ON
-GO
-IF EXISTS(Select 1 From Sysobjects Where Name='ADM_Attendance_dtl') --查询表名costSeparateConfig是否存在
-drop TABLE [dbo].[ADM_Attendance_dtl]
-GO
-CREATE TABLE [dbo].[ADM_Attendance_dtl](
- [Id] [nvarchar](50) NOT NULL,
- [attendance_id] [nvarchar](50) NOT NULL,
- [SgninDate] [datetime] NULL,
- [MorningIn] [datetime] NULL,
- [MorningOut] [datetime] NULL,
- [AfternoonIn] [datetime] NULL,
- [AfternoonOut] [datetime] NULL,
- [OvertimeIn] [datetime] NULL,
- [OvertimeOut] [datetime] NULL,
- [qingjia] [decimal](18, 4) NOT NULL DEFAULT ((0)),
- [xiaojia] [decimal](18, 4) NOT NULL DEFAULT ((0)),
- [rec_status] [nvarchar](1) NOT NULL,
- [creater] [nvarchar](50) NOT NULL,
- [createtime] [datetime] NOT NULL,
- [modifier] [nvarchar](50) NOT NULL,
- [modifytime] [datetime] NOT NULL,
- [chidaofenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
- [zaotuifenzhong] [decimal](18, 4) NOT NULL DEFAULT ((0)),
- [kuanggongtianshu] [decimal](18, 4) NOT NULL DEFAULT ((0)),
- CONSTRAINT [PK__ADM_Attendance_dtl] PRIMARY KEY CLUSTERED
-(
- [Id] ASC
-)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
-) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [SgninDate]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('A') FOR [rec_status]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('1') FOR [creater]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [createtime]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT ('1') FOR [modifier]
-GO
-
-ALTER TABLE [dbo].[ADM_Attendance_dtl] ADD DEFAULT (getdate()) FOR [modifytime]
-GO
--
Gitblit v1.9.1