Product


The Product table contains data regarding each of Xtreme Mountain Bikes' products.

Table B-8: Product data

Field Name

Data Type

Length

Description

Product ID

Number

Long Integer

Unique identification number assigned to each product.

Product Name

Text

50

Name of the product.

Color

Text

20

Color of the product.

Size

Text

10

Size of the product.

M/F

Text

10

States whether product is for men or women specifically.

Price (SRP)

Currency

Currency

The price of the product.

Product Type ID

Number

Long Integer

Unique identification number assigned to each product type.

Product Class

Text

50

The product class.

Supplier ID

Number

Long Integer

Unique identification number assigned to each product supplier.




Mastering Business Analysis with Crystal Reports 9
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
ISBN: 1556222939
EAN: 2147483647
Year: 2004
Pages: 177
Authors: Chris Tull

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net