Zen Cart Mysql Database Table categories

[Adna]

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