XiXianDC_API/sql/sql_20180503...

USE [CallCenter_XiXianDC]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_Call_OutTelNumWXRecords]') AND type in (N'U'))
DROP TABLE [dbo].[T_Call_OutTelNumWXRecords]
GO

USE [CallCenter_XiXianDC]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_Call_OutTelNumWXRecords](
	[F_Id] [int] IDENTITY(1,1) NOT NULL,
	[F_TelId] [int] NOT NULL,
	[F_PagerId] [int] NULL,
	[F_CusID] [int] NULL,
	[F_CusName] [nvarchar](200) NULL,
	[F_TelPhone] [nvarchar](200) NOT NULL,
	[F_Phone] [nvarchar](200) NOT NULL,
	[F_CountryId] [int] NULL,
	[F_Country] [nvarchar](200) NOT NULL,
	[F_Address] [nvarchar](2000) NOT NULL,
	[F_Openid] [nvarchar](200) NULL,
	[F_UserId] [int] NULL,
	[F_UserName] [nvarchar](50) NULL,
	[F_CreateTime] [datetime] NULL DEFAULT (getdate()),
	[F_Count][int] null default(0),
	[F_AskInfo] [text] NULL,
	[F_AskRes] [text] NULL,
	[F_DeleteFlag] [int] NULL DEFAULT ((0)),
 CONSTRAINT [PK_T_Call_OutTelNumWXRecords] PRIMARY KEY CLUSTERED 
(
	[F_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] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
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_OutTelNumWXRecords', @level2type=N'COLUMN',@level2name=N'F_CusID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutTelNumWXRecords', @level2type=N'COLUMN',@level2name=N'F_CusName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutTelNumWXRecords', @level2type=N'COLUMN',@level2name=N'F_TelPhone'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'固定电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutTelNumWXRecords', @level2type=N'COLUMN',@level2name=N'F_Phone'
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_OutTelNumWXRecords', @level2type=N'COLUMN',@level2name=N'F_CountryId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'乡镇' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutTelNumWXRecords', @level2type=N'COLUMN',@level2name=N'F_Country'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'住址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutTelNumWXRecords', @level2type=N'COLUMN',@level2name=N'F_Address'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提交次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Call_OutTelNumWXRecords', @level2type=N'COLUMN',@level2name=N'F_Count'
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_OutTelNumWXRecords', @level2type=N'COLUMN',@level2name=N'F_AskInfo'
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_OutTelNumWXRecords', @level2type=N'COLUMN',@level2name=N'F_AskRes'
GO