Table products options values to products options

From Zen Cart(tm) Wiki
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!