Table orders products attributes

From Zen Cart(tm) Wiki

Contents 1 Database Version 2 Description 3 Table Details 3.1 Primary Key 3.2 Indexed Fields 4 Columns 4.1 orders_products_attributes_id 4.2 orders_id 4.3 orders_products_id 4.4 products_options 4.5 products_options_values 4.6 options_values_price 4.7 price_prefix 4.8 product_attribute_is_free 4.9 products_attributes_weight 4.10 products_attributes_weight_prefix 4.11 attributes_discounted 4.12 attributes_price_base_included 4.13 attributes_price_onetime 4.14 attributes_price_factor 4.15 attributes_price_factor_offset 4.16 attributes_price_factor_onetime 4.17 attributes_price_factor_onetime_offset 4.18 attributes_qty_prices 4.19 attributes_qty_prices_onetime 4.20 attributes_price_words 4.21 attributes_price_words_free 4.22 attributes_price_letters 4.23 attributes_price_letters_free 4.24 products_options_id 4.25 products_options_values_id 4.26 products_prid 5 Default Entries

Database Version

1.3.5

Description

Stores all the attributes for products included in orders.

Table Details

Primary Key

orders_products_attributes_id

Indexed Fields

orders_id

orders_products_id

Columns

orders_products_attributes_id

A unique, auto incremented value, to identify each orders products attributes 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

orders_products_id

Cross-reference link to the orders_products table.

Type:	int(11)
Null:	No
Default:	0

products_options

Type:	varchar(32)
Null:	No
Default:

products_options_values

Type:	blob
Null:	No
Default:
Attributes:	BINARY

options_values_price

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

price_prefix

Type:	char(1)
Null:	No
Default:

product_attribute_is_free

Type:	tinyint(1)
Null:	No
Default:	0

products_attributes_weight

The weight of the given attribute.

Type:	float
Null:	No
Default:	0

products_attributes_weight_prefix

Type:	char(1)
Null:	No
Default:

attributes_discounted

Type:	tinyint(1)
Null:	No
Default:	1

attributes_price_base_included

Type:	tinyint(1)
Null:	No
Default:	1

attributes_price_onetime

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

attributes_price_factor

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

attributes_price_factor_offset

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

attributes_price_factor_onetime

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

attributes_price_factor_onetime_offset

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

attributes_qty_prices

Type:	text
Null:	Yes
Default:	NULL

attributes_qty_prices_onetime

Type:	text
Null:	Yes
Default:	NULL

attributes_price_words

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

attributes_price_words_free

Type:	int(4)
Null:	No
Default:	0

attributes_price_letters

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

attributes_price_letters_free

Type:	int(4)
Null:	No
Default:	0

products_options_id

Type:	int(11)
Null:	No
Default:	0

products_options_values_id

Type:	int(11)
Null:	No
Default:	0

products_prid

Type:	tinytext
Null:	No
Default:

Default Entries

None.