Zen Cart Mysql Database Table categories description

[Afton]

Database Version

1.3.5


Description

Contains all the information about a given category that can reasonably be translated into multiple languages. Each language for a given category will have it's own record in this table.


Non-language specific data about each category is found in the categories table.

Table Details
Primary Keys

    categories_id
    language_id

Indexed Fields

    categories_name


Columns
categories_id Primary Key Foreign Key

    Links the record to the corresponding data in the categories table. Foreign key to categories.categories_id.

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


language_id Primary Key Foreign Key

    Links the record to the corresponding data in the languages table. Foreign key to languages.languages_id.

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


categories_name Index

    The language-specific name of the category.

    Type: 	varchar(32)
    Null: 	No
    Default: 	


categories_description

    The language-specific description of the category.

    Type: 	text
    Null: 	No
    Default: