basket.sql

A Design and Implementation of The Online Shopping System Abstract: Along with the development

USE Shop
GO
CREATE TABLE Basket (
  Id 	Int IDENTITY (1, 1),
  UserId 	Varchar (20),
  GoodsId 	Int,
  OrderTime 	Datetime,
  OrderCount 	Int DEFAULT 0,
  SalePrice 	Float DEFAULT 0,
  UserChecked 	Char (10) DEFAULT 0,
  OrderNumber 	Varchar (50),
  PostTime 	Datetime,
  AdminChecked 	Char (10) DEFAULT 0
)
GO