XiXianDC_ZhuBiao_API/sql/sql_20180503...

USE [CallCenter_XiXianDC]
GO

/****** Object:  Table [dbo].[T_Call_OutAnswersWX]    Script Date: 05/03/2018 16:33:36 ******/
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: 05/03/2018 16:33:36 ******/
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] [int] NULL,
	[F_OptByName] [nvarchar](50) NULL,
	[F_OptOn] [datetime] NULL DEFAULT (getdate()),
	[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'操作人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutAnswersWX', @level2type=N'COLUMN',@level2name=N'F_OptByName'
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