Table orders products attributes

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

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 Primary Key

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


orders_products_id Index

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


products_options

Help.gif
Type: varchar(32)
Null: No
Default:


products_options_values

Help.gif
Type: blob
Null: No
Default:
Attributes: BINARY


options_values_price

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


price_prefix

Help.gif
Type: char(1)
Null: No
Default:


product_attribute_is_free

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

Help.gif
Type: char(1)
Null: No
Default:


attributes_discounted

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


attributes_price_base_included

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


attributes_price_onetime

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


attributes_price_factor

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


attributes_price_factor_offset

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


attributes_price_factor_onetime

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


attributes_price_factor_onetime_offset

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


attributes_qty_prices

Help.gif
Type: text
Null: Yes
Default: NULL


attributes_qty_prices_onetime

Help.gif
Type: text
Null: Yes
Default: NULL


attributes_price_words

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


attributes_price_words_free

Help.gif
Type: int(4)
Null: No
Default: 0


attributes_price_letters

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


attributes_price_letters_free

Help.gif
Type: int(4)
Null: No
Default: 0


products_options_id

Help.gif
Type: int(11)
Null: No
Default: 0


products_options_values_id

Help.gif
Type: int(11)
Null: No
Default: 0


products_prid

Help.gif
Type: tinytext
Null: No
Default:


Default Entries

None.