E-bussines tables (WEB-PROFESSIONAL)

Categories

Index of tables:

tbl_categories - list of categories
tbl_cat_objects - defines the categories an article belongs to

The main way of accessing the products is by categorization.

The hierarchy of categories is one of the type 'one to many'.A category can be a descendent of many father categories.
The position inside the father category is given by the "position" field from tbl_categories.
A product is included in a certain category by a link in tbl_cat_objects.
Certain details must be specified: the code of the product, the code of the category and the position of the product within the category.

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	Observation
code_cat	Category code	VARCHAR	100	yes	yes	Linked to code_cat from tbl_categories
code	Product code	VARCHAR	100	yes	yes	Linked to code from tbl_objects
position_obj	Product position in category	INT	10		yes
cat_special_offer	Flag for set as special offer for the category (0 or 1)	TINYINT	3			= 1 if the product is special offer for the category