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: