34,838
社区成员




USE [RuiTuDB]
GO
/****** 对象: Table [dbo].[T_Guest_Info] 脚本日期: 06/27/2008 13:06:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_Guest_Info](
[Mustid] [int] IDENTITY(1,1) NOT NULL,
[GID] [nvarchar](50) NOT NULL,
[Mobile] [nvarchar](50) NULL,
[AddressTel] [nvarchar](50) NULL,
[StandbyTel] [nvarchar](50) NULL,
[Name] [nvarchar](50) NULL,
[Sex] [char](10) NULL,
[Province] [nvarchar](50) NULL,
[City] [nvarchar](50) NULL,
[Address] [nvarchar](50) NULL,
[ArrivedCode] [varchar](50) NULL,
[Postalcode] [int] NULL,
[Remarks] [nvarchar](50) NULL,
[IsSell] [char](10) NULL CONSTRAINT [DF_T_Guest_Info_IsSell] DEFAULT ('no'),
[GType] [nvarchar](50) NULL,
[GStatus] [nvarchar](50) NULL,
[GStage] [nvarchar](50) NULL,
[GKind] [nvarchar](50) NULL,
[RegTime] [datetime] NULL CONSTRAINT [DF_T_Guest_Info_RegTime] DEFAULT (getdate()),
[IsDel] [char](10) NULL CONSTRAINT [DF_T_Guest_Info_IsDel] DEFAULT ('no'),
[PerfectTime] [datetime] NULL,
[Operate] [nvarchar](50) NULL,
CONSTRAINT [PK_T_Guest_Info] PRIMARY KEY CLUSTERED
(
[Mustid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'GID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'GID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'Mobile'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'住址电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'AddressTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备用电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'StandbyTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'Sex'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'省份' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'Province'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'城市' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'详细地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'Address'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寄达地码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'ArrivedCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮编' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'Postalcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否已销售' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'IsSell'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户类型(家庭、企业、个人)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'GType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户状态(活跃、停顿、流失)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'GStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户阶段(售前跟踪、合同执行、售后服务等)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'GStage'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户性质(正式客户、潜在客户、供应商、合作伙伴、核心代理商、地区分销商等)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'GKind'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'RegTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除yes是no否' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'IsDel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'PerfectTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Guest_Info', @level2type=N'COLUMN',@level2name=N'Operate'