Spareparts
|
![]() |
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 |