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

From Wikibooks, open books for an open world
< Using POSper‎ | Developer guide‎ | Database-Table descriptions
Jump to navigation Jump to search


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.