basket.sql

来自「A Design and Implementation of The Onli」· SQL 代码 · 共 16 行

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