Tuesday, 26 August 2025, 10:51 AM
Created by: Mathieu Van daele
| Name | Type | Length | Null allowed | Default |
| id | integer | 11 | No | Auto increment |
| name | string | 24 | No | |
| description | string | 65535 | Yes | Null |
| image_path | string | 200 | Yes | Null |
| The image URL on our server, after downloading, prefixed by our image domain. | ||||
| enabled | boolean | No | ||
| campaign_id | integer | 11 | Yes | Null |
| If you add a whole category to a special campaign (see campaigns section for more detail), the campaign id is stored here, rendering the category unusable as a "normal" group of products. | ||||
| position | integer | 11 | No | 0 |
| The position in which to show the categories in the WhatsApp flow, when not using a web catalog. | ||||
| font_awesome | string | 100 | Yes | Null |
| Any kind of FA icon, e.g. "fa-house". | ||||
| parent | integer | 11 | Yes | Null |
| If the category is a modifier, id is the parent. E.g. toppings has pizza dough as a parent. | ||||
| minimum | integer | 11 | Yes | Null |
| Minimum quantity to choose, optional. E.g. choose atleast 1 of this category. | ||||
| maximum | integer | 11 | Yes | Null |
| Maximum quantity to choose, optional. E.g. choose at most 2 of this category. | ||||
| is_modifier | boolean | No | False | |
| Marks this category as a modifier, required to "build" a complex product. | ||||
| field_type | string | 20 | Yes | Null |
| Not being used yet. | ||||