USE [zhengcaioa]
|
GO
|
|
/****** Object: Table [dbo].[ADM_AttendanceRules_dtl] Script Date: 2021/6/9 14:15:04 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
drop table [ADM_AttendanceRules_dtl]
|
GO
|
|
CREATE TABLE [dbo].[ADM_AttendanceRules_dtl](
|
[Id] [nvarchar](50) NOT NULL,
|
[pid] [nvarchar](50) NULL,
|
[value_start] [datetime] NOT NULL,
|
[value_end] [datetime] NOT NULL,
|
[Name] [nvarchar](200) NULL,
|
[rec_status] [nvarchar](1) NOT NULL,
|
[creater] [nvarchar](50) NOT NULL,
|
[createtime] [datetime] NOT NULL,
|
[modifier] [nvarchar](50) NOT NULL,
|
[modifytime] [datetime] NOT NULL,
|
CONSTRAINT [PK_ADM_AttendanceRules_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) ON [PRIMARY]
|
) ON [PRIMARY]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT ('A') FOR [rec_status]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT ('1') FOR [creater]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT (getdate()) FOR [createtime]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT ('1') FOR [modifier]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT (getdate()) FOR [modifytime]
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USE [zhengcaioa]
|
GO
|
|
/****** Object: Table [dbo].[fi_account_record] Script Date: 2021/6/9 11:04:23 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
drop table [fi_account_record]
|
GO
|
|
CREATE TABLE [dbo].[fi_account_record](
|
[Id] [nvarchar](50) NOT NULL,
|
[SubjectId] [nvarchar](50) NULL,
|
[AccountId] [nvarchar](50) NULL,
|
[RecordTypeId] [nvarchar](50) NULL,
|
[Department] [nvarchar](100) NULL,
|
[Money] [money] NULL,
|
[AccountMoney] [money] NULL,
|
[PaymentUnit] [nvarchar](100) NULL,
|
[OperationalMatters] [nvarchar](500) NULL,
|
[Remark] [nvarchar](500) NULL,
|
[rec_status] [nvarchar](1) NOT NULL,
|
[creater] [nvarchar](50) NOT NULL,
|
[createtime] [datetime] NOT NULL,
|
[modifier] [nvarchar](50) NOT NULL,
|
[modifytime] [datetime] NOT NULL,
|
[qiyong_status] [nvarchar](1) NULL,
|
CONSTRAINT [PK_fi_account_record] PRIMARY KEY CLUSTERED
|
(
|
[Id] ASC
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
) ON [PRIMARY]
|
GO
|
|
ALTER TABLE [dbo].[fi_account_record] ADD CONSTRAINT [DF_fi_account_record_rec_status] DEFAULT ('A') FOR [rec_status]
|
GO
|
|
ALTER TABLE [dbo].[fi_account_record] ADD CONSTRAINT [DF_fi_account_record_creater] DEFAULT ('1') FOR [creater]
|
GO
|
|
ALTER TABLE [dbo].[fi_account_record] ADD CONSTRAINT [DF_fi_account_record_createtime] DEFAULT (getdate()) FOR [createtime]
|
GO
|
|
ALTER TABLE [dbo].[fi_account_record] ADD CONSTRAINT [DF_fi_account_record_modifier] DEFAULT ('1') FOR [modifier]
|
GO
|
|
ALTER TABLE [dbo].[fi_account_record] ADD CONSTRAINT [DF_fi_account_record_modifytime] DEFAULT (getdate()) FOR [modifytime]
|
GO
|
|
|
|
|
USE [zhengcaioa]
|
GO
|
|
|
/****** Object: Table [dbo].[ADM_AskLeave] Script Date: 2021/6/8 13:02:55 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
drop table [ADM_AskLeave]
|
GO
|
CREATE TABLE [dbo].[ADM_AskLeave](
|
[Id] [nvarchar](50) NOT NULL,
|
[SigninId] [nvarchar](50) NULL,
|
[Lavetype] [nvarchar](50) NULL,
|
[StratTime] [datetime] NULL,
|
[StratPoint] [nvarchar](50) NULL ,
|
[EndTime] [datetime] NULL,
|
[EndPoint] [nvarchar](50) NULL ,
|
[LaveDay] [int] NULL,
|
[LavehHour] [int] NULL,
|
[Remark] [nvarchar](500) NULL,
|
[shenpi_status] [nvarchar](1) NULL ,
|
[rec_status] [nvarchar](1) NOT NULL,
|
[creater] [nvarchar](50) NOT NULL,
|
[createtime] [datetime] NOT NULL,
|
[modifier] [nvarchar](50) NOT NULL,
|
[modifytime] [datetime] NOT NULL,
|
[createrName] [nvarchar](50) NULL,
|
[tittle] [nvarchar](100) NULL,
|
CONSTRAINT [PK__AskLeave__3214EC077AC5FA48] 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_AskLeave] ADD DEFAULT (getdate()) FOR [StratTime]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeave] ADD DEFAULT (getdate()) FOR [EndTime]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeave] ADD DEFAULT ((0)) FOR [LaveDay]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeave] ADD DEFAULT ((0)) FOR [LavehHour]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeave] ADD DEFAULT ('A') FOR [rec_status]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeave] ADD DEFAULT ('1') FOR [creater]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeave] ADD DEFAULT (getdate()) FOR [createtime]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeave] ADD DEFAULT ('1') FOR [modifier]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeave] ADD DEFAULT (getdate()) FOR [modifytime]
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USE [zhengcaioa]
|
GO
|
|
/****** Object: Table [dbo].[ADM_AskLeaveOff] Script Date: 2021/6/8 13:03:01 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
|
drop table [ADM_AskLeaveOff]
|
GO
|
|
CREATE TABLE [dbo].[ADM_AskLeaveOff](
|
[Id] [nvarchar](50) NOT NULL,
|
[SigninId] [nvarchar](50) NULL,
|
[Lavetype] [nvarchar](50) NULL,
|
[StratTime] [datetime] NULL,
|
[StratPoint] [nvarchar](50) NULL ,
|
[EndTime] [datetime] NULL,
|
[EndPoint] [nvarchar](50) NULL ,
|
[MedicalRecord ] [nvarchar](200) NULL,
|
[shenpi_status] [nvarchar](1) NULL ,
|
[Remark] [nvarchar](500) NULL,
|
[rec_status] [nvarchar](1) NOT NULL,
|
[creater] [nvarchar](50) NOT NULL,
|
[createtime] [datetime] NOT NULL,
|
[modifier] [nvarchar](50) NOT NULL,
|
[modifytime] [datetime] NOT NULL,
|
[createrName] [nvarchar](50) NULL,
|
[tittle] [nvarchar](100) NULL,
|
CONSTRAINT [PK__AskLeaveOff__3214EC077AC5FA48] 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_AskLeaveOff] ADD DEFAULT ('A') FOR [rec_status]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeaveOff] ADD DEFAULT ('1') FOR [creater]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeaveOff] ADD DEFAULT (getdate()) FOR [createtime]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeaveOff] ADD DEFAULT ('1') FOR [modifier]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AskLeaveOff] ADD DEFAULT (getdate()) FOR [modifytime]
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USE [zhengcaioa]
|
GO
|
|
|
|
/****** Object: Table [dbo].[ADM_AttendanceRules] Script Date: 2021/6/7 16:55:33 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
|
drop table [ADM_AttendanceRules]
|
GO
|
|
CREATE TABLE [dbo].[ADM_AttendanceRules](
|
[Id] [nvarchar](50) NOT NULL,
|
[week_start] [int] NOT NULL,
|
[week_end] [int] NOT NULL,
|
[working_start] [nvarchar](50) NULL,
|
[working_end] [nvarchar](50) NULL,
|
[offwork_start] [nvarchar](50) NOT NULL,
|
[offwork_end] [nvarchar](50) NOT NULL,
|
[full_attendance] [decimal](18, 2) NOT NULL,
|
[late_payment1] [decimal](18, 2) NOT NULL,
|
[late_payment2] [decimal](18, 2) NOT NULL,
|
[late_payment3] [decimal](18, 2) NOT NULL,
|
[late_payment4] [decimal](18, 2) NOT NULL,
|
[absenteeism] [decimal](18, 2) NOT NULL,
|
[absenteeism_payment1] [decimal](18, 2) NOT NULL,
|
[absenteeism_payment2] [decimal](18, 2) NOT NULL,
|
[personal_payment1] [decimal](18, 2) NOT NULL,
|
[personal_payment2] [decimal](18, 2) NOT NULL,
|
[personal_payment3] [decimal](18, 2) NOT NULL,
|
[personal_payment4] [decimal](18, 2) NOT NULL,
|
[sick_payment1] [decimal](18, 2) NOT NULL,
|
[sick_payment2] [decimal](18, 2) NOT NULL,
|
[sick_payment3] [decimal](18, 2) NOT NULL,
|
[sick_payment4] [decimal](18, 2) NOT NULL,
|
[holiday] [nvarchar](50) NOT NULL,
|
[Rest] [nvarchar](50) NOT NULL,
|
[gala] [int] NOT NULL,
|
[weekend] [int] NOT NULL,
|
[usually] [int] NOT NULL,
|
[rec_status] [nvarchar](1) NOT NULL,
|
[creater] [nvarchar](50) NOT NULL,
|
[createtime] [datetime] NOT NULL,
|
[modifier] [nvarchar](50) NOT NULL,
|
[modifytime] [datetime] NOT NULL,
|
CONSTRAINT [PK_ADM_AttendanceRules] PRIMARY KEY CLUSTERED
|
(
|
[Id] ASC
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
) ON [PRIMARY]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [week_start]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [week_end]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [full_attendance]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [late_payment1]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [late_payment2]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [late_payment3]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [late_payment4]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [absenteeism]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [absenteeism_payment1]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [absenteeism_payment2]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [personal_payment1]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [personal_payment2]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [personal_payment3]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [personal_payment4]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [sick_payment1]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [sick_payment2]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [sick_payment3]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [sick_payment4]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [gala]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [weekend]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ((0)) FOR [usually]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ('A') FOR [rec_status]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ('1') FOR [creater]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT (getdate()) FOR [createtime]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT ('1') FOR [modifier]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules] ADD DEFAULT (getdate()) FOR [modifytime]
|
GO
|
|
|
|
|
|
|
USE [zhengcaioa]
|
GO
|
|
/****** Object: Table [dbo].[ADM_AttendanceRules_dtl] Script Date: 2021/6/7 16:55:36 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
|
drop table [ADM_AttendanceRules_dtl]
|
GO
|
|
CREATE TABLE [dbo].[ADM_AttendanceRules_dtl](
|
[Id] [nvarchar](50) NOT NULL,
|
[pid] [nvarchar](50) NULL,
|
[value_start] [nvarchar](50) NULL,
|
[value_end] [nvarchar](50) NULL,
|
[Name] [nvarchar](200) NULL,
|
[rec_status] [nvarchar](1) NOT NULL,
|
[creater] [nvarchar](50) NOT NULL,
|
[createtime] [datetime] NOT NULL,
|
[modifier] [nvarchar](50) NOT NULL,
|
[modifytime] [datetime] NOT NULL,
|
CONSTRAINT [PK_ADM_AttendanceRules_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) ON [PRIMARY]
|
) ON [PRIMARY]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT ('A') FOR [rec_status]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT ('1') FOR [creater]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT (getdate()) FOR [createtime]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT ('1') FOR [modifier]
|
GO
|
|
ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT (getdate()) FOR [modifytime]
|
GO
|
