Table products description

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

Database Version

1.3.5


Description

Stores all the information about products that can be reasonably translated into multiple languages.


Table Details

Primary Key

products_id
language_id

Indexed Fields

products_name


Columns

products_id Primary Key

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


language_id Primary Key

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


products_name Index

The language specific name of the product.
Type: varchar(64)
Null: No
Default:


products_description

The language specific description of the product.
Type: text
Null: Yes
Default: NULL


products_url

The language specific URL of the product (points to the product page on the manufacturers web site as an example).
Type: varchar(255)
Null: Yes
Default: NULL


products_viewed

The number of times the given product has been viewed on the catalog side.
Type: int(5)
Null: Yes
Default: 0


Default Entries (assuming demo data installed)

TODO!