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






 


