I still didn’t get any answer about that
So for now every time I need to specify brand, I write all possible options, which doesn’t look as health practice. But until brands and stores don’t have separate entities in OFF DB, I don’t see any other option to in other proper way.
- זול סטוק - Hebrew brand name
- Zolstock - Same brand name, but in English
- Z.School - Subbrand of Zolstock for school products such as pens, pencils etc
- Z.School by Zolstock (one of options given in OFF app)
If it would be use relational DB, it could be something like:
Table “brands”
| brand_id | main_brand_name |
|---|---|
| 111 | זול סטוק |
| 112 | Z.School |
Table “brand_aliases”
| brand_alias_id | brand_id | xxx_lang_code | alias | alias_type |
|---|---|---|---|---|
| 34 | 111 | eng | Zolstock | legal name, name on packaging, translated_name, informal name etc. |
Table “brand_relationships”
| brand_rel_pair_id | brand_id | brand_id_1 | relationship_id |
|---|---|---|---|
| 1 | 111 (Zolstock) | 112 (Z.School) | 23 (111 ‘Zolstock’ owns brand 112 ‘Z.School’) |
It would allow also to link products with their exact brand and not link them just to approximate brand names, that in fact can be owned to different brands.
