O'Reilly logo

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started by Charlie Arehart, Raymond Camden, Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The MerchandiseOrdersItems Table

The MerchandiseOrdersItems table contains the items in each order. MerchandiseOrdersItems contains the columns in Table B.11.

Table B.11. The MerchandiseOrdersItems Table
ColumnDatatypeDescription
OrderItemIDNumeric (Identity)Unique order item ID
OrderIDNumericOrder ID
ItemIDNumericOrdered item ID
OrderQtyNumericNumber of items ordered
ItemPriceRealItem sale price

Primary Key

  • OrderItemID

Foreign Keys

  • OrderID related to primary key in MerchandiseOrders table

  • ItemID related to primary key in Merchandise table

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required