The Merchandise Table
The Merchandise table lists the movie-related merchandise for sale in the online store. Merchandise contains the columns in Table B.9.
Column | Datatype | Description |
---|---|---|
MerchID | Numeric (Identity) | Unique merchandise ID |
FilmID | Numeric | Movie ID |
MerchName | Text (50 chars) | Merchandise name |
MerchDescription | Text (100 chars) | Merchandise description |
MerchPrice | Real | Merchandise price |
ImageNameSmall | Text (50 chars) | Item’s small image file name |
ImageNameLarge | Text (50 chars) | Item’s large image file name |
Primary Key
MerchID
Foreign Keys
FilmID related to primary key in Films table
Get Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.