Order Details

Table Properties

Name	Value
Owner	dbo
Creation Date	12/13/2004
ID	325576198
Located On	PRIMARY
Data Size KB	72 KB
Index Size KB	208 KB
Rows	2155

Creation Options

Name	Value
QUOTED_IDENTIFIER	ON
ANSI_NULLS	ON
ANSI_PADDING	OFF

Columns

Name	Description	Data Type	Max Length	Nullable	Default	IsGUID
OrderID		int	4
ProductID		int	4
UnitPrice		money	8		(0)
Quantity		smallint	2		(1)
Discount		real	4		(0)

Total: 5 column(s)

Indexes

Index	Primary	Unique
PK_Order_Details
OrderID
OrdersOrder_Details
ProductID
ProductsOrder_Details

Fulltext Index

No fulltext index exist

Statistics

No statistics exist

Check Constraints

	Name	Expression
	CK_Discount	([Discount] >= 0 and [Discount] <= 1)
	CK_Quantity	([Quantity] > 0)
	CK_UnitPrice	([UnitPrice] >= 0)

Identity Column

No identity column exists

Referencing Tables

No referencing tables exist

Referenced Tables

Table	Primary Key or Unique Constraint	Foreign Key
Orders	PK_Orders	FK_Order_Details_Orders
Products	PK_Products	FK_Order_Details_Products

Total: 2 table(s)

Objects that depend on [Order Details]

Object Name	Object Type	Dep Level
CustOrderHist	Procedure	1
CustOrdersDetail	Procedure	1
Invoices	View	1
[Order Details Extended]	View	1
[Order Subtotals]	View	1
[Product Sales for 1997]	View	1
SalesByCategory	Procedure	1
[Category Sales for 1997]	View	2
[Employee Sales by Country]	Procedure	2
[Sales by Category]	View	2
[Sales by Year]	Procedure	2
[Sales Totals by Amount]	View	2
[Summary of Sales by Quarter]	View	2
[Summary of Sales by Year]	View	2

Total 14 object(s)

Objects that [Order Details] depends on

Object Name	Object Type	Dep Level
Orders	Table	1
Products	Table	1
Categories	Table	2
Customers	Table	2
Employees	Table	2
Shippers	Table	2
Suppliers	Table	2

Total 7 object(s)

Column Level Dependencies

Object Name	Column	Object Type
Orders	OrderID	Table
Products	ProductID	Table

Total 2 column(s)

Graphical Dependencies

Click Here to view Dependencies Graphically

Extended Properties

No extended properties defined

Permissions

No permissions defined

Table Options

Name	Value
Pintable	OFF
Table lock on bulk load	OFF
Insert row lock	OFF
Text in row	0
Large value types out of row	0

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Order Details] (
        [OrderID]       int NOT NULL,
        [ProductID]     int NOT NULL,
        [UnitPrice]     money NOT NULL,
        [Quantity]      smallint NOT NULL,
        [Discount]      real NOT NULL
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Order Details]
    ADD
    CONSTRAINT [PK_Order_Details]
    PRIMARY KEY
    ([OrderID], [ProductID])
    ON [PRIMARY]
GO
ALTER TABLE [dbo].[Order Details]
    WITH NOCHECK
    ADD
    CONSTRAINT [CK_Discount]
    CHECK
    ([Discount] >= 0 and [Discount] <= 1)
GO
ALTER TABLE [dbo].[Order Details]
CHECK CONSTRAINT [CK_Discount]

GO
ALTER TABLE [dbo].[Order Details]
    WITH NOCHECK
    ADD
    CONSTRAINT [CK_Quantity]
    CHECK
    ([Quantity] > 0)
GO
ALTER TABLE [dbo].[Order Details]
CHECK CONSTRAINT [CK_Quantity]

GO
ALTER TABLE [dbo].[Order Details]
    WITH NOCHECK
    ADD
    CONSTRAINT [CK_UnitPrice]
    CHECK
    ([UnitPrice] >= 0)
GO
ALTER TABLE [dbo].[Order Details]
CHECK CONSTRAINT [CK_UnitPrice]

GO
ALTER TABLE [dbo].[Order Details]
    ADD
    CONSTRAINT [DF_Order_Details_Discount]
    DEFAULT (0) FOR [Discount]
GO
ALTER TABLE [dbo].[Order Details]
    ADD
    CONSTRAINT [DF_Order_Details_Quantity]
    DEFAULT (1) FOR [Quantity]
GO
ALTER TABLE [dbo].[Order Details]
    ADD
    CONSTRAINT [DF_Order_Details_UnitPrice]
    DEFAULT (0) FOR [UnitPrice]
GO
ALTER TABLE [dbo].[Order Details]
    WITH NOCHECK
    ADD CONSTRAINT [FK_Order_Details_Orders]
    FOREIGN KEY ([OrderID]) REFERENCES [dbo].[Orders] ([OrderID])
ALTER TABLE [dbo].[Order Details]
    CHECK CONSTRAINT [FK_Order_Details_Orders]

GO
ALTER TABLE [dbo].[Order Details]
    WITH NOCHECK
    ADD CONSTRAINT [FK_Order_Details_Products]
    FOREIGN KEY ([ProductID]) REFERENCES [dbo].[Products] ([ProductID])
ALTER TABLE [dbo].[Order Details]
    CHECK CONSTRAINT [FK_Order_Details_Products]

GO
CREATE INDEX [OrderID]
    ON [dbo].[Order Details] ([OrderID])
    ON [PRIMARY]
GO
CREATE INDEX [OrdersOrder_Details]
    ON [dbo].[Order Details] ([OrderID])
    ON [PRIMARY]
GO
CREATE INDEX [ProductID]
    ON [dbo].[Order Details] ([ProductID])
    ON [PRIMARY]
GO
CREATE INDEX [ProductsOrder_Details]
    ON [dbo].[Order Details] ([ProductID])
    ON [PRIMARY]
GO