jmeeuynz_digitalso
Tables categories
| Field | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| slug | varchar(255) | NULL | MUL | |
| parent_id | int | NULL | MUL | |
| tree_id | int | NULL | MUL | |
| level | int | NULL | MUL | |
| parent_tree | varchar(255) | NULL | MUL | |
| title_meta_tag | varchar(255) | NULL | ||
| description | varchar(500) | NULL | ||
| keywords | varchar(500) | NULL | ||
| category_order | mediumint | NULL | MUL | |
| featured_order | mediumint | 1 | MUL | |
| homepage_order | mediumint | 5 | ||
| visibility | tinyint(1) | 1 | MUL | |
| is_featured | tinyint(1) | NULL | MUL | |
| show_on_main_menu | tinyint(1) | 1 | MUL | |
| show_image_on_main_menu | tinyint(1) | NULL | ||
| show_products_on_index | tinyint(1) | NULL | MUL | |
| show_subcategory_products | tinyint(1) | NULL | ||
| storage | varchar(20) | local | ||
| image | varchar(255) | NULL | ||
| show_description | tinyint(1) | NULL | ||
| created_at | timestamp | CURRENT_TIMESTAMP |