Using POSper/Developer guide/Database-Table descriptions/posper category
Appearance
posper_category
[edit | edit source]
This table describes a product category within which products are found. Eg, you might have a "drinks" category containing products like "coffee"
Column Name | Data Type | Null Allowed? | Key? | Comments |
---|---|---|---|---|
id | VARCHAR(255) | No | Primary | UUID instead of int |
version | INT(11) | No | This is used by hibernate to track table versions | |
visibleId | INT(11) | Yes | Uni | This is the user visible (user-friendly) Id |
category_name | VARCHAR(255) | No | the category name | |
parent_id | VARCHAR(255) | Yes | Foreign Key | Categories can have subcategories. If this is a subcategory, then this points to the parent category. |
image_id | VARCHAR(255) | Yes | Foreign Key | If there is an associated image, this points to it. |