Table orders products
From Zen Cart(tm) Wiki
Database Version
- 1.3.5
Description
- Stores every individual product from every order.
Table Details
Primary Key
Indexed Fields
Columns
orders_products_id 
- A unique, auto incremented value, to identify each order product record.
Type: int(11) Null: No Default: Extra: auto_increment
orders_id 
- Cross-reference link to the orders table.
Type: int(11) Null: No Default: 0
products_id
- Cross-reference link to the products table.
Type: int(11) Null: No Default: 0
products_model
- The model number of the product.
Type: varchar(32) Null: Yes Default: NULL
products_name
- The name of the product.
Type: varchar(64) Null: No Default:
products_price
- The price of the product.
Type: decimal(15,4) Null: No Default: 0.0000
final_price
Type: decimal(15,4) Null: No Default: 0.0000
products_tax
- The dollar amount of tax on the product.
Type: decimal(7,4) Null: No Default: 0.0000
products_quantity
- The quantity of the given product on the order.
Type: float Null: No Default: 0
onetime_charges
Type: decimal(15,4) Null: No Default: 0.0000
products_priced_by_attribute
Type: tinyint(1) Null: No Default: 0
product_is_free
Type: tinyint(1) Null: No Default: 0
products_discount_type
Type: tinyint(1) Null: No Default: 0
products_discount_type_from
Type: tinyint(1) Null: No Default: 0
products_prid
Type: tinytext Null: No Default:
Default Entries
- None.
