Categories |
![]() |
The main way of accessing the products is by categorization.
Obs: Category code should not be a 0 value!
Table tbl_categories -- Contains the list of all available categories
Field name | Field description | Field type | Field size | key | required | default | Observation |
---|---|---|---|---|---|---|---|
code_cat | Code category | VARCHAR | 100 | yes | yes | 0 | Code different of 0 |
code_father | Code of the category father | VARCHAR | 100 | yes | yes | 0 | For the categories from the first level let code_father = 0 |
code_lng | Language code (e.g.: IT, EN, FR, DE, ES, RO) | CHAR | 2 | yes | yes | IT | ISO code of the language - uppercase [VIEW the table of Language Codes] |
position_cat | Position inside father category | INT | 10 | yes | 1 | ||
descr_short_cat | Name of category | VARCHAR | 50 | yes | ? | ||
descr_long_cat | Long description (may contain HTML code) | TEXT | |||||
type_cat | Type of the category | INT | 10 | 0 | Linked to type_cat from tbl_cat_type | ||
picture_cat | Picture of category shown together with description when accessing the category | VARCHAR | 255 | The picture needs to be uploaded on the server | |||
picture_cat_default | Name of common picture for products with missing picture from this category | VARCHAR | 255 | The picture needs to be uploaded on the server | |||
icon_cat | Category icon for the categories tree | VARCHAR | 255 | ||||
icon_over_cat | Category icon in mouse over for the categories tree | VARCHAR | 255 | ||||
show_cat | Flag for hiding the category on the public area (0 or 1) | CHAR | 1 | 1 | |||
cat_link | Category link | VARCHAR | 255 | e.g.: www.mylink.com | |||
cat_file | Category file | VARCHAR | 255 | e.g.: myfile.doc; the file needs to be uploaded on the server | |||
UNSPSC | United Nations Standard Products and Services Code | VARCHAR | 8 | ||||
f_txt1 | -unused field; reserved for future implementations - | TEXT | |||||
f_txt2 | -unused field; reserved for future implementations - | TEXT | |||||
f_txt3 | -unused field; reserved for future implementations - | TEXT | |||||
f_int1 | -unused field; reserved for future implementations - | TINYINT | 3 | ||||
f_int2 | -unused field; reserved for future implementations - | INT | 10 | ||||
f_txt3 | -unused field; reserved for future implementations - | INT | 10 |
Table tbl_cat_objects -- Defines the categories an article belongs to
Field name | Field description | Field type | Field size | key | required | default | Observation |
---|---|---|---|---|---|---|---|
code_cat | Category code | VARCHAR | 100 | yes | yes | 0 | Linked to code_cat from tbl_categories |
code | Product code | VARCHAR | 100 | yes | yes | 0 | Linked to code from tbl_objects |
position_obj | Product position in category | INT | 10 | yes | 0 | ||
cat_special_offer | Flag for set as special offer for the category (0 or 1) | TINYINT | 3 | 0 | = 1 if the product is special offer for the category |