Adna
2016-05-15, 07:08 AM
Database Version
1.3.5
Description
Contains all the information about a given category that can't reasonably be translated into multiple languages. All of the contained information is consistent across all installed languages.
Language-specific data about each category is found in the categories_description table.
Table Details
Primary Key
categories_id
Indexed Fields
parent_id
categories_id
categories_status
sort_order
Columns
categories_id Primary Key Index
A unique, auto incremented value, to identify each category record.
Type: int(11)
Null: No
Default:
Extra: auto_increment
categories_image
The path to the category image for the category relative to DIR_WS_CATALOG/images/.
Type: varchar(64)
Null: Yes
Default: NULL
parent_id Foreign Key Index
Links the record to a parent category. Recursive foreign key to categories_id.
Type: int(11)
Null: No
Default: 0
Info.png What it Means!
A value of 0 means that this is a top-level category.
sort_order Index
The sort order of this category. 0 = top.
Type: int(3)
Null: Yes
Default: NULL
date_added
The date and time this category was added to the database.
Type: datetime
Null: Yes
Default: NULL
last_modified
The date and time this category was last modified.
Type: datetime
Null: Yes
Default: NULL
categories_status Index
The status of the category. Can be set to 0 (disabled) or 1 (enabled).
Type: tinyint(1)
Null: No
Default: 1
1.3.5
Description
Contains all the information about a given category that can't reasonably be translated into multiple languages. All of the contained information is consistent across all installed languages.
Language-specific data about each category is found in the categories_description table.
Table Details
Primary Key
categories_id
Indexed Fields
parent_id
categories_id
categories_status
sort_order
Columns
categories_id Primary Key Index
A unique, auto incremented value, to identify each category record.
Type: int(11)
Null: No
Default:
Extra: auto_increment
categories_image
The path to the category image for the category relative to DIR_WS_CATALOG/images/.
Type: varchar(64)
Null: Yes
Default: NULL
parent_id Foreign Key Index
Links the record to a parent category. Recursive foreign key to categories_id.
Type: int(11)
Null: No
Default: 0
Info.png What it Means!
A value of 0 means that this is a top-level category.
sort_order Index
The sort order of this category. 0 = top.
Type: int(3)
Null: Yes
Default: NULL
date_added
The date and time this category was added to the database.
Type: datetime
Null: Yes
Default: NULL
last_modified
The date and time this category was last modified.
Type: datetime
Null: Yes
Default: NULL
categories_status Index
The status of the category. Can be set to 0 (disabled) or 1 (enabled).
Type: tinyint(1)
Null: No
Default: 1