A saleable product other than tickets or vouchers (eg. merchandizing).
This table represents stock. When a product is sold an entry is created in the table item.
Column Name | Type | Properties | Docu |
productid | seq32 | Primary-Key | |
name | string | ||
description | text | NULL-able | |
inventory | int32 | amount that remains in the inventory, or -1 if it is unlimited | |
price | int32 | ||
barcode | string | NULL-able | usually the EAN code |
flags | string | NULL-able | filter: who can sell this product |
tax | int32 | NULL-able | |
tags | string | NULL-able | additional tags for this product, can be used by scripts |