Table item

This table is audited, see item_audit for details.

A sold item other than a ticket or voucher.

Column NameTypePropertiesDocu
itemidseq64Primary-Key
productidint32Foreign-Key=product(productid)
orderidint32Foreign-Key=order(orderid)
amountint32
totalpriceint32
tagsstringNULL-able additional tags for this item, can be used by scripts