USE [xxz]
GO
/****** Object: Table [dbo].[xxz_userCard] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_userCard](
[cardID] [int] IDENTITY(1,1) NOT NULL,
[cardNumber] [int] NULL,
[passworld] [nvarchar](50) NULL,
[account] [decimal](18, 2) NULL,
[isDefault] [bit] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_userCard] PRIMARY KEY CLUSTERED
(
[cardID] 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
/****** Object: Table [dbo].[xxz_userAdress] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_userAdress](
[userAdressID] [int] IDENTITY(1,1) NOT NULL,
[userAdress] [nvarchar](50) NULL,
[isDefault] [bit] NULL,
[ord] [int] NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_userAdress] PRIMARY KEY CLUSTERED
(
[userAdressID] 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
/****** Object: Table [dbo].[xxz_user] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_user](
[userID] [int] IDENTITY(1,1) NOT NULL,
[loginuser] [int] NULL,
[passworld] [nvarchar](50) NULL,
[usertype] [nvarchar](50) NULL,
[sex] [int] NULL,
[tel] [nvarchar](50) NULL,
[cityID] [int] NULL,
[address] [nvarchar](200) NULL,
[post] [nvarchar](50) NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_user] PRIMARY KEY CLUSTERED
(
[userID] 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
/****** Object: Table [dbo].[xxz_sku] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_sku](
[skuID] [int] IDENTITY(1,1) NOT NULL,
[productID] [int] NULL,
[skuName] [nvarchar](50) NULL,
[ord] [int] NULL,
[color] [nvarchar](50) NULL,
[litpic] [nvarchar](50) NULL,
[attrs] [nvarchar](50) NULL,
[marketprice] [nvarchar](50) NULL,
[salesPrice] [nvarchar](50) NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_sku] PRIMARY KEY CLUSTERED
(
[skuID] 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
/****** Object: Table [dbo].[xxz_shoppingcart] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_shoppingcart](
[shoppingcartID] [int] IDENTITY(1,1) NOT NULL,
[skuID] [int] NULL,
[nums] [int] NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_shoppingcart] PRIMARY KEY CLUSTERED
(
[shoppingcartID] 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
/****** Object: Table [dbo].[xxz_product] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_product](
[productID] [int] IDENTITY(1,1) NOT NULL,
[categoryID] [int] NULL,
[cityID] [int] NULL,
[productName] [nvarchar](50) NULL,
[description] [nvarchar](max) NULL,
[ord] [int] NULL,
[isshow] [int] NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_product] PRIMARY KEY CLUSTERED
(
[productID] 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
/****** Object: Table [dbo].[xxz_payment] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_payment](
[paymentID] [int] IDENTITY(1,1) NOT NULL,
[paymentcode] [nvarchar](50) NULL,
[orderID] [int] NULL,
[cardID] [int] NULL,
[paymentStatus] [int] NULL,
[state] [int] NULL,
[paymentuserid] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_payment] PRIMARY KEY CLUSTERED
(
[paymentID] 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
/****** Object: Table [dbo].[xxz_orderItem] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_orderItem](
[orderItemID] [int] IDENTITY(1,1) NOT NULL,
[orderID] [int] NULL,
[productID] [int] NULL,
[skuID] [int] NULL,
[nums] [int] NULL,
[price] [decimal](18, 2) NULL,
[acount] [decimal](18, 2) NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_orderItem] PRIMARY KEY CLUSTERED
(
[orderItemID] 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
/****** Object: Table [dbo].[xxz_order] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_order](
[orderID] [int] IDENTITY(1,1) NOT NULL,
[reciveAddress] [nvarchar](50) NULL,
[orderTag] [nvarchar](50) NULL,
[noticeTime] [datetime] NULL,
[reciveTime] [datetime] NULL,
[postman] [nvarchar](50) NULL,
[postmanTel] [nvarchar](50) NULL,
[orderStatus] [int] NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_order] PRIMARY KEY CLUSTERED
(
[orderID] 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
/****** Object: Table [dbo].[xxz_menu] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_menu](
[menuID] [int] IDENTITY(1,1) NOT NULL,
[menuName] [nvarchar](50) NULL,
[menuValue] [nvarchar](50) NULL,
[ord] [int] NULL,
[fbase] [int] NULL,
[sort] [nvarchar](50) NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_menu] PRIMARY KEY CLUSTERED
(
[menuID] 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
/****** Object: Table [dbo].[xxz_help] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_help](
[helpID] [int] IDENTITY(1,1) NOT NULL,
[helpName] [nvarchar](50) NULL,
[helpDesc] [nvarchar](max) NULL,
[ord] [int] NULL,
[fbase] [int] NULL,
[sort] [nvarchar](50) NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_help] PRIMARY KEY CLUSTERED
(
[helpID] 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
/****** Object: Table [dbo].[xxz_employeeInCompany] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_employeeInCompany](
[companyID] [int] IDENTITY(1,1) NOT NULL,
[employeeID] [int] NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_employeeInCompany] PRIMARY KEY CLUSTERED
(
[companyID] 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
/****** Object: Table [dbo].[xxz_employee] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_employee](
[employeeID] [int] IDENTITY(1,1) NOT NULL,
[loginuser] [nvarchar](50) NULL,
[passworld] [nvarchar](50) NULL,
[cityID] [int] NULL,
[usertype] [nvarchar](50) NULL,
[sex] [int] NULL,
[tel] [nvarchar](50) NULL,
[IDCard] [nvarchar](50) NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_employee] PRIMARY KEY CLUSTERED
(
[employeeID] 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
/****** Object: Table [dbo].[xxz_config] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_config](
[configID] [int] IDENTITY(1,1) NOT NULL,
[configName] [nvarchar](50) NULL,
[configValue] [nvarchar](50) NULL,
[ord] [int] NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_config] PRIMARY KEY CLUSTERED
(
[configID] 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
/****** Object: Table [dbo].[xxz_company] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_company](
[companyID] [int] IDENTITY(1,1) NOT NULL,
[companyName] [nvarchar](50) NULL,
[companyCode] [nvarchar](50) NULL,
[buildTime] [datetime] NULL,
[adminID] [int] NULL,
[cityID] [int] NULL,
[address] [nvarchar](200) NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_company] PRIMARY KEY CLUSTERED
(
[companyID] 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
/****** Object: Table [dbo].[xxz_city] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_city](
[cityID] [int] IDENTITY(1,1) NOT NULL,
[code] [nvarchar](50) NULL,
[country] [nvarchar](50) NULL,
[province] [nvarchar](50) NULL,
[city] [nvarchar](50) NULL,
[area] [nvarchar](50) NULL,
[postcode] [nvarchar](50) NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_city] PRIMARY KEY CLUSTERED
(
[cityID] 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
/****** Object: Table [dbo].[xxz_category] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_category](
[categoryID] [int] IDENTITY(1,1) NOT NULL,
[categoryName] [nvarchar](50) NULL,
[description] [nvarchar](max) NULL,
[ord] [int] NULL,
[fbase] [int] NULL,
[sort] [nvarchar](50) NULL,
[state] [int] NULL,
[createAdminID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_category] PRIMARY KEY CLUSTERED
(
[categoryID] 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
/****** Object: Table [dbo].[xxz_attr] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_attr](
[attrID] [int] IDENTITY(1,1) NOT NULL,
[attrName] [nvarchar](50) NULL,
[ord] [int] NULL,
[pid] [int] NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_attr] PRIMARY KEY CLUSTERED
(
[attrID] 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
/****** Object: Table [dbo].[xxz_ads] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_ads](
[adsID] [int] IDENTITY(1,1) NOT NULL,
[AdsName] [nvarchar](50) NULL,
[description] [nvarchar](max) NULL,
[postionID] [int] NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_ads] PRIMARY KEY CLUSTERED
(
[adsID] 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
/****** Object: Table [dbo].[xxz_admin] Script Date: 07/09/2021 17:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxz_admin](
[adminID] [int] IDENTITY(1,1) NOT NULL,
[loginuser] [nvarchar](50) NULL,
[passworld] [nvarchar](50) NULL,
[sex] [int] NULL,
[tel] [nvarchar](50) NULL,
[state] [int] NULL,
[createUserID] [int] NULL,
[createtime] [datetime] NULL,
[ver] [int] NULL,
[timestamp] [timestamp] NULL,
CONSTRAINT [PK_xxz_admin] PRIMARY KEY CLUSTERED
(
[adminID] 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
xxzxxzxxzxxz
最新推荐文章于 2023-11-14 14:23:57 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)