Table products description

• Introduction
• Resources | Standards

• Database
• Schema

• Developers API
• Resources | Overrides |
• Tutorials

• Modules
• Overview | Payment |
• Shipping | Order Total

• Miscellaneous
• Security | XML Schemas |
• Porting modules from osC | Manually entering products

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

A unique, auto incremented value, to identify each products description record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

language_id

Cross-reference link to the languages table.

Type:	int(11)
Null:	No
Default:	1

products_name

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!