Table orders products

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.5


Description

Stores every individual product from every order.


Table Details

Primary Key

orders_products_id

Indexed Fields

orders_id
products_id


Columns

orders_products_id Primary Key

A unique, auto incremented value, to identify each order product record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


orders_id Index

Cross-reference link to the orders table.
Type: int(11)
Null: No
Default: 0


products_id Index

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

Help.gif
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

Help.gif
Type: decimal(15,4)
Null: No
Default: 0.0000


products_priced_by_attribute

Help.gif
Type: tinyint(1)
Null: No
Default: 0


product_is_free

Help.gif
Type: tinyint(1)
Null: No
Default: 0


products_discount_type

Help.gif
Type: tinyint(1)
Null: No
Default: 0


products_discount_type_from

Help.gif
Type: tinyint(1)
Null: No
Default: 0


products_prid

Help.gif
Type: tinytext
Null: No
Default:


Default Entries

None.