网络营销电子商务研究中心 - Zen Cart Mysql Database Table categories description

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.

Code:

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: