Table orders products attributes

• Introduction
• Resources | Standards

• Database
• Schema

• Developers API
• Resources | Overrides |
• Tutorials

• Modules
• Overview | Payment |
• Shipping | Order Total

• Miscellaneous
• Security | XML Schemas |
• Porting modules from osC | Manually entering products

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.