表名：ZL_UserBase












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1UserIDint40 是 否 用户ID
2TrueNamenvarchar500   是 真实姓名
3BirthDaynvarchar200   是 生日
4shengxiaonvarchar500   是 生肖
5xingzuonvarchar500   是 星座
6Addressnvarchar2550   是 联系地址
7OfficePhonenvarchar500   是 办公电话
8HomePhonenvarchar500   是 家庭电话
9Faxnvarchar500   是 传真号码
10ZipCodenvarchar100   是 邮编
11PHSnvarchar500   是 小灵通
12Mobilenvarchar500   是 手机号
13UserSexbit10   是1性别
14QQnvarchar500   是 QQ号码
15MSNnvarchar2550   是 MSN号码
16ICQnvarchar500   是 ICQ号码
17UCnvarchar500   是 UC号码
18Yahoonvarchar500   是 雅虎通账号
19IDCardnvarchar500   是 身份证号码
20HomePagenvarchar2550   是 个人主页
21UserFacenvarchar2550   是 头像地址
22FaceWidthint40   是16头像宽度
23FaceHeightint40   是16头像高度
24Signnvarchar10000   是 签名档
25Countrynvarchar500   是 国家
26Provincenvarchar500   是 省
27Citynvarchar500   是 市
28Countynvarchar500   是 县
29Privacyint40   是0隐私设定
30cardTypenvarchar2550   是 证件类型
31honeyNamenvarchar2550   是 昵称
32workProvincenvarchar500   是 工作地址
33workCitynvarchar500   是 工作城市
34Bugleint40   是0多人视频小喇叭
35SFStatusint40   是 征友状态
36VIPUserint40   是0VIP会员
37Positionnvarchar500   是 公司职务
38Corpnvarchar500   是 公司名称

简要说明：

会员详情表

GO
CREATE TABLE [dbo].[ZL_UserBase](
[UserID] [int] NOT NULL,
[TrueName] [nvarchar](50) NULL,
[BirthDay] [nvarchar](20) NULL,
[shengxiao] [nvarchar](50) NULL,
[xingzuo] [nvarchar](50) NULL,
[Address] [nvarchar](255) NULL,
[OfficePhone] [nvarchar](50) NULL,
[HomePhone] [nvarchar](50) NULL,
[Fax] [nvarchar](50) NULL,
[ZipCode] [nvarchar](10) NULL,
[PHS] [nvarchar](50) NULL,
[Mobile] [nvarchar](50) NULL,
[UserSex] [bit] NULL CONSTRAINT [DF_ZL_UserBase_UserSex]  DEFAULT (1),
[QQ] [nvarchar](50) NULL,
[MSN] [nvarchar](255) NULL,
[ICQ] [nvarchar](50) NULL,
[UC] [nvarchar](50) NULL,
[Yahoo] [nvarchar](50) NULL,
[IDCard] [nvarchar](50) NULL,
[HomePage] [nvarchar](255) NULL,
[UserFace] [nvarchar](255) NULL,
[FaceWidth] [int] NULL CONSTRAINT [DF_ZL_UserBase_FaceWidth]  DEFAULT (16),
[FaceHeight] [int] NULL CONSTRAINT [DF_ZL_UserBase_FaceHeight]  DEFAULT (16),
[Sign] [nvarchar](1000) NULL,
[Country] [nvarchar](50) NULL,
[Province] [nvarchar](50) NULL,
[City] [nvarchar](50) NULL,
[County] [nvarchar](50) NULL,
[Privacy] [int] NULL CONSTRAINT [DF_ZL_UserBase_Privating]  DEFAULT (0),
[cardType] [nvarchar] (255) NULL ,
[honeyName] [nvarchar] (255)NULL,
[workProvince] [nvarchar](50) NULL,
[workCity] [nvarchar](50) NULL,
[Bugle] [int] default(0) NULL,
[SFStatus] [int] NULL,
[VIPUser][int] NULL CONSTRAINT [DF_ZL_UserBase_VIPUser]  DEFAULT (0),
[Position] [nvarchar](50) NULL,
[Corp] [nvarchar](50) NULL,
CONSTRAINT [PK_ZL_UserBase] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) 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'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'UserID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'真实姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'TrueName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生日' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'BirthDay'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生肖' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'shengxiao'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'星座' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'xingzuo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @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'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'OfficePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'家庭电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'HomePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'传真号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮编' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'ZipCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'小灵通' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'PHS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @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'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'UserSex'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'QQ号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'QQ'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'MSN号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'MSN'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ICQ号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'ICQ'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'UC号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'UC'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'雅虎通账号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'Yahoo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'身份证号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'IDCard'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'个人主页' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'HomePage'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'UserFace'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像宽度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'FaceWidth'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像高度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'FaceHeight'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'签名档' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'Sign'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'国家' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'省' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @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'ZL_UserBase', @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'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'County'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'隐私设定' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'Privacy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'cardType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'昵称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'honeyName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'workProvince'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作城市' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'workCity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'多人视频小喇叭' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'Bugle'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'征友状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'SFStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'VIP会员' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'VIPUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司职务' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'Position'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserBase', @level2type=N'COLUMN',@level2name=N'Corp'

INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[FaceWidth],[FaceHeight],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 2,1,N'http://',0,0,0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[FaceWidth],[FaceHeight],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 3,1,N'http://',0,0,0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[FaceWidth],[FaceHeight],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 4,1,N'http://',0,0,0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 5,0,N'http://',N'/UploadFiles/Images/SingleF/20170410183721r9ke.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 6,1,N'http://',N'/UploadFiles/Images/SingleF/201704101838227qRW.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 7,1,N'http://',N'/UploadFiles/Images/SingleF/20170410183855uWtz.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 8,1,N'http://',N'/UploadFiles/Images/SingleF/201704101839368KrP.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 9,1,N'http://',N'/UploadFiles/Images/SingleF/20170410184016b6hd.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 10,1,N'http://',N'/UploadFiles/Images/SingleF/20170410184441VHsL.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 11,1,N'http://',N'/UploadFiles/Images/SingleF/20170410184524H7uz.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 12,1,N'http://',N'/UploadFiles/Images/SingleF/20170410184609eGiB.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 13,1,N'http://',N'/UploadFiles/Images/SingleF/20170410184647C46j.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 14,1,N'http://',N'/UploadFiles/Images/SingleF/20170410184718WltP.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)
INSERT [ZL_UserBase] ([UserID],[UserSex],[HomePage],[UserFace],[FaceWidth],[FaceHeight],[Province],[City],[County],[Privacy],[Bugle],[SFStatus],[VIPUser]) VALUES ( 15,1,N'http://',N'/UploadFiles/Images/SingleF/20170410184752m9E4.jpg',0,0,N'北京',N'北京市',N'东城',0,0,0,0)

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

detele from ZL_UserBase

--注意：将删除整个表

drop table ZL_UserBase

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

TRUNCATE table ZL_UserBase