ShangQiuSZCG_API/sql/T_Sys_WorkOF...

use [CallCenter_ShangQiu]
/****** Object:  Table [dbo].[T_Sys_WorkOFFDays]    Script Date: 05/06/2019 14:50:38 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[T_Sys_WorkOFFDays](
	[F_OffID] [int] IDENTITY(1,1) NOT NULL,
	[F_OffDate] [date] NULL,
	[F_OffState] [int] NULL,
	[F_remark] [nvarchar](2000) NULL,
	[F_CreateBy] [nvarchar](50) NULL,
	[F_CreateOn] [datetime] NULL
) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'休息日日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_WorkOFFDays', @level2type=N'COLUMN',@level2name=N'F_OffDate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态，0在用，1删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_WorkOFFDays', @level2type=N'COLUMN',@level2name=N'F_OffState'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_WorkOFFDays', @level2type=N'COLUMN',@level2name=N'F_remark'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_WorkOFFDays', @level2type=N'COLUMN',@level2name=N'F_CreateBy'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_WorkOFFDays', @level2type=N'COLUMN',@level2name=N'F_CreateOn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'休息日表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_WorkOFFDays'
GO

ALTER TABLE [dbo].[T_Sys_WorkOFFDays] ADD  CONSTRAINT [DF_T_Sys_WorkOFFDays_F_OffDate]  DEFAULT (getdate()) FOR [F_OffDate]
GO

ALTER TABLE [dbo].[T_Sys_WorkOFFDays] ADD  CONSTRAINT [DF_T_Sys_WorkOFFDays_F_CreateOn]  DEFAULT (getdate()) FOR [F_CreateOn]
GO