Table products options values to products options

From Zen Cart(tm) Wiki
Revision as of 12:52, 14 October 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Used by the attributes system to keep track of which products_options_values are legitimate for each products_option. Thus, for example, it might link the products_options size with the products_options_values S, M, L and XL and the products_options color with the products_options_values red, white and blue.


Table Details

Primary Key

products_options_values_to_products_options_id

Indexed Fields

products_options_id
products_options_values_id


Columns

products_options_values_to_products_options_id Primary Key

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


products_options_id Index

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


products_options_values_id Index

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


Default Entries (assuming demo data installed)

TODO!