Table products options

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

Database Version

1.3.5


Description

Lists all the generic options available for each language. For example, color or size. It is independent of the products and holds all available options for all products. Specific options will be linked to particular products via the product_attributes table.


Also specifies the type for the option. For example, dropdown menu, text, radio button, checkbox, file or read only, and sort order, as well as less used features all of which could theoretically be varied by language.


Table Details

Primary Key

products_options_id
language_id

Indexed Fields

language_id
products_options_sort_order
products_options_name


Columns

products_options_id Primary Key

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


language_id Primary Key Index

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


products_options_name Index

The name of the product option.
Type: varchar(32)
Null: No
Default:


products_options_sort_order Index

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


products_options_type

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


products_options_length

Help.gif
Type: smallint(2)
Null: No
Default: 32


products_options_comment

Help.gif
Type: varchar(64)
Null: Yes
Default: NULL


products_options_size

Help.gif
Type: smallint(2)
Null: No
Default: 32


products_options_images_per_row

Help.gif
Type: int(2)
Null: Yes
Default: 5


products_options_images_style

Help.gif
Type: int(1)
Null: Yes
Default: 0


products_options_rows

Help.gif
Type: smallint(2)
Null: No
Default: 1


Default Entries (assuming demo data installed)

TODO!