Using POSper/Developer guide/Database-Table descriptions/posper product
posper_product
[edit | edit source]
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. |