Categories
Index of tables:

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 {IT, EN, FR, DE, ES, RO} CHAR 2 yes yes IT Code lng is represented by the first 2 letters of the English name of the language (uppercases)
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