SYCW_API/文档/Sql/sql_T_Cus_Cu...

USE [CallCenter_SanYuanCW]
GO

/****** Object:  Table [dbo].[T_Cus_CustomerBaseNew]    Script Date: 12/21/2018 14:42:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_Cus_CustomerBaseNew]') AND type in (N'U'))
DROP TABLE [dbo].[T_Cus_CustomerBaseNew]
GO

USE [CallCenter_SanYuanCW]
GO

/****** Object:  Table [dbo].[T_Cus_CustomerBaseNew]    Script Date: 12/21/2018 14:42:59 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_Cus_CustomerBaseNew](
	[F_CustomerId] [int] IDENTITY(1,1) NOT NULL,
	[F_CustomerCode] [nvarchar](100) NULL,--客户编号
	[F_CompanyName] [nvarchar](500) NULL,--公司名称
	[F_KeyWords] [nvarchar](2000) Null,--搜索关键字
	[F_CompanyAddress] [nvarchar](500) NULL,--公司地址
	[F_RegisteredAddress] [nvarchar](500) NULL,--注册地址
	[F_LegalName] [nvarchar](100) NULL,--法人姓名
	[F_LegalIDCards] [nvarchar](100) NULL,--法人身份证
	[F_LegalTel] [nvarchar](200) NULL,--法人电话
	[F_SubTrade]  [nvarchar](500) NULL,--所属行业
	[F_TaxCategory]  [nvarchar](500) NULL,--税务类别
	[F_TaxPointDes] [ntext] NULL,--税点描述
	[F_InvoiceRange] [nvarchar](500) NULL,--开票范围
	[F_Qualification][nvarchar](2000) NULL,--企业资质荣誉
	[F_Layer] [nvarchar](200) NULL,--客户信誉等级
	[F_BeDept] [int] NULL,--客户归属部门
	[F_FinancialManager][nvarchar](300) NULL,--客户公司财务负责人
	[F_BusinessOwner][nvarchar](300) NULL,--客户归属业务负责人
	[F_BeRelatedAcc] [nvarchar](100) NULL,--客户归属涉税会计
	[F_BeAuditAcc] [nvarchar](100) NULL,--客户归属审核会计
	[F_BeMakeAcc] [nvarchar](100) NULL,--客户归属做账会计
	[F_WxPassword] [varchar](100) NULL,--微信登录密码
	[F_WxOpenId] [nvarchar](300) NULL,--微信openid
	[F_Remark1][ntext] NULL,--备注1
	[F_Remark2][ntext] NULL,--备注2
	[F_Remark3][ntext] NULL,--备注3
	[F_CreateBy] [nvarchar](100) NULL,
	[F_CreatedOn] [datetime] NULL,
	[F_DeleteFlag] [smallint] NULL
 CONSTRAINT [PK_T_Cus_CustomerBaseNew] PRIMARY KEY CLUSTERED 
(
	[F_CustomerId] 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_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_CustomerId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_CustomerCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_CompanyName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关键字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_KeyWords'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_CompanyAddress'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注册地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_RegisteredAddress'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'法人姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_LegalName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'法人身份证' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_LegalIDCards'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'法人电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_LegalTel'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属行业' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_SubTrade'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'税务类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_TaxCategory'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'税点描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_TaxPointDes'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开票范围' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_InvoiceRange'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'企业资质荣誉' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_Qualification'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户信誉等级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_Layer'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户归属部门' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_BeDept'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户公司财务负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_FinancialManager'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户归属业务负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_BusinessOwner'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户归属涉税会计' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_BeRelatedAcc'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户归属审核会计' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_BeAuditAcc'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户归属做账会计' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_BeMakeAcc'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'微信登录密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_WxPassword'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'微信openid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_WxOpenId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_Remark1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_Remark2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_Remark3'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人工号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @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_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_CreatedOn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerBaseNew', @level2type=N'COLUMN',@level2name=N'F_DeleteFlag'
GO




/*
客户编号*
公司名称*
公司地址*
注册地址
法人姓名*
法人身份证
法人电话*
公司联系人1姓名/电话
公司联系人2姓名/电话
所属行业*
税务类别*
税点描述*
开票范围*
企业资质荣誉
客户信誉等级*
微信首次关注密码
客户归属部门*
客户公司财务负责人
客户归属业务负责人
客户归属涉税会计*
客户归属审核会计*
客户归属做账会计*
备注1
备注2
备注3
*/