database_inventory.sql

来自「Winform_OnlineTraning 我们培训机构的在线培训部分」· SQL 代码 · 共 39 行

IF EXISTS (SELECT * 
	   FROM   master..sysdatabases 
	   WHERE  name = 'Inventory')
	DROP DATABASE Inventory
GO

CREATE DATABASE Inventory
GO

use Inventory
go


CREATE TABLE [dbo].[Orders] (
	[OrderID] [numeric](18, 0) NOT NULL PRIMARY KEY,
	[CustomerID] [varchar] (4) NOT NULL ,
	[EmployeeID] [varchar] (4) NOT NULL ,
	[PurchaseOrderNumber] [varchar] (4) NOT NULL ,
	[ShipAddress] [varchar] (20)  NOT NULL ,
	[SalesTaxRate] [numeric](18, 0) NOT NULL 
)

CREATE TABLE [dbo].[OrderDetails] (
	[OrderDetailID] [numeric](18, 0) NOT NULL PRIMARY KEY,
	[OrderID] [numeric](18, 0) NOT NULL ,
	[ProductID] [varchar] (4) NOT NULL ,
	[Quantity] [numeric](18, 0) NOT NULL ,
	[UnitPrice] [numeric](18, 0) NOT NULL ,
	[Total] [numeric](18, 0) NOT NULL )

CREATE TABLE [dbo].[Project] (
	[ProjectID] [numeric](18, 0) NOT NULL PRIMARY KEY,
	[ProjectName] [varchar](20) NOT NULL ,
	[ProjectDescription] [varchar] (50) NOT NULL ,
	[ClientID] [varchar](4) NOT NULL ,
	[EmployeeID] [varchar](4) NOT NULL )