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 (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]
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