XiXianDC_ZhuBiao_API/sql/sql_20180613...

USE [CallCenter_XiXianDC]
GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__T_Call_Ou__F_Opt__100C566E]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[T_Call_OutAnswersWX] DROP CONSTRAINT [DF__T_Call_Ou__F_Opt__100C566E]
END

GO

USE [CallCenter_XiXianDC]
GO

/****** Object:  Table [dbo].[T_Call_OutAnswersWX]    Script Date: 06/13/2018 10:35:57 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_Call_OutAnswersWX]') AND type in (N'U'))
DROP TABLE [dbo].[T_Call_OutAnswersWX]
GO

USE [CallCenter_XiXianDC]
GO

/****** Object:  Table [dbo].[T_Call_OutAnswersWX]    Script Date: 06/13/2018 10:35:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[T_Call_OutAnswersWX](
	[F_AnswerID] [int] IDENTITY(1,1) NOT NULL,
	[F_PagerID] [int] NULL,
	[F_QID] [int] NULL,
	[F_QIID] [int] NULL,
	[F_Answer] [nvarchar](3000) NULL,
	[F_CusTelID] [int] NULL,
	[F_CusID] [int] NULL,
	[F_OptBy] [bigint] NULL,
	[F_OptByOpenid] [nvarchar](100) NULL,
	[F_OptOn] [datetime] NULL,
	[F_Expand1] [nvarchar](500) NULL,
	[F_Expand2] [nvarchar](500) NULL,
	[F_Expand3] [nvarchar](500) NULL
) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'问卷ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutAnswersWX', @level2type=N'COLUMN',@level2name=N'F_PagerID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'试题ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutAnswersWX', @level2type=N'COLUMN',@level2name=N'F_QID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'选择答案ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutAnswersWX', @level2type=N'COLUMN',@level2name=N'F_QIID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutAnswersWX', @level2type=N'COLUMN',@level2name=N'F_Answer'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户计划ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutAnswersWX', @level2type=N'COLUMN',@level2name=N'F_CusTelID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutAnswersWX', @level2type=N'COLUMN',@level2name=N'F_CusID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作人ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutAnswersWX', @level2type=N'COLUMN',@level2name=N'F_OptBy'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作人openid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutAnswersWX', @level2type=N'COLUMN',@level2name=N'F_OptByOpenid'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutAnswersWX', @level2type=N'COLUMN',@level2name=N'F_OptOn'
GO

ALTER TABLE [dbo].[T_Call_OutAnswersWX] ADD  DEFAULT (getdate()) FOR [F_OptOn]
GO