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

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

posper_product[edit]


This table describes products (items for sale).

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
reference VARCHAR(255) No Uni This is the user visible (user-friendly) Id
inStock BIT(1) No whether the product is available
com BIT(1) No If this is true then the product is auxillary, also known as an "add on" or "side". What this means is that you can do things like "salad with add on bacon strips for a bit of extra cost", and if you delete the salad then the strips are removed too because they're part of the salad. However, this field does not prevent you from being able to order the item on its own if you like, it only associates to a "non-side" product if it's directly below it.
scale BIT(1) No This is used for products where the number of "units" is determined by a scale. If this is set true, AND a scale is properly configured, then when this is added to a ticket the weight is read from the scale and used as the number of units, which then determines price.
priceBuy DOUBLE No The cost of this item to the business
priceSell DOUBLE No The price that the business sells this product for
stockCost DOUBLE Yes described in the products editor as "stock cost by year", this is unused by the application other than allowing it to be edited : it would presumably be used just to allow the users to know how much it costs to have a unit of this product sitting in the warehouse for a year.
volume DOUBLE Yes This is unused by the application other than allowing it to be edited : it would presumably be used just to allow the users to know what the product's volume is, without effecting how the application actually operates.
displayOrder INT(11) Yes sets the order of display, eg, if this is set to 4 it will be the fourth product shown in the catalog.
description VARCHAR(255) No Description/name of the product
code VARCHAR(255) Yes the product's barcode
tax_id VARCHAR(255) No Foreign Key The tax associated with this product (create a "zero tax" tax for an untaxed product)
image_id VARCHAR(255) Yes Foreign Key If an image is associated with this product, this points to it (foreign key)
category_id VARCHAR(255) No Foreign Key this points to the category the product is part of.