表名：ZL_Client_Penson












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1Flowint40是  否 主键
2Codevarchar500 是 否 客户编号
3Id_Codevarchar500   是 证件号码
4Sexchar10   是 性别（0为女，1为男，2为未知）
5Nativenvarchar500   是 籍贯
6Nationvarchar120   是 民族
7Marriagechar10   是 婚姻状况(0为未知，1为未婚，2为已婚，3为离异)
8Finish_Schoolnvarchar500   是 毕业学校
9Cultrue_Lovenvarchar500   是 文化爱好
10Sport_Lovenvarchar500   是 体育爱好
11Life_Lovenvarchar500   是 生活爱好
12FUN_Lovenvarchar500   是 娱乐休闲爱好
13Other_Lovenvarchar500   是 其他爱好
14Birthdaydatetime83   是 生日
15Incomenvarchar500   是  
16Home_Circsnvarchar1000   是  
17Educationnvarchar500   是 学历
18Message_Addressnvarchar500   是 客户地址
19Work_Phonevarchar120   是 工作手机号码
20Home_Phonevarchar120   是 家庭手机号码
21Fax_phonevarchar120   是 传真号码
22Telephonevarchar120   是 电话号码
23Little_Smartvarchar120   是  
24Homepagenvarchar500   是 客户主页
25QQ_Codevarchar500   是 QQ号码
26ICQ_Codevarchar500   是 ICQ号码
27UC_Codevarchar500   是 UC号码
28Email_Addressnvarchar500   是 邮件地址
29MSN_Codevarchar500   是 MSN号码
30YaoHu_Codevarchar500   是  
31Aim_Codevarchar500   是 Aim号码
32ZipCodeWnvarchar2550   是 邮政编码
33countrynvarchar2550   是 国家
34provincenvarchar2550   是 省
35citynvarchar2550   是 市

简要说明：

客户扩展表

GO
CREATE TABLE [dbo].[ZL_Client_Penson](
[Flow] [int] IDENTITY(1,1) NOT NULL,
[Code] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Id_Code] [varchar](50) COLLATE Chinese_PRC_CI_AS  NULL,
[Sex] [char](1) COLLATE Chinese_PRC_CI_AS NULL,
[Native] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Nation] [varchar](12) COLLATE Chinese_PRC_CI_AS NULL,
[Marriage] [char](1) COLLATE Chinese_PRC_CI_AS NULL,
[Finish_School] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Cultrue_Love] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Sport_Love] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Life_Love] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[FUN_Love] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Other_Love] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Birthday] [datetime] NULL,
[Income] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Home_Circs] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[Education] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Message_Address] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Work_Phone] [varchar](12) COLLATE Chinese_PRC_CI_AS NULL,
[Home_Phone] [varchar](12) COLLATE Chinese_PRC_CI_AS NULL,
[Fax_phone] [varchar](12) COLLATE Chinese_PRC_CI_AS NULL,
[Telephone] [varchar](12) COLLATE Chinese_PRC_CI_AS NULL,
[Little_Smart] [varchar](12) COLLATE Chinese_PRC_CI_AS NULL,
[Homepage] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[QQ_Code] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ICQ_Code] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UC_Code] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Email_Address] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[MSN_Code] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[YaoHu_Code] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Aim_Code] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ZipCodeW] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[country] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[province] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[city] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_ZL_Client_Penson] PRIMARY KEY CLUSTERED
([Code] ASC
) ON [PRIMARY]
) ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'客户编号' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Code'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'性别（0为女，1为男，2为未知）' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Sex'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'籍贯' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Native'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'民族' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Nation'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'婚姻状况(0为未知，1为未婚，2为已婚，3为离异)' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Marriage'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'毕业学校' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Finish_School'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'文化爱好' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Cultrue_Love'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'体育爱好' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Sport_Love'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'生活爱好' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Life_Love'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'娱乐休闲爱好' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'FUN_Love'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'其他爱好' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Other_Love'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'学历' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Client_Penson', @level2type=N'COLUMN', @level2name=N'Education'

--注意：将清空全表数据

detele from ZL_Client_Penson

--注意：将删除整个表

drop table ZL_Client_Penson

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_Client_Penson