Using POSper/Developer guide/Database-Table descriptions/posper category

posper_category 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.