USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_AskJiaojie]    Script Date: 2021/8/26 8:56:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_AskJiaojie](
	[Id] [nvarchar](50) NOT NULL,
    [CiZhiId] [nvarchar](50)  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](50) NULL,
 CONSTRAINT [PK__AskJiaojie__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_AskJiaojie] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_AskJiaojie] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_AskJiaojie] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_AskJiaojie] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_AskJiaojie] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_AskJiaojie] ADD  DEFAULT (getdate()) FOR [modifytime]
GO




USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_AskJiaojieDtl]    Script Date: 2021/8/26 8:56:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_AskJiaojieDtl](
	[Id] [nvarchar](50) NOT NULL,
	[JiaojieId] [nvarchar](50)  NULL,

	
	[Jiaojietime] [datetime]   NULL,
	[JiaojieType] [nvarchar](50)  NULL,
	[Kehudanwei] [nvarchar](500) NULL,
	[JiaojieNeirong] [nvarchar](500) NULL,
	[JiaojieUserId] [nvarchar](50)  NULL,
	[JieShoutime] [datetime]   NULL,


	[jiaojie_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,
 CONSTRAINT [PK__AskJiaojieDtl__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_AskJiaojieDtl] ADD  DEFAULT ('D') FOR [jiaojie_status]
GO

ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD  DEFAULT (getdate()) FOR [modifytime]
GO



































































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_AskCiZhi]    Script Date: 2021/8/25 8:43:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_AskCiZhi](
	[Id] [nvarchar](50) NOT NULL,
	
	[OrderType] [nvarchar](50) NULL,
	
	
	[Remark] [nvarchar](2000) 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,
	[DeptName] [nvarchar](50) NULL,
	[PostName] [nvarchar](50) NULL,
	[CreatetimeName] [nvarchar](50) NULL,
	[RuzhitimeName] [nvarchar](50) NULL,
	[JiaojieUser] [nvarchar](500) NULL,
	[Outtime] [datetime]  NULL,
	[tittle] [nvarchar](50) NULL,
 CONSTRAINT [PK__AskCiZhi __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_AskCiZhi] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_AskCiZhi] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_AskCiZhi] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_AskCiZhi] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_AskCiZhi] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_AskCiZhi] ADD  DEFAULT (getdate()) FOR [modifytime]
GO























































































USE [zhengcaioa]
GO

ALTER TABLE [dbo].[adm_goods_manage] ADD  [haocai_status] [nvarchar](1)  DEFAULT ('D')
GO


update  [adm_goods_manage] set [haocai_status]='D'
GO





























































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_Customer_withdrawal]    Script Date: 2021/8/9 13:43:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_Customer_withdrawal](
	[Id] [nvarchar](50) NOT NULL,
	[OrderNo] [nvarchar](50) NULL,
	[Jine] [money] NULL,
	[HuiyuanName] [nvarchar](100) NULL,
	[HuiyuanId] [nvarchar](50) NULL,
	[HuiyuanPhone] [nvarchar](50) NULL,

		[BankAcount] [nvarchar](50) NULL,
			[BankName] [nvarchar](50) NULL,
				[Username] [nvarchar](50) NULL,



	[Shenqingtime] [datetime] NOT 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](50) NULL,
 CONSTRAINT [PK__Customer_withdrawal__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_Customer_withdrawal] ADD  DEFAULT ((0)) FOR [Jine]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT (getdate()) FOR [Shenqingtime]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT (getdate()) FOR [modifytime]
GO
























USE [zhengcaioa]
GO


ALTER TABLE [Liaotian] ALTER COLUMN [shiyongfatiao] [nvarchar](1000) NULL
GO



ALTER TABLE [dbo].[Project] ADD  [caigouyusuan] [money] NULL
GO









































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_Customer_withdrawal]    Script Date: 2021/8/3 9:08:32 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_Customer_withdrawal](
	[Id] [nvarchar](50) NOT NULL,
	[OrderNo] [nvarchar](50) NULL,
	[Jine] [money] NULL,
	[HuiyuanName] [nvarchar](100) NULL,
	[HuiyuanId] [nvarchar](50) NULL,
	[HuiyuanPhone] [nvarchar](50) NULL,
	[Shenqingtime] [datetime] NOT 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](50) NULL,
 CONSTRAINT [PK__Customer_withdrawal__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_Customer_withdrawal] ADD  DEFAULT ((0)) FOR [Jine]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT (getdate()) FOR [modifytime]
GO
ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD  DEFAULT (getdate()) FOR [Shenqingtime]
GO






 



































































































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_AskBaiFang]    Script Date: 2021/7/30 9:03:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_AskBaiFang](
	[Id] [nvarchar](50) NOT NULL,

	[CustomerId] [nvarchar](50) NULL,
	[VisType] [nvarchar](50) NULL,
	[Jtype] [nvarchar](50) NULL,
	[BaiFangtime] [datetime]  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](50) NULL,
 CONSTRAINT [PK__AskBaiFang __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_AskBaiFang] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_AskBaiFang] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_AskBaiFang] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_AskBaiFang] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_AskBaiFang] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_AskBaiFang] ADD  DEFAULT (getdate()) FOR [modifytime]
GO



























































































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_AskYouHui]    Script Date: 2021/7/30 9:03:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_AskYouHui](
	[Id] [nvarchar](50) NOT NULL,
	[CustomerId] [nvarchar](50) NULL,
	[OrderType] [nvarchar](50) NULL,
	[Youhuistandard] [nvarchar](50) NULL,
	[YouHui] [money] 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](50) NULL,
 CONSTRAINT [PK__AskYouHui __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_AskYouHui] ADD  DEFAULT ((0)) FOR [YouHui]
GO

ALTER TABLE [dbo].[ADM_AskYouHui] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_AskYouHui] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_AskYouHui] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_AskYouHui] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_AskYouHui] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_AskYouHui] ADD  DEFAULT (getdate()) FOR [modifytime]
GO





































































































USE [zhengcaioa]
GO


ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD  [break_precedentId] [nvarchar](50)  NULL;
GO









USE [zhengcaioa]
GO


ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD  [ToUserId] [nvarchar](50)  NULL;
GO
























































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_AskMarketingCost]    Script Date: 2021/7/28 8:39:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_AskMarketingCost](
	[Id] [nvarchar](50) NOT NULL,
	[Feiyong] [money] 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](50) NULL,
 CONSTRAINT [PK__AskMarketingCost __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_AskMarketingCost] ADD  DEFAULT ((0)) FOR [Feiyong]
GO

ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD  DEFAULT (getdate()) FOR [modifytime]
GO




























































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_AskCar]    Script Date: 2021/7/28 8:39:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_AskCar](
	[Id] [nvarchar](50) NOT NULL,
	[CarLaiyuan] [nvarchar](50) NULL,
	[Feiyong] [money] 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](50) NULL,
 CONSTRAINT [PK__AskCar__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_AskCar] ADD  DEFAULT ((0)) FOR [Feiyong]
GO

ALTER TABLE [dbo].[ADM_AskCar] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_AskCar] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_AskCar] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_AskCar] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_AskCar] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_AskCar] ADD  DEFAULT (getdate()) FOR [modifytime]
GO


























































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_Askovertime]    Script Date: 2021/7/26 8:55:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_Askovertime](
	[Id] [nvarchar](50) NOT NULL,
	[overtime] [money] NULL,
	[jiabantime] [datetime]  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](50) NULL,
 CONSTRAINT [PK__Askovertime__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_Askovertime] ADD  DEFAULT ((0)) FOR [overtime]
GO

ALTER TABLE [dbo].[ADM_Askovertime] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_Askovertime] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_Askovertime] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_Askovertime] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_Askovertime] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_Askovertime] ADD  DEFAULT (getdate()) FOR [modifytime]
GO





















































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_AskGoods]    Script Date: 2021/7/23 8:54:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_AskGoods](
	[Id] [nvarchar](50) NOT NULL,
    [GoodsId] [nvarchar](50)   NULL,
	[Shuliang] [money] 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](50) NULL,
 CONSTRAINT [PK__AskGoods__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_AskGoods] ADD  DEFAULT ((0)) FOR [Shuliang]
GO
ALTER TABLE [dbo].[ADM_AskGoods] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_AskGoods] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_AskGoods] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_AskGoods] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_AskGoods] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_AskGoods] ADD  DEFAULT (getdate()) FOR [modifytime]
GO











































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[ADM_Askcost]    Script Date: 2021/7/23 8:54:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ADM_Askcost](
	[Id] [nvarchar](50) NOT NULL,
 
	[Cost] [money] 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](50) NULL,
 CONSTRAINT [PK__Askcost__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_Askcost] ADD  DEFAULT ((0)) FOR [Cost]
GO
ALTER TABLE [dbo].[ADM_Askcost] ADD  DEFAULT ('D') FOR [shenpi_status]
GO

ALTER TABLE [dbo].[ADM_Askcost] ADD  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[ADM_Askcost] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[ADM_Askcost] ADD  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[ADM_Askcost] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[ADM_Askcost] ADD  DEFAULT (getdate()) FOR [modifytime]
GO


















































USE [zhengcaioa]
GO
ALTER TABLE [dbo].[plt_user] ADD  [yaoqingma] [nvarchar](50)   NULL

GO


















USE [zhengcaioa]
GO

ALTER TABLE [dbo].[CooperatecustomCustomer] ADD  [weixiner] [nvarchar](50)   NULL

GO
 ALTER TABLE [dbo].[CooperatecustomCustomer] ADD  [weixintime] [datetime]   NULL

GO


 ALTER TABLE [dbo].[Liaotian] ADD  [shenhetime] [datetime]   NULL

GO
ALTER TABLE [dbo].[Liaotian] ADD  [shenheer] [nvarchar](50)   NULL

GO


ALTER TABLE [dbo].[adm_piece_check] ADD  [shuliang] [money] NULL

GO


USE [zhengcaioa]
GO

ALTER TABLE [dbo].[IntentionCustomer] ADD  [weixiner] [nvarchar](50)   NULL

GO
 ALTER TABLE [dbo].[IntentionCustomer] ADD  [weixintime] [datetime]   NULL

GO




 
















USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[sys_updatetime]    Script Date: 2021/7/13 14:21:26 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[sys_updatetime](
	[Id] [nvarchar](50) NOT NULL,
	[updatename] [nvarchar](100) NOT NULL,
	[updatetime] [datetime] NOT NULL,
 CONSTRAINT [PK_sys_updatetime] 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

 





























USE [zhengcaioa]
GO

ALTER TABLE [dbo].[CooperatecustomCustomer] ADD  [huiyuanId] [nvarchar](50) NULL

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»áÔ±Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CooperatecustomCustomer', @level2type=N'COLUMN',@level2name=N'huiyuanId'
GO

























































USE [zhengcaioa]
GO

ALTER TABLE [dbo].[CooperOrder] ADD  [songhuo_gongsi] [nvarchar](100) NULL
GO
ALTER TABLE [dbo].[CooperOrder] ADD  [songhuo_danhao] [nvarchar](100) NULL
GO

ALTER TABLE [dbo].[CooperOrder] ADD  [songhuo_time] [datetime] NULL
GO



ALTER TABLE [dbo].[CooperOrder] ADD  [huifang_jdr] [nvarchar](100) NULL
GO


ALTER TABLE [dbo].[CooperOrder] ADD  [huifang_kehuyijian] [nvarchar](500) NULL
GO














































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[Liaotian_shoucang]    Script Date: 2021/7/8 8:49:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Liaotian_shoucang](
	[Id] [nvarchar](50) NOT NULL,
	[Liaotian_id] [nvarchar](50)  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_Liaotian_shoucang] 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].[Liaotian_shoucang] ADD  DEFAULT ('a') FOR [rec_status]
GO

ALTER TABLE [dbo].[Liaotian_shoucang] ADD  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[Liaotian_shoucang] ADD  CONSTRAINT [DF_Liaotian_shoucang_createtime]  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[Liaotian_shoucang] ADD  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[Liaotian_shoucang] ADD  CONSTRAINT [DF_Liaotian_shoucang_modifytime]  DEFAULT (getdate()) FOR [modifytime]
GO

 





ALTER TABLE [dbo].[Liaotian] ADD  [chushu_status] [nvarchar](1)   NULL DEFAULT ('D')
GO

update  [dbo].[Liaotian]  set  [chushu_status] = 'D'
GO























































USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[order_banci_order]    Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
IF EXISTS(Select 1 From Sysobjects Where Name='order_banci_order')  --²éÑ¯±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ  
drop table  [order_banci_order] 
GO
CREATE TABLE [dbo].[order_banci_order](
	[Id] [nvarchar](50) NOT NULL,
	[baomingtime] [datetime] NOT NULL,
	[banci_id] [nvarchar](50)  NULL,
	[peixunbanci] [nvarchar](100)  NULL,
	[kechengleixing_id] [nvarchar](50) NULL,
	[kechengleixing] [nvarchar](100) NULL,
	[person_id] [nvarchar](100)  NULL,
	[xingming] [nvarchar](100)  NULL,
	[lianxidianhua] [nvarchar](100)  NULL,
	[shenfenzheng] [nvarchar](100)  NULL,
	[xuefei] [money] NULL,
	[baomingrenshu] [int] NULL,
	[jine] [money] 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_order_banci_order] 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].[order_banci_order] ADD  CONSTRAINT [DF_order_banci_order_rec_status]  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[order_banci_order] ADD  CONSTRAINT [DF_order_banci_order_creater]  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[order_banci_order] ADD  CONSTRAINT [DF_order_banci_order_createtime]  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[order_banci_order] ADD  CONSTRAINT [DF_order_banci_order_modifier]  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[order_banci_order] ADD  CONSTRAINT [DF_order_banci_order_modifytime]  DEFAULT (getdate()) FOR [modifytime]
GO







USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[order_banci]    Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
IF EXISTS(Select 1 From Sysobjects Where Name='order_banci')  --²éÑ¯±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ  
drop table  [order_banci] 
GO
CREATE TABLE [dbo].[order_banci](
	[Id] [nvarchar](50) NOT NULL,
	[banci] [nvarchar](100)  NULL,
	[mingcheng] [nvarchar](100)  NULL,
	[shijian] [datetime]   NULL,
	[shijianend] [datetime]   NULL,
	[didian] [nvarchar](500) NULL,
	[renshu] [int]  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_order_banci] 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].[order_banci] ADD  CONSTRAINT [DF_order_banci_rec_status]  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[order_banci] ADD  CONSTRAINT [DF_order_banci_creater]  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[order_banci] ADD  CONSTRAINT [DF_order_banci_createtime]  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[order_banci] ADD  CONSTRAINT [DF_order_banci_modifier]  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[order_banci] ADD  CONSTRAINT [DF_order_banci_modifytime]  DEFAULT (getdate()) FOR [modifytime]
GO



USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[order_banci_dtl]    Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
IF EXISTS(Select 1 From Sysobjects Where Name='order_banci_dtl')  --²éÑ¯±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ  
drop table  [order_banci_dtl] 
GO
CREATE TABLE [dbo].[order_banci_dtl](
	[Id] [nvarchar](50) NOT NULL,
	[order_banci_id] [nvarchar](50)   NULL,
	[shangxiawu] [nvarchar](100)  NULL,
	[shijian] [nvarchar](100)  NULL,
	[shixiamg] [nvarchar](500) NULL,
	[zhujiangren] [nvarchar](100)  NULL,
	[sort] [int]  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_order_banci_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].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_order_sort]  DEFAULT (0) FOR [sort]
GO
ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_dtl_rec_status]  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_dtl_creater]  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_dtl_createtime]  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_dtl_modifier]  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[order_banci_dtl] ADD  CONSTRAINT [DF_order_banci_dtl_modifytime]  DEFAULT (getdate()) FOR [modifytime]
GO













USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[IntentionVisit_duanxin]    Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
IF EXISTS(Select 1 From Sysobjects Where Name='IntentionVisit_duanxin')  --²éÑ¯±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ  
drop table  [IntentionVisit_duanxin] 
GO
CREATE TABLE [dbo].[IntentionVisit_duanxin](
	[Id] [nvarchar](50) NOT NULL,
	[duanxin_title] [nvarchar](50) NULL,
	[duanxin_neirong] [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,
 CONSTRAINT [PK_IntentionVisit_duanxin] 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].[IntentionVisit_duanxin] ADD  CONSTRAINT [DF_IntentionVisit_duanxin_rec_status]  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD  CONSTRAINT [DF_IntentionVisit_duanxin_creater]  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD  CONSTRAINT [DF_IntentionVisit_duanxin_createtime]  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD  CONSTRAINT [DF_IntentionVisit_duanxin_modifier]  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD  CONSTRAINT [DF_IntentionVisit_duanxin_modifytime]  DEFAULT (getdate()) FOR [modifytime]
GO

 


 ALTER TABLE [dbo].[IntentionVisit] ADD [duanxin_neirong] [nvarchar](500) NULL
GO













USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[fi_member]    Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
IF EXISTS(Select 1 From Sysobjects Where Name='fi_member')  --²éÑ¯±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ  
drop table  [fi_member] 
GO
CREATE TABLE [dbo].[fi_member](
	[Id] [nvarchar](50) NOT NULL,
	[member_type] [nvarchar](50) NULL,
	[member_authority] [nvarchar](500) NULL,
	[huifei] [money] 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_fi_member] 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_member] ADD  CONSTRAINT [DF_fi_member_rec_status]  DEFAULT ('A') FOR [rec_status]
GO

ALTER TABLE [dbo].[fi_member] ADD  CONSTRAINT [DF_fi_member_creater]  DEFAULT ('1') FOR [creater]
GO

ALTER TABLE [dbo].[fi_member] ADD  CONSTRAINT [DF_fi_member_createtime]  DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[fi_member] ADD  CONSTRAINT [DF_fi_member_modifier]  DEFAULT ('1') FOR [modifier]
GO

ALTER TABLE [dbo].[fi_member] ADD  CONSTRAINT [DF_fi_member_modifytime]  DEFAULT (getdate()) FOR [modifytime]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»áÔ±ÀàÐÍ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'fi_member', @level2type=N'COLUMN',@level2name=N'member_type'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»áÔ±È¨ÏÞ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'fi_member', @level2type=N'COLUMN',@level2name=N'member_authority'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»á·Ñ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'fi_member', @level2type=N'COLUMN',@level2name=N'huifei'
GO





ALTER TABLE [dbo].[CooperatecustomCustomer] ADD [weixin] [nvarchar](50) NULL;
GO


ALTER TABLE [dbo].[CooperatecustomCustomer] ADD [shifoutianjiaweixin] [nvarchar](1)   NULL;
GO


update  [CooperatecustomCustomer] set [shifoutianjiaweixin]='D'

GO




ALTER TABLE [dbo].[IntentionCustomer] ADD [weixin] [nvarchar](50) NULL;
GO


ALTER TABLE [dbo].[IntentionCustomer] ADD [shifoutianjiaweixin] [nvarchar](1)   NULL;
GO


update  [IntentionCustomer] set [shifoutianjiaweixin]='D'

GO




USE [zhengcaioa]
GO
delete from  [dbo].[fi_books]
GO
INSERT [dbo].[fi_books] ([Id], [book_no], [book_name], [chubanshe], [chubantime], [danjia], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'b7b78ceb-d3d5-484a-bfd3-12118ce7d8ac', N'1001', N'¡¶ËÄ´¨Ê¡Õþ¸®²É¹ºÕþ²ßÎÄ¼þ»ã±à¡·', NULL, NULL, 98.0000, N'A', N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:02:12.253' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:20:26.563' AS DateTime))
INSERT [dbo].[fi_books] ([Id], [book_no], [book_name], [chubanshe], [chubantime], [danjia], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'b7b78ceb-d3d5-484a-bfd3-12118ce7d8ad', N'2001', N'¡¶3ÌìÑ§»áÕþ¸®²É¹º¡·', NULL, NULL, 49.0000, N'A', N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:02:12.253' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:20:32.160' AS DateTime))
INSERT [dbo].[fi_books] ([Id], [book_no], [book_name], [chubanshe], [chubantime], [danjia], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'b7b78ceb-d3d5-484a-bfd3-12118ce7d8ae', N'2002', N'¡¶2022ÄêÕþ¸®²É¹º100´óµäÐÍÍ¶Ëß°¸Àý ¡·', NULL, NULL, 88.0000, N'A', N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:02:12.253' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:20:34.183' AS DateTime))
GO
delete from  [dbo].[fi_member]
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'0d513d92-41fd-e33f-a55f-47780e03d26d', N'AA1»áÔ±', N'Ð¡²ÉÎÊ´ð¡¢Õþ²É¿ÎÌÃ¡¢ÎÊÌâ×ÉÑ¯£¨µç»°×ÉÑ¯¡¢µ±Ãæ×ÉÑ¯£©¡¢±êÊéÖÆ×÷3¼þ¡¢×îÐÂÕþ²ÉÍ¼Êé£¨¡¶ËÄ´¨Ê¡Õþ¸®²É¹ºÕþ²ßÎÄ¼þ»ã±à¡·¡¢¡¶3ÌìÑ§»áÕþ¸®²É¹º¡·¡¢¡¶2022ÄêÕþ¸®²É¹º100´óµäÐÍÍ¶Ëß°¸Àý ¡·£©¡¢ÆäËûÒµÎñ8ÕÛ', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:10.103' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.730' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'1dcfd55f-b172-855e-bcad-a83869d200b1', N'AAA2»áÔ±', N'Ð¡²ÉÎÊ´ð¡¢Õþ²É¿ÎÌÃ¡¢ÎÊÌâ×ÉÑ¯£¨µç»°×ÉÑ¯¡¢µ±Ãæ×ÉÑ¯£©¡¢ÖÊÒÉÍ¶Ëß6¼þ¡¢ÂÄÔ¼¾À·×5¼þ¡¢×îÐÂÕþ²ÉÍ¼Êé£¨¡¶ËÄ´¨Ê¡Õþ¸®²É¹ºÕþ²ßÎÄ¼þ»ã±à¡·¡¢¡¶3ÌìÑ§»áÕþ¸®²É¹º¡·¡¢¡¶2022ÄêÕþ¸®²É¹º100´óµäÐÍÍ¶Ëß°¸Àý ¡·£©¡¢ÆäËûÒµÎñ6ÕÛ', 50000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:29.513' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.737' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'2ab09dee-6244-e410-fcc9-36dd6152851c', N'AA2»áÔ±', N'Ð¡²ÉÎÊ´ð¡¢Õþ²É¿ÎÌÃ¡¢ÎÊÌâ×ÉÑ¯£¨µç»°×ÉÑ¯¡¢µ±Ãæ×ÉÑ¯£©¡¢±êÊéÖÆ×÷5¼þ¡¢×îÐÂÕþ²ÉÍ¼Êé£¨¡¶ËÄ´¨Ê¡Õþ¸®²É¹ºÕþ²ßÎÄ¼þ»ã±à¡·¡¢¡¶3ÌìÑ§»áÕþ¸®²É¹º¡·¡¢¡¶2022ÄêÕþ¸®²É¹º100´óµäÐÍÍ¶Ëß°¸Àý ¡·£©¡¢ÆäËûÒµÎñ8ÕÛ', 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:13.670' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.730' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'34166043-a10f-7767-9b6c-5774dfa39c43', N'ÆÕÍ¨»áÔ±1', N'Ð¡²ÉÎÊ´ð', 98.0000, N'A', N'1', CAST(N'2021-05-28T10:45:20.293' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.653' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'34166043-a10f-7767-9b6c-5774dfa39c44', N'ÆÕÍ¨»áÔ±2', N'Õþ²É¿ÎÌÃ', 398.0000, N'A', N'1', CAST(N'2021-05-28T10:45:20.297' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.723' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'34166043-a10f-7767-9b6c-5774dfa39c45', N'ÆÕÍ¨»áÔ±3', N'Ð¡²ÉÎÊ´ð¡¢Õþ²É¿ÎÌÃ', 498.0000, N'A', N'1', CAST(N'2021-05-28T10:45:20.300' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.727' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'34166043-a10f-7767-9b6c-5774dfa39c46', N'ÆÕÍ¨»áÔ±4', N'Ð¡²ÉÎÊ´ð¡¢Õþ²É¿ÎÌÃ¡¢ÎÊÌâ×ÉÑ¯£¨µç»°×ÉÑ¯¡¢µ±Ãæ×ÉÑ¯£©¡¢×îÐÂÕþ²ÉÍ¼Êé£¨¡¶ËÄ´¨Ê¡Õþ¸®²É¹ºÕþ²ßÎÄ¼þ»ã±à¡·¡¢¡¶3ÌìÑ§»áÕþ¸®²É¹º¡·¡¢¡¶2022ÄêÕþ¸®²É¹º100´óµäÐÍÍ¶Ëß°¸Àý ¡·£©', 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:45:20.400' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.727' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'c9c8068f-7630-e5ee-eebc-71e6e63cdfab', N'A1»áÔ±', N'Ð¡²ÉÎÊ´ð¡¢Õþ²É¿ÎÌÃ¡¢ÎÊÌâ×ÉÑ¯£¨µç»°×ÉÑ¯¡¢µ±Ãæ×ÉÑ¯£©¡¢±êÊéÖÆ×÷1¼þ¡¢×îÐÂÕþ²ÉÍ¼Êé£¨¡¶ËÄ´¨Ê¡Õþ¸®²É¹ºÕþ²ßÎÄ¼þ»ã±à¡·¡¢¡¶3ÌìÑ§»áÕþ¸®²É¹º¡·¡¢¡¶2022ÄêÕþ¸®²É¹º100´óµäÐÍÍ¶Ëß°¸Àý ¡·£©', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:45:56.243' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.727' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'd0e3abf0-8f22-5291-d605-c95cbb7ed53c', N'AA4»áÔ±', N'Ð¡²ÉÎÊ´ð¡¢Õþ²É¿ÎÌÃ¡¢ÎÊÌâ×ÉÑ¯£¨µç»°×ÉÑ¯¡¢µ±Ãæ×ÉÑ¯£©¡¢±êÊéÖÆ×÷10¸öÏîÄ¿¡¢×îÐÂÕþ²ÉÍ¼Êé£¨¡¶ËÄ´¨Ê¡Õþ¸®²É¹ºÕþ²ßÎÄ¼þ»ã±à¡·¡¢¡¶3ÌìÑ§»áÕþ¸®²É¹º¡·¡¢¡¶2022ÄêÕþ¸®²É¹º100´óµäÐÍÍ¶Ëß°¸Àý ¡·£©¡¢ÆäËûÒµÎñ8ÕÛ', 30000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:20.487' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.733' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'e7238216-3448-83d9-798c-ba71a3da6424', N'AA3»áÔ±', N'Ð¡²ÉÎÊ´ð¡¢Õþ²É¿ÎÌÃ¡¢ÎÊÌâ×ÉÑ¯£¨µç»°×ÉÑ¯¡¢µ±Ãæ×ÉÑ¯£©¡¢ÖÊÒÉÍ¶Ëß5¼þ¡¢×îÐÂÕþ²ÉÍ¼Êé£¨¡¶ËÄ´¨Ê¡Õþ¸®²É¹ºÕþ²ßÎÄ¼þ»ã±à¡·¡¢¡¶3ÌìÑ§»áÕþ¸®²É¹º¡·¡¢¡¶2022ÄêÕþ¸®²É¹º100´óµäÐÍÍ¶Ëß°¸Àý ¡·£©¡¢ÆäËûÒµÎñ8ÕÛ', 30000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:16.823' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.733' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'eeb9c016-e265-aa9d-e56f-498387f7a7fe', N'AAA1»áÔ±', N'Ð¡²ÉÎÊ´ð¡¢Õþ²É¿ÎÌÃ¡¢ÎÊÌâ×ÉÑ¯£¨µç»°×ÉÑ¯¡¢µ±Ãæ×ÉÑ¯£©¡¢±êÊéÖÆ×÷10¸öÏîÄ¿¡¢ÖÊÒÉÍ¶Ëß5¼þ¡¢×îÐÂÕþ²ÉÍ¼Êé£¨¡¶ËÄ´¨Ê¡Õþ¸®²É¹ºÕþ²ßÎÄ¼þ»ã±à¡·¡¢¡¶3ÌìÑ§»áÕþ¸®²É¹º¡·¡¢¡¶2022ÄêÕþ¸®²É¹º100´óµäÐÍÍ¶Ëß°¸Àý ¡·£©¡¢ÆäËûÒµÎñ6ÕÛ', 50000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:25.980' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.733' AS DateTime))
INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'fab8d7f7-f807-9d10-8d99-0f8f16dce2d1', N'A2»áÔ±', N'Ð¡²ÉÎÊ´ð¡¢Õþ²É¿ÎÌÃ¡¢ÎÊÌâ×ÉÑ¯£¨µç»°×ÉÑ¯¡¢µ±Ãæ×ÉÑ¯£©¡¢ÖÊÒÉÍ¶Ëß1¼þ¡¢×îÐÂÕþ²ÉÍ¼Êé£¨¡¶ËÄ´¨Ê¡Õþ¸®²É¹ºÕþ²ßÎÄ¼þ»ã±à¡·¡¢¡¶3ÌìÑ§»áÕþ¸®²É¹º¡·¡¢¡¶2022ÄêÕþ¸®²É¹º100´óµäÐÍÍ¶Ëß°¸Àý ¡·£©', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:06.653' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.730' AS DateTime))
GO
delete from  [dbo].[fi_service]
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'01204ed4-c825-2f6e-d19a-870683c12e56', N'±êÊéÖ¸µ¼', N'200-500ÍòÔª', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:54.090' AS DateTime), N'1', CAST(N'2021-05-28T10:52:54.090' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'0bbc9d36-3827-29b2-bbc2-96a1dce615e9', N'¾ºÕù¶ÔÊÖºÍÆÀÉó×¨¼Ò²Î¼ÓÕþ¸®²É¹ºÊý¾ÝÐÅÏ¢²éÑ¯', NULL, 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:20.923' AS DateTime), N'1', CAST(N'2021-05-28T10:54:20.923' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'0c9559cc-2feb-4f01-4446-91568194538d', N'²»¾ß±¸Ìõ¼þ', NULL, 50000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:15.643' AS DateTime), N'1', CAST(N'2021-05-28T11:06:15.643' AS DateTime), N'06')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'1565b317-e3e7-65eb-abbb-0607b1f2d28e', N'±êÊéÖ¸µ¼', N'30-200ÍòÔª', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:51.117' AS DateTime), N'1', CAST(N'2021-05-28T10:52:51.117' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'1650e01e-dace-5036-5395-a56ef7c3a3a7', N'×Ô¶¯±êÊéÖÆ×÷Èí¼þ', NULL, 20000.0000, N'A', N'1', CAST(N'2021-05-28T11:08:08.043' AS DateTime), N'1', CAST(N'2021-05-28T11:08:08.043' AS DateTime), N'09')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'17471db7-f6b8-5448-9917-495e1306f77d', N'´úÄâÍ¶ËßÊé', N'30ÍòÔªÒÔÏÂ', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:09.620' AS DateTime), N'1', CAST(N'2021-05-28T10:53:09.620' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'1913662b-acfc-5a82-2bcc-782139e90908', N'ÐèÇóÂÛÖ¤', N'500-1000ÍòÔª', 8000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:40.247' AS DateTime), N'1', CAST(N'2021-05-28T10:52:40.247' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'1a7fbc0e-89da-88f5-6bbe-a19a6f0eeaa1', N'Í¶±êÐÅÏ¢¹ÜÀíÏµÍ³', NULL, 50000.0000, N'A', N'1', CAST(N'2021-05-28T11:08:11.290' AS DateTime), N'1', CAST(N'2021-05-28T11:08:11.290' AS DateTime), N'09')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'1ebde632-88d2-039e-7325-2062c122da67', N'ÂÄÔ¼¾À·×', N'1000ÍòÔªÒÔÉÏ', 100000.0000, N'A', N'1', CAST(N'2021-05-28T11:07:01.997' AS DateTime), N'1', CAST(N'2021-05-28T11:07:01.997' AS DateTime), N'07')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'24d25b49-de97-8f9f-81d4-decdcf30bdb7', N'´úÄâÖÊÒÉº¯', N'200-500ÍòÔª', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:04.540' AS DateTime), N'1', CAST(N'2021-05-28T10:53:04.540' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'2872e063-a4c3-4c83-2c92-a94e7f333bb4', N'ÏßÏÂ½²×ù', NULL, 998.0000, N'A', N'1', CAST(N'2021-05-28T10:54:38.953' AS DateTime), N'1', CAST(N'2021-05-28T10:54:38.953' AS DateTime), N'04')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'396c50c4-fd7a-66de-c0e9-b50020fc9e8f', N'´úÄâÍ¶ËßÊé', N'500ÍòÔªÒÔÉÏ', 30000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:17.717' AS DateTime), N'1', CAST(N'2021-05-28T10:53:17.717' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'3d892e90-d52b-3d6d-9910-9f0c3b5dfe8a', N'±êÊéÖ¸µ¼', N'30ÍòÔªÒÔÏÂ', 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:48.263' AS DateTime), N'1', CAST(N'2021-05-28T10:52:48.263' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'48694773-2045-43cc-7340-dcc8fca74ab6', N'±êÊéÖÆ×÷', N'30ÍòÔªÒÔÏÂ', 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:26.083' AS DateTime), N'1', CAST(N'2021-05-28T10:54:26.083' AS DateTime), N'03')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'4dbac1ab-d980-40a1-8035-b08e386a2f77', N'´úÄâÖÊÒÉ´ð¸´', NULL, 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:14.410' AS DateTime), N'1', CAST(N'2021-05-28T10:54:14.410' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'521aaa43-f2e6-4113-7d50-73695e80768f', N'ÐèÇóÂÛÖ¤', N'200-500ÍòÔª', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:30.837' AS DateTime), N'1', CAST(N'2021-05-28T10:52:30.837' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'56c7a576-26cc-3a1b-4ed7-6832e001ffa9', N'±êÊéÖ¸µ¼', N'500ÍòÔªÒÔÉÏ', 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:56.680' AS DateTime), N'1', CAST(N'2021-05-28T10:52:56.680' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'600688d7-24c4-4ff8-5bc9-b86c17ad4c0b', N'´úÄâÍ¶Ëß´¦Àí¾ö¶¨', NULL, 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:18.210' AS DateTime), N'1', CAST(N'2021-05-28T10:54:18.210' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'606fb37a-9db2-26c8-b0fa-b1e8ebdb3c08', N'ÂÄÔ¼¾À·×', N'30-200ÍòÔª', 20000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:21.513' AS DateTime), N'1', CAST(N'2021-05-28T11:06:21.513' AS DateTime), N'07')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'7034105f-9a0e-c122-4106-2608272f132e', N'ÂÄÔ¼¾À·×', N'30ÍòÔªÒÔÏÂ', 10000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:18.257' AS DateTime), N'1', CAST(N'2021-05-28T11:06:18.257' AS DateTime), N'07')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'772c660a-3f45-0977-1720-1f3598a029d0', N'±êÊéÖÆ×÷', N'200-500ÍòÔª', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:30.943' AS DateTime), N'1', CAST(N'2021-05-28T10:54:30.943' AS DateTime), N'03')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'7be6965b-e08a-6e01-9409-14592b06354b', N'²É¹ºÈËÅàÑµ', NULL, 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:44.113' AS DateTime), N'1', CAST(N'2021-05-28T10:54:44.113' AS DateTime), N'04')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'7fa99d1a-995f-7b49-6127-2ebeef823104', N'Õþ²É´û', NULL, 1.0000, N'A', N'1', CAST(N'2021-05-28T10:54:23.563' AS DateTime), N'1', CAST(N'2021-05-28T10:54:23.563' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'81839b9a-4c55-5fcd-426a-4e9535509af0', N'ÂÄÔ¼¾À·×', N'500-1000ÍòÔª', 50000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:35.410' AS DateTime), N'1', CAST(N'2021-05-28T11:06:35.410' AS DateTime), N'07')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'9337f9e5-ab86-2be9-72d4-9b1db3078e33', N'Ôö¼ÓÆ·Ä¿', NULL, 10000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:12.417' AS DateTime), N'1', CAST(N'2021-05-28T11:06:12.417' AS DateTime), N'06')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'94f7a7c6-a73a-f845-9345-28bd8de79ae2', N'´úÄâÖÊÒÉº¯', N'30-200ÍòÔª', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:01.920' AS DateTime), N'1', CAST(N'2021-05-28T10:53:01.920' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'9934cb44-3aa8-1dda-093e-5d8a2aa6963f', N'ÐèÇóÂÛÖ¤', N'30ÍòÔªÒÔÏÂ', 2000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:19.827' AS DateTime), N'1', CAST(N'2021-05-28T10:52:19.827' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'994491fa-c74d-7df2-f4d1-cfdba128ab35', N'¹©Ó¦ÉÌÅàÑµ', NULL, 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:41.513' AS DateTime), N'1', CAST(N'2021-05-28T10:54:41.513' AS DateTime), N'04')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'9c5f799f-176a-787b-82b9-321aa16422f3', N'µ±Ãæ×ÉÑ¯', NULL, 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:17.007' AS DateTime), N'1', CAST(N'2021-05-28T10:52:17.007' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'9ff378fd-dba7-315c-9a3b-ec9cd07ba597', N'ÂÄÔ¼¾À·×', N'200-500ÍòÔª', 30000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:25.220' AS DateTime), N'1', CAST(N'2021-05-28T11:06:25.220' AS DateTime), N'07')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'a4971acc-b09d-c56e-f612-e6ca79c374fe', N'ÔÚÏß½²×ù', NULL, 20.0000, N'A', N'1', CAST(N'2021-05-28T10:54:36.463' AS DateTime), N'1', CAST(N'2021-05-28T10:54:36.463' AS DateTime), N'04')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'b4b5bf29-6887-19d0-695b-e022b207b6cf', N'µç»°×ÉÑ¯', NULL, 1000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:11.850' AS DateTime), N'1', CAST(N'2021-05-28T10:52:11.850' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'b9d9fd86-da94-3a03-3714-bf962a2af5fd', N'±êÊéÖÆ×÷', N'500ÍòÔªÒÔÉÏ', 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:33.800' AS DateTime), N'1', CAST(N'2021-05-28T10:54:33.800' AS DateTime), N'03')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'ca4ef6e0-bab8-e61e-d209-1e9a08fca42e', N'¾ß±¸Ìõ¼þ', NULL, 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:46.593' AS DateTime), N'1', CAST(N'2021-05-28T10:54:46.593' AS DateTime), N'06')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'd945d55b-9392-c97c-71ee-5e83cc1d9c80', N'ÐèÇóÂÛÖ¤', N'30-200ÍòÔª', 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:23.660' AS DateTime), N'1', CAST(N'2021-05-28T10:52:23.660' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'de752562-a4a3-bf20-04f8-06f2e320b8db', N'´úÄâÖÊÒÉº¯', N'30ÍòÔªÒÔÏÂ', 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:59.240' AS DateTime), N'1', CAST(N'2021-05-28T10:52:59.240' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'e39f6ba7-70c7-822d-c104-fe4a562e0b2a', N'´úÄâÖÊÒÉº¯', N'500ÍòÔªÒÔÉÏ', 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:07.117' AS DateTime), N'1', CAST(N'2021-05-28T10:53:07.117' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'e510300a-b278-cc48-3f56-6b98b6b685dd', N'´úÄâÍ¶ËßÊé', N'30-200ÍòÔª', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:12.380' AS DateTime), N'1', CAST(N'2021-05-28T10:53:12.380' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'ecb0bd60-3653-3ac4-8584-c330a66f6637', N'ÐèÇóÂÛÖ¤', N'1000ÍòÔªÒÔÉÏ', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:45.873' AS DateTime), N'1', CAST(N'2021-05-28T10:52:45.873' AS DateTime), N'02')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'eeec65e5-94f4-4a7a-4159-d2d1ae83c5c4', N'±êÊéÖÆ×÷', N'30-200ÍòÔª', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:28.513' AS DateTime), N'1', CAST(N'2021-05-28T10:54:28.513' AS DateTime), N'03')
INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'fd9cbc17-dbbb-2e54-215c-a87da04603e2', N'´úÄâÍ¶ËßÊé', N'200-500ÍòÔª', 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:14.987' AS DateTime), N'1', CAST(N'2021-05-28T10:53:14.987' AS DateTime), N'02')
GO





































ALTER TABLE [dbo].[Project] ADD [Fencha] [money] NULL;
GO




ALTER TABLE [dbo].[Project] ADD [Shuliang] [int] NULL;
GO




















USE [zhengcaioa]
GO

/****** Object:  Table [dbo].[t_salary_appeal]    Script Date: 2021/7/2 9:06:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

IF EXISTS(Select 1 From Sysobjects Where Name='t_salary_appeal')  --²éÑ¯±íÃûcostSeparateConfigÊÇ·ñ´æÔÚ  
drop table  [t_salary_appeal] 
GO

CREATE TABLE [dbo].[t_salary_appeal](
	[id] [nvarchar](50)  NOT NULL,
	[salary_id] [nvarchar](50) NULL,
	[year] [int] NOT NULL,
	[month] [int] NOT NULL,
	[reason] [nvarchar](1000) NULL,
	[amount] [decimal](10, 2) NULL,
	[basis] [nvarchar](500) NULL,
	[sub_user] [nvarchar](50) NULL,
	[sub_time] [datetime] NULL,
	[chk_user] [nvarchar](50) NULL,
	[chk_time] [datetime] NULL,
	[chk_result] [nvarchar](1000) NULL,
	[status] [nvarchar](1) NULL,
	[createrName] [nvarchar](50) NULL,
	[tittle] [nvarchar](50) NULL,
	[shenpi_status] [nvarchar](1) NULL,
 CONSTRAINT [PK_T_SALARY_APPEAL] 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




































































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






 


