Difference between revisions of "Table products attributes"

From Zen Cart(tm) Wiki
Jump to: navigation, search
Line 1: Line 1:
{{Template:menuBarDevelopers}}
 
== Database Version ==
 
:1.3.5
 
  
 
== Description ==
 
:Stores all the information about a given product option that gives the product attributes.
 
 
 
== Table Details ==
 
=== Primary Key ===
 
:[[Table products_attributes#products_attributes_id|products_attributes_id]]
 
 
=== Indexed Fields ===
 
:[[Table products_attributes#products_id|products_id]]
 
:[[Table products_attributes#options_id|options_id]]
 
:[[Table products_attributes#options_values_id|options_values_id]]
 
:[[Table products_attributes#products_options_sort_order|products_options_sort_order]]
 
 
 
== Columns ==
 
=== products_attributes_id [[Image:Primary_key.gif|Primary Key]]===
 
:A unique, auto incremented value, to identify each product attribute record.
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(11)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|-
 
| Extra: || auto_increment
 
|}
 
</BLOCKQUOTE>
 
 
 
=== products_id [[Image:Index.gif|Index]]===
 
:Cross-reference link to the [[Table products|products]] table.
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(11)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== options_id [[Image:Index.gif|Index]]===
 
:Cross-reference link to the [[Table products_options|products_options]] table.
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(11)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== options_values_id [[Image:Index.gif|Index]]===
 
:Cross-reference link to the [[Table products_options_values|products_options_values]] table.
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(11)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== options_values_price ===
 
:The price for this particular attribute.
 
<BLOCKQUOTE>
 
{|
 
| Type: || decimal(15,4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0.0000
 
|}
 
</BLOCKQUOTE>
 
 
 
=== price_prefix ===
 
:Does the options_values_price increase or decrease the amount. Can be set to ''+'' (increase), ''-'' (decrease) or left blank (increase).
 
<BLOCKQUOTE>
 
{|
 
| Type: || char(1)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
<BLOCKQUOTE>{{hintBox|Hint!|Using ''+'' increases the amount, ''-'' decreases the amount.}}</BLOCKQUOTE>
 
<BLOCKQUOTE>{{hintBox|Hint!|"Blank" increases the amount; useful when base price is 0 and each option shows the full product price, and "+$xx.xx" display would give the wrong impression to customers.  Set default prefix in Catalog > Product Types > (select type) > Edit Layout > PRODUCT Attribute Price Prefix - Default.}}</BLOCKQUOTE>
 
 
 
=== products_options_sort_order [[Image:Index.gif|Index]] ===
 
:The sort order of the attribute if there are other attributes for the option.
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(11)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== product_attribute_is_free ===
 
:Is this product attribute is free or not? Can be set to ''0'' (no) or ''1'' (yes).
 
<BLOCKQUOTE>
 
{|
 
| Type: || tinyint(1)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== products_attributes_weight ===
 
:The weight (either posative or negative) of the attribute.
 
<BLOCKQUOTE>
 
{|
 
| Type: || float
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== products_attributes_weight_prefix ===
 
:Does the products_attributes_weight increase or decrease the weight. Can be set to ''+'' (increase) or ''-'' (decrease).
 
<BLOCKQUOTE>
 
{|
 
| Type: || char(1)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
<BLOCKQUOTE>{{hintBox|Hint!|Using ''+'' adds weight, ''-'' takes off weight.}}</BLOCKQUOTE>
 
 
 
=== attributes_display_only ===
 
:Is this attribute for display only? Can be set to ''0'' (no) or ''1'' (yes).
 
<BLOCKQUOTE>
 
{|
 
| Type: || tinyint(1)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_default ===
 
:Should this attribute default to on? Can be set to ''0'' (no) or ''1'' (yes).
 
<BLOCKQUOTE>
 
{|
 
| Type: || tinyint(1)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_discounted ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || tinyint(1)
 
|-
 
| Null: || No
 
|-
 
| Default: || 1
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_image ===
 
:The path to the image file for this attribute.
 
<BLOCKQUOTE>
 
{|
 
| Type: || varchar(64)
 
|-
 
| Null: || Yes
 
|-
 
| Default: || ''NULL''
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_price_base_included ===
 
:Should the attribute include the base price? Can be set to ''0'' (no) or ''1'' (yes).
 
<BLOCKQUOTE>
 
{|
 
| Type: || tinyint(1)
 
|-
 
| Null: || No
 
|-
 
| Default: || 1
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_price_onetime ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || decimal(15,4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0.0000
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_price_factor ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || decimal(15,4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0.0000
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_price_factor_offset ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || decimal(15,4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0.0000
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_price_factor_onetime ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || decimal(15,4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0.0000
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_price_factor_onetime_offset ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || decimal(15,4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0.0000
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_qty_prices ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || text
 
|-
 
| Null: || Yes
 
|-
 
| Default: || ''NULL''
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_qty_prices_onetime ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || text
 
|-
 
| Null: || Yes
 
|-
 
| Default: || ''NULL''
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_price_words ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || decimal(15,4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0.0000
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_price_words_free ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_price_letters ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || decimal(15,4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0.0000
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_price_letters_free ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(4)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
=== attributes_required ===
 
:[[Image:Help.gif]]
 
<BLOCKQUOTE>
 
{|
 
| Type: || tinyint(1)
 
|-
 
| Null: || No
 
|-
 
| Default: || 0
 
|}
 
</BLOCKQUOTE>
 
 
 
== Default Entries (assuming demo data installed) ==
 
:TODO!
 

Revision as of 00:36, 5 December 2007