|
|
USE [zhengcaioa]
|
GO
|
|
|
ALTER TABLE [dbo].[wf_run_process] ADD [deelurl] [nvarchar](500) NULL;
|
GO
|
|
|
|
|
|
|
ALTER TABLE [dbo].[IntentionCustomer] ADD [Yixiangtime] [datetime] NULL;
|
GO
|
|
ALTER TABLE [dbo].[IntentionCustomer] ADD [Yixiang] [nvarchar](50) NULL;
|
GO
|
|
ALTER TABLE [dbo].[IntentionCustomer] ADD [dianxiaozhuanyuan] [nvarchar](50) NULL;
|
GO
|
|
ALTER TABLE [dbo].[IntentionCustomer] ADD [zuijinzhuizongtime] [datetime] NULL;
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USE [zhengcaioa]
|
GO
|
|
/****** Object: Table [dbo].[l_zhuanjiahuida] Script Date: 2021/6/27 12:38:30 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
IF EXISTS(Select 1 From Sysobjects Where Name='l_zhuanjiahuida') --²éѯ±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ
|
drop table [l_zhuanjiahuida]
|
GO
|
CREATE TABLE [dbo].[l_zhuanjiahuida](
|
[Id] [nvarchar](50) NOT NULL,
|
[userid] [nvarchar](50) NULL,
|
[username] [nvarchar](100) NULL,
|
[anwser] [nvarchar](4000) NULL,
|
[question] [nvarchar](500) NULL,
|
[huida_status] [nvarchar](1) 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_zhuanjiahuida] 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].[l_zhuanjiahuida] ADD DEFAULT ('A') FOR [rec_status]
|
GO
|
|
ALTER TABLE [dbo].[l_zhuanjiahuida] ADD DEFAULT ('1') FOR [creater]
|
GO
|
|
ALTER TABLE [dbo].[l_zhuanjiahuida] ADD CONSTRAINT [DF_l_zhuanjiahuida_createtime] DEFAULT (getdate()) FOR [createtime]
|
GO
|
|
ALTER TABLE [dbo].[l_zhuanjiahuida] ADD DEFAULT ('1') FOR [modifier]
|
GO
|
|
ALTER TABLE [dbo].[l_zhuanjiahuida] ADD CONSTRAINT [DF_l_zhuanjiahuida_modifytime] DEFAULT (getdate()) FOR [modifytime]
|
GO
|
ALTER TABLE [dbo].[l_zhuanjiahuida] ADD DEFAULT ('D') FOR [huida_status]
|
GO
|
|
|
|
|
|
|
|
|
|
|
USE [zhengcaioa]
|
GO
|
|
/****** Object: Table [dbo].[cus_fangwenjilu] Script Date: 2021/6/9 14:15:04 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
IF EXISTS(Select 1 From Sysobjects Where Name='cus_fangwenjilu') --²éѯ±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ
|
drop table [cus_fangwenjilu]
|
GO
|
|
CREATE TABLE [dbo].[cus_fangwenjilu](
|
[Id] [nvarchar](50) NOT NULL,
|
[fasongfangshi] [nvarchar](50) NULL,
|
[fasongneirong] [nvarchar](4000) NULL,
|
[jieshouren] [nvarchar](2000) 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_cus_fangwenjilu] 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].[cus_fangwenjilu] ADD DEFAULT ('A') FOR [rec_status]
|
GO
|
|
ALTER TABLE [dbo].[cus_fangwenjilu] ADD DEFAULT ('1') FOR [creater]
|
GO
|
|
ALTER TABLE [dbo].[cus_fangwenjilu] ADD DEFAULT (getdate()) FOR [createtime]
|
GO
|
|
ALTER TABLE [dbo].[cus_fangwenjilu] ADD DEFAULT ('1') FOR [modifier]
|
GO
|
|
ALTER TABLE [dbo].[cus_fangwenjilu] ADD DEFAULT (getdate()) FOR [modifytime]
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USE [zhengcaioa]
|
GO
|
|
/****** Object: Table [dbo].[hr_jixiaoticheng] Script Date: 2021/6/9 14:15:04 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
IF EXISTS(Select 1 From Sysobjects Where Name='hr_jixiaoticheng') --²éѯ±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ
|
drop table [hr_jixiaoticheng]
|
GO
|
|
CREATE TABLE [dbo].[hr_jixiaoticheng](
|
[Id] [nvarchar](50) NOT NULL,
|
[post_id] [nvarchar](50) NULL,
|
[piecerate_id] [nvarchar](50) NULL,
|
[tichengstandard] [nvarchar](50) NULL,
|
[renwustandard] [nvarchar](50) NULL,
|
|
[ticheng] [money] NULL,
|
[renwu] [money] NULL,
|
|
|
[effecttime] [datetime] 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_hr_jixiaoticheng] 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].[hr_jixiaoticheng] ADD DEFAULT ('A') FOR [rec_status]
|
GO
|
|
ALTER TABLE [dbo].[hr_jixiaoticheng] ADD DEFAULT ('1') FOR [creater]
|
GO
|
|
ALTER TABLE [dbo].[hr_jixiaoticheng] ADD DEFAULT (getdate()) FOR [createtime]
|
GO
|
|
ALTER TABLE [dbo].[hr_jixiaoticheng] ADD DEFAULT ('1') FOR [modifier]
|
GO
|
|
ALTER TABLE [dbo].[hr_jixiaoticheng] ADD DEFAULT (getdate()) FOR [modifytime]
|
GO
|
|
|
|
|
|
|
USE [zhengcaioa]
|
GO
|
|
/****** Object: Table [dbo].[hr_jibengongzi] Script Date: 2021/6/9 14:15:04 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
IF EXISTS(Select 1 From Sysobjects Where Name='hr_jibengongzi') --²éѯ±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ
|
drop table [hr_jibengongzi]
|
GO
|
|
CREATE TABLE [dbo].[hr_jibengongzi](
|
[Id] [nvarchar](50) NOT NULL,
|
[post_id] [nvarchar](50) NULL,
|
[jibengongzi] [money] NULL,
|
[baomifei] [money] NULL,
|
[shebaodanwei] [money] NULL,
|
[shebaogeren] [money] NULL,
|
[dianhuabutie] [nvarchar](50) NULL,
|
[quanqingjiang] [money] NULL,
|
[jiaotongbutie] [money] NULL,
|
|
[effecttime] [datetime] 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_hr_jibengongzi] 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].[hr_jibengongzi] ADD DEFAULT ('A') FOR [rec_status]
|
GO
|
|
ALTER TABLE [dbo].[hr_jibengongzi] ADD DEFAULT ('1') FOR [creater]
|
GO
|
|
ALTER TABLE [dbo].[hr_jibengongzi] ADD DEFAULT (getdate()) FOR [createtime]
|
GO
|
|
ALTER TABLE [dbo].[hr_jibengongzi] ADD DEFAULT ('1') FOR [modifier]
|
GO
|
|
ALTER TABLE [dbo].[hr_jibengongzi] ADD DEFAULT (getdate()) FOR [modifytime]
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
IF EXISTS(Select 1 From Sysobjects Where Name='ADM_AttendanceRules_dtl') --²éѯ±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ
|
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
|
IF EXISTS(Select 1 From Sysobjects Where Name='fi_account_record') --²éѯ±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ
|
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
|
IF EXISTS(Select 1 From Sysobjects Where Name='ADM_AskLeave') --²éѯ±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ
|
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
|
IF EXISTS(Select 1 From Sysobjects Where Name='ADM_AskLeaveOff') --²éѯ±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ
|
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
|
IF EXISTS(Select 1 From Sysobjects Where Name='ADM_AttendanceRules') --²éѯ±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ
|
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
|
|
|
|
|
|
|
|
