Spareparts
Index of tables:

Table tbl_relations -- List of sparepart relations for languages

Field name Field description Field type Field size key required default Observation
code_rel Code of relation VARCHAR 10 yes yes 0  
code_lng Language code {IT, EN, FR, DE, ES, RO} CHAR 2 yes yes IT The first 2 letters of the English name of the language (uppercases)
descr_rel Title of relation VARCHAR 255   yes ???  
note_rel Description of relation VARCHAR 255        

Table tbl_rel_objects -- Associates two products in a relation

Field name Field description Field type Field size key required default Observation
code Code of the product which will be the sparepart product VARCHAR 100 yes yes 0 Linked to code from tbl_objects
code_rel Relation code VARCHAR 10 yes yes 0 Linked to code_rel from tbl_relations
code_father Code of the parent product VARCHAR 100 yes yes 0 Linked to code from tbl_objects