/*==============================================================*/
/* Database name: BookShop */
/* DBMS name: sqlServer2000(Extend) */
/* Created on: 2006-8-27 9:07:10 */
/*==============================================================*/
/*==============================================================*/
/* Table: Account */
/*==============================================================*/
create table Account (
ProfileID int not null
/*ProfileID*/,
UserName nvarchar(50) not null
/*UserName*/,
Address nvarchar(100) not null
/*Address*/,
Phone nvarchar(20) not null
/*Phone*/,
Mail nvarchar(50) not null
/*Mail*/,
Country nvarchar(20) not null
/*Country*/,
Code nvarchar(20) not null
/*Code*/
)
go
/*==============================================================*/
/* Table: Cart */
/*==============================================================*/
create table Cart (
ItemID int not null
/*ItemID*/,
ProfileID int not null
/*ProfileID*/,
ProductID int not null
/*ProductID*/,
ProductName nvarchar(50) not null
/*ProductName*/,
Price decimal(10,2) not null
/*Price*/,
Quantity int not null
/*Quantity*/
)
go
/*==============================================================*/
/* Table: Category */
/*==============================================================*/
create table Category (
CategoryID int identity
/*CategoryID*/,
CategoryName nvarchar(50) not null
/*CategoryName*/,
CategoryDescription nvarchar(300) not null
/*CategoryDescription*/,
constraint PK_CATEGORY primary key (CategoryID)
)
go
/*==============================================================*/
/* Table: Item */
/*==============================================================*/
create table Item (
ItemID int identity
/*ItemID*/,
ProductID int null
/*ProductID*/,
SupplierID int null
/*SupplierID*/,
Price decimal(10,2) not null
/*Price*/,
ProductName nvarchar(50) not null
/*ProductName*/,
ProductImage nvarchar(100) not null
/*ProductImage*/,
constraint PK_ITEM primary key (ItemID)
)
go
/*==============================================================*/
/* Table: OrderItem */
/*==============================================================*/
create table OrderItem (
OrderID int null
/*OrderID*/,
ItemID int not null
/*ItemID*/,
LineNumber int not null
/*LineNumber*/,
Quantity int not null
/*Quantity*/,
Price decimal(10,2) not null
/*Price*/
)
go
/*==============================================================*/
/* Table: Orders */
/*==============================================================*/
create table Orders (
OrderID int identity
/*OrderID*/,
OrderDate datetime not null
/*OrderDate*/,
UserName nvarchar(50) not null
/*UserName*/,
BillAddress nvarchar(100) not null
/*BillAddress*/,
BillCode nvarchar(20) not null
/*BillCode*/,
BillCountry nvarchar(20) not null
/*BillCountry*/,
ShipAddress nvarchar(100) not null
/*ShipAddress*/,
ShipCode nvarchar(20) not null
/*ShipCode*/,
ShipCountry nvarchar(20) not null
/*ShipCountry*/,
BillToName nvarchar(50) not null
/*BillToName*/,
ShipToName nvarchar(50) not null
/*ShipToName*/,
TotalPrice decimal(10,2) not null
/*TotalPrice*/,
constraint PK_ORDERS primary key (OrderID)
)
go
/*==============================================================*/
/* Table: Product */
/*==============================================================*/
create table Product (
ProductID int identity
/*ProductID*/,
CategoryID int null
/*CategoryID*/,
ProductName nvarchar(50) not null
/*ProductName*/,
ProductDescription nvarchar(300) not null
/*ProductDescription*/,
ProductImage nvarchar(100) not null
/*ProductImage*/,
constraint PK_PRODUCT primary key (ProductID)
)
go
/*==============================================================*/
/* Table: ProductCount */
/*==============================================================*/
create table ProductCount (
ItemID int null
/*ItemID*/,
Count int not null
/*Count*/
)
go
/*==============================================================*/
/* Table: Profiles */
/*==============================================================*/
create table Profiles (
ProfileID int identity
/*ProfileID*/,
UserName nvarchar(50) not null
/*UserName*/,
LastActivityDate datetime not null
/*LastActivityDate*/,
LastUpdateDate datetime not null
/*LastUpdateDate*/,
ApplicationName nvarchar(50) not null
/*ApplicationName*/,
constraint PK_PROFILES primary key (ProfileID)
)
go
/*==============================================================*/
/* Table: Supplier */
/*==============================================================*/
create table Supplier (
SupplierID int identity
/*SupplierID*/,
SupplierName nvarchar(50) not null
/*SupplierName*/,
Address nvarchar(100) not null
/*Address*/,
Phone nvarchar(20) not null
/*Phone*/,
constraint PK_SUPPLIER primary key (SupplierID)
)
go
alter table Account
add constraint FK_ACCOUNT_REFERENCE_PROFILES foreign key (ProfileID)
references Profiles (ProfileID)
go
alter table Cart
add constraint FK_CART_REFERENCE_ITEM foreign key (ItemID)
references Item (ItemID)
go
alter table Cart
add constraint FK_CART_REFERENCE_PROFILES foreign key (ProfileID)
references Profiles (ProfileID)
go
alter table Item
add constraint FK_ITEM_REFERENCE_PRODUCT foreign key (ProductID)
references Product (ProductID)
go
alter table Item
add constraint FK_ITEM_REFERENCE_SUPPLIER foreign key (SupplierID)
references Supplier (SupplierID)
go
alter table OrderItem
add constraint FK_ORDERITE_REFERENCE_ORDERS foreign key (OrderID)
references Orders (OrderID)
go
alter table Product
add constraint FK_PRODUCT_REFERENCE_CATEGORY foreign key (CategoryID)
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
.rar (83个子文件)
200803040836500
网上书店系统
数据库
BookShop_log.ldf 1024KB
BookShop.mdf 3MB
数据库脚本
BookShop.sql 8KB
SQL Server2005源代码
UserProfile.aspx 1KB
Default.aspx 2KB
images
button-calculate.gif 93B
button-delete.gif 61B
controls
ShoppingCartControl.ascx.cs 3KB
ProductIn.ascx.cs 1KB
CartList.ascx.cs 715B
Products.ascx 979B
SearchControl.ascx 1KB
AddressConfirm.ascx.cs 1KB
Products.ascx.cs 755B
PayControl.ascx.cs 1KB
ItemControl.ascx 2KB
CartList.ascx 622B
AddressForm.ascx 3KB
AddressConfirm.ascx 680B
SearchControl.ascx.cs 796B
ItemControl.ascx.cs 754B
AddCategory.ascx 1KB
ProductIn.ascx 2KB
AddressForm.ascx.cs 2KB
Supplier.ascx.cs 848B
PayControl.ascx 1011B
Supplier.ascx 3KB
AddCategory.ascx.cs 894B
ShoppingCartControl.ascx 3KB
MasterPage.master.cs 2KB
App_Code
BookShopProfileProvider.cs 17KB
BusinessLayer
Product.cs 13KB
Category.cs 6KB
Cart.cs 3KB
CartItem.cs 4KB
Order.cs 8KB
Inventory.cs 400B
SqlBookShopProfileProvider.cs 19KB
EntityClass
ItemInfo.cs 2KB
AddressInfo.cs 2KB
OrderInfo.cs 2KB
CustomProfileInfo.cs 2KB
CategoryInfo.cs 1KB
LineItemInfo.cs 2KB
CartItemInfo.cs 2KB
PayInfo.cs 799B
ProductInfo.cs 1KB
SqlHelper.cs 12KB
RegisterPage.aspx.cs 515B
App_Data
ASPNETDB.MDF 10MB
aspnetdb_log.ldf 504KB
Manager.aspx 1KB
test.aspx.cs 405B
MasterPage.master 2KB
Product
ProductInPage.aspx.cs 422B
Search.aspx.cs 407B
ProductEdit.aspx.cs 420B
ProductEdit.aspx 3KB
SupplierManager.aspx 450B
ProductsPage.aspx.cs 421B
ProductsPage.aspx 419B
SupplierManager.aspx.cs 424B
ProductInPage.aspx 445B
Search.aspx 419B
Manager.aspx.cs 408B
UserProfile.aspx.cs 771B
RegisterPage.aspx 2KB
Login.aspx.cs 406B
Web.Config 3KB
Login.aspx 578B
Category
AddCategory.aspx.cs 421B
AddCategory.aspx 481B
DelCategory.aspx 868B
DelCategory.aspx.cs 832B
CheckOut.aspx.cs 3KB
StyleSheet.css 13KB
Cart
ShoppingCart.aspx 495B
Items.aspx 436B
ShoppingCart.aspx.cs 974B
Items.aspx.cs 411B
test.aspx 447B
Default.aspx.cs 2KB
CheckOut.aspx 3KB
共 83 条
- 1
资源评论
kathleen0311
- 粉丝: 0
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 写入三菱plcD位寄存器的值
- 确保你的操作系统符合Docker的要求 Docker支持的操作系统包括Ubuntu、Debian、CentOS、Fedora和m
- 确保你的操作系统符合Docker的要求 Docker支持的操作系统包括Ubuntu、Debian、CentOS、Fedora和m
- HDMI 虚拟软件欺骗器
- 确保你的操作系统符合Docker的要求 Docker支持的操作系统包括Ubuntu、Debian、CentOS、Fedora和m
- 读取三菱PLC D位寄存器
- HDMI edid 编辑工具
- 要在你的计算机上安装Docker,你可以按照以下步骤进行:
- 要在你的计算机上安装Docker,你可以按照以下步骤进行:
- html加JavaScript进行表单验证
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功