basket.sql

来自「网上商场购物系统是一种具有交互功能的商业信息系统」· 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