开发工具:
文件大小: 374kb
下载次数: 0
上传时间: 2010-09-09
详细说明： Table: PE_Address Schema dbo Descriptions 地址表 Fields PK Name Data type Not null Unique Row GUID Collation Default Description AddressID int 地址ID UserName nvarchar(20) Chinese_PRC_CI_AS 用户名 ConsigneeName nvarchar(255) Chinese_PRC_CI_AS 收货人姓名 HomePhone nvarchar(50) Chinese_PRC_CI_AS 固定电话 Mobile nvarchar(30) Chinese_PRC_CI_AS 移动电话 Country nvarchar(50) Chinese_PRC_CI_AS 国家 Province nv archar(30) Chinese_PRC_CI_AS 省份 City nvarchar(30) Chinese_PRC_CI_AS 城市 Area nvarchar(30) Chinese_PRC_CI_AS 地区 Address nvarchar(255) Chinese_PRC_CI_AS 详细地址 ZipCode nvarchar(50) Chinese_PRC_CI_AS 邮政编码 IsDefault bit 0 是否默认 Foreign Keys There are no foreign keys for table PE_Address Checks There are no check constraints for table PE_Address Indices Name Type Fields File Group Fill Factor Clustered Don't Recompute Statistics Ignore Duplicate Keys Pad Index Allow Row Locks Allow Page Locks Description IX_PE_Address_UserName Index UserName PRIMARY 0 PK_PE_Address_AddressID Primary Key AddressID PRIMARY 0 Triggers There are no triggers for table PE_Address Definition CREATE TABLE [dbo].[PE_Address] ( [AddressID] int NOT NULL, [UserName] nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL, [ConsigneeName] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [HomePhone] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [Mobile] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL, [Country] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [Province] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL, [City] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL, [Area] nvarchar(30) COLLATE Chinese_PRC_CI_AS NULL, [Address] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, [ZipCode] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, [IsDefault] bit CONSTRAINT [DF_PE_Address_IsDefalult] DEFAULT 0 NULL, CONSTRAINT [PK_PE_Address_AddressID] PRIMARY KEY NONCLUSTERED ([AddressID]) ) ON [PRIMARY] GO EXEC sp_addextendedproperty 'MS_Description', N'地址表', 'schema', 'dbo', 'table', 'PE_Address' GO EXEC sp_addextendedproperty 'MS_Description', N'地址ID', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'AddressID' GO EXEC sp_addextendedproperty 'MS_Description', N'用户名', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'UserName' GO EXEC sp_addextendedproperty 'MS_Description', N'收货人姓名', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'ConsigneeName' GO EXEC sp_addextendedproperty 'MS_Description', N'固定电话', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'HomePhone' GO EXEC sp_addextendedproperty 'MS_Description', N'移动电话', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'Mobile' GO EXEC sp_addextendedproperty 'MS_Description', N'国家', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'Country' GO EXEC sp_addextendedproperty 'MS_Description', N'省份', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'Province' GO EXEC sp_addextendedproperty 'MS_Description', N'城市', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'City' GO EXEC sp_addextendedproperty 'MS_Description', N'地区', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'Area' GO EXEC sp_addextendedproperty 'MS_Description', N'详细地址', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'Address' GO EXEC sp_addextendedproperty 'MS_Description', N'邮政编码', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'ZipCode' GO EXEC sp_addextendedproperty 'MS_Description', N'是否默认', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'IsDefault' GO CREATE CLUSTERED INDEX [IX_PE_Address_UserName] ON [dbo].[PE_Address] ([UserName]) WITH ( PAD_INDEX = OFF, DROP_EXISTING = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
